Parse JSON with changing name

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

[v-xiaochen-msft]

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

[grovercorner2]

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.

[v-xiaochen-msft · Accepted solution]

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

[grovercorner2]

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?

[v-xiaochen-msft]

Hi @grovercorner2 ,

Could you share a json sample?

Best Regards,

Wearsky