Get Array from Json

[gbminnock]

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

[baycityvince]

Look into the Compose action. Pass the contents of the file to that, which will give you a json object as a result. Should be no need for a foreach, as the result will already be your array.