Answered

Parse JSON with changing name

(0) Share

Report

Posted on by grovercorner2

How can I loop through or parse the following JSON received from JotForm? The question is in the 'name' part of the JSON, and the answer in the 'value'. The question can change with each response received so I can't use the normal expressions or Parse JSON function.

notepad++_2022-09-02_12-53-53.png

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @grovercorner2 ,

Unfortunately, power automate can't parse json with dynamic names.

Please make sure that the name of key is unchanged.

Hopefully it makes sense.

Best Regards,

Wearsky

Was this reply helpful? Yes No
grovercorner2 49 on at

Like (0)

Report
Copy link

Link copied!

Yes, it makes sense, and I have no idea why a large SAAS provider like Jotform would implement something like this. But sadly there is a 0% chance they will change their API upon my request, and I can't wait for them to release a new version of their API.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @grovercorner2 ,

I don't know if it is a solution but I want to share it.

So the key is to get the dynamic field name.

I create a simple sample.

split(split(string(variables('var')),'":"')?[0],'"')?[1]

// We can use this expression to extract the field name

variables('var')?[outputs('Compose')]

Now we can extract the values from the columns with dynamic name.

But if your data is more complex, the expressions will also be more complex.

Best Regards,

Wearsky

Was this reply helpful? Yes No
grovercorner2 49 on at

Like (0)

Report
Copy link

Link copied!

Thanks. I think this is a step in the right direction. But it doesn't take into account the json has multiple rows. How to isolate the first row to use as input to your steps?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @grovercorner2 ,

Could you share a json sample?

Best Regards,

Wearsky

Was this reply helpful? Yes No