Unanswered

Using JSON with Dynamic Keys

(0) Share

Report

Posted on by JeremyGibbs

I'm stuck...any help would be greatly appreciated!

I'm getting data from an API that uses dynamic keys, I just need to post the records into a table in Dataverse but I can't get it into an array so I can use an apply to each.

Example of the data attached.

json.docx

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

TYL 1,091 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@JeremyGibbs You can use the "parse JSON" action to parse your API output. Afterwards you can use the values that are within the API output as variables. One of them should be your array that you are seeking for. Put this array in a for each and define what you want to do with each item. I assume you want to write to a Dataverse table, so set that as an action in the "for each".

Was this reply helpful? Yes No
TYL 1,091 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@JeremyGibbs If you are using a custom connector, you can define the response by providing an example output. Simply copy the output you get from the API and the custom connector functionality will identify the possible variables. Again, this is just when u use custom connector. If you use the http request function, then you can consider this suggestion not given 😁!

Was this reply helpful? Yes No
JeremyGibbs on at

Like (0)

Report
Copy link

Link copied!

The issue is the dynamic keys though, if I manually select body('Parse_JSON')?['350544503560933'] for example, I get the array I need but the key won't always be the same.

Was this reply helpful? Yes No