Hi, I have a json file in onedrive and I wish to get an array of values from it. The json file has an array of objects contained in it.
[ { "First": "" "Last": "" "Address" : "" }, { "First": "" "Last": "" "Address" : "" } ]
Steps
at this point I get the error
"ActionFailed. An action failed. No dependent actions succeeded." Anyway this seems like a lot of work to just get a bunch of values which could easily be done if I were using something like jsonPath.
Maybe my approach is incorrect. Any help here would be appreciated. Tks
Hi @ld,
Please check the following blogs for a reference:
USING JSON IN MICROSOFT FLOW
https://sergeluca.wordpress.com/2017/11/23/using-json-in-microsoft-flow-part-1/
A Thesis on the Parse JSON action in Microsoft Flow
http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow
Best regards,
Mabel
thanks @v-yamao-msft I've looked at both of those and cannot see anything thats going to help.
Do advanced examples of flows exist using expressions and json. May someone could point be to those?
Hi ID,
Could you please help opening the json file from sharepoint / onedrive and convert the base 64 to a json object, Parse JSON... please
Can anyone, please help me to open a json file from sharepoint, convert the base 64 to json object, so I can parse JSON and then use the json data in my flow..
Please, help me !!!
@apc_and_rod, perhaps this thread would be helpful to you.
Do you have a flow already created that is erroring out? You'll need to be a bit more specific as to what trouble you're having in the process.
All good now, the problem was null values in some fields, replaced them for "".
User | Count |
---|---|
25 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
51 | |
29 | |
28 | |
24 | |
22 |