Get Array from Json

[ld]

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

• get the file from onedrive using "Get file content using path"
• convert the base64 to a json object
• Parse JSON
• Initialize variable
• Apply to each & Append to variable array

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

[v-yamao-msft]

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

[ld]

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? 

[jho]

@ld i have the same questions, did you get any solution for this?

[Murderbot]

@jho This seems to work: 

split(replace(replace(string(body('YOUR ACTION NAME')),'{',''),'}',''),',')

from this post. 

[apc_and_rod]

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

[apc_and_rod]

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 !!!

[Murderbot]

@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.

[apc_and_rod]

All good now, the problem was null values in some fields, replaced them for "".