JSON array without key - Logic Apps Azure

Question

My JSON array is as follows.

[{"20656":"20656","20648":"20648","20666":"20666","20657":"20657","20658":"20658","20659":"20659","20660":"20660","20665":"20665","20672":"20672","20667":"20667","24517":"24517","20677":"20677","20662":"20662","24605":"24605","20675":"20675","20663":"20663","20649":"20649","20664":"20664","20668":"20668","20669":"20669","20670":"20670","20671":"20671","20673":"20673","20674":"20674","20676":"20676"}]

How do I use each individual value and use it as a variable for my next query.

Thanks,

Can you contact the provider and ask them to send you JSON that is more in the spirit of JSON? Even just an Array of values would be better. The format they chose is (variable element names) adding unnecessary complication. — DTRT
– DTRT, Commented Aug 31, 2019 at 12:36

Adam Marczak · Accepted Answer · 2019-08-30 09:43:48Z

1

Assuming your variable looks like this

Add Select Action

Which has From property set to

split(replace(replace(replace(variables('MyJsonArray'),'[{',''),'}]',''),'"',''),',')

And Map to pair MyID with expression

substring(item(),0,lastIndexOf(item(),':'))

Now you can simply iternate over all IDs with simple Foreach and refer to each ID by using expression

item()['MyID']

answered Aug 30, 2019 at 9:43

Adam Marczak

2,35111 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dinesh Bhardwaj Over a year ago

perfect. Works!

Hury Shen · Accepted Answer · 2019-08-30 07:23:11Z

0

You can use "Parse JSON" action to parse your json data.

First, I create a "Initialize variable" action to store the json data(shown as below screenshot)

Then create "Parse JSON" action to parse the json object above.

If you don't know how to create the schema, you can click "Use sample payload to generate schema" and input your json data into it. It will generate the schema for you automatically. You can also refer to this tutorial: https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-perform-data-operations#parse-json-action

After that, we can use each individual value as variable in our logic app.(I created "Initialize variable 2" in the screenshot below as an example).

edited Aug 30, 2019 at 7:23

answered Aug 30, 2019 at 6:41

Hury Shen

15.8k1 gold badge11 silver badges20 bronze badges

2 Comments

Hury Shen Over a year ago

Sorry, the "Type" in the first screenshot should be "Array". I have updated my answer.

Dinesh Bhardwaj Over a year ago

I tried that but the values change every month. So, parse JSON gets confused.

Collectives™ on Stack Overflow

JSON array without key - Logic Apps Azure

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related