Create a nested array

(0) Share

Report

Posted on by Dubbel_Lars

Hi everyone,

I need to create a JSON array to send to a REST API, the format the API expects is like this:

I have managed to create the array from my data with a select element, after that i have used another select element and now my result looks like this

The only thing remaining is adding to each array element the element and field tags so the API i am sending to understands it, but after many hours of trying i cannot find an option to do this. Can anyone help me?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @Dubbel_Lars
According to your expected json format , it seems it is not a invalid json. You have two same keys in your json format:

Can you check if your expected result is like this:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Dubbel_Lars 23 on at

Like (0)

Report

Ah, i did not know that keys needed to be unique. I am new with JSON and the API accepted my first result so because of that i thought i was doing the correct thing. Thanks for this advice!

The format you are sharing does not work, but i did it like this and that gives a valid JSON result and is working in the API i am sending to.
The only question remains is, how to do this in Powerautomate? The result that i got in Powerautomate so for as i mentioned earlier is this:

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Hi , @Dubbel_Lars
For your api , can trigger two times with twice json:

{ "KnContact": { "Element": { "Fields": { "BcCoOga": "1000456", "BcCoPer": "1002119", "CdId": "1654", "Vikc": "PRS", "TeNr": "0751234567", "NbNr": "0621345678" } } } }
{ "KnContact": { "Element": { "Fields": { "BcCoOga": "1000455", "BcCoPer": "1002118", "CdId": "1652", "Vikc": "PRS", "TeNr": "0751234567", "NbNr": "0621345678" } } } }

Or you need put it just in one json object?
As in Power Automate , if i give this json , the result is as follows:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Dubbel_Lars 23 on at

Like (0)

Report

I want to put it in one JSON object, the way i am trying to achieve this is like this:
And this gives me this output:
So what do i need to do in my flow to get to this result:

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (0)

Report

Hi , @Dubbel_Lars
Thanks for your detailed description. This is my test flow and the result :
(1)My compose is the test data :
(2)The initialize variable action:
(3)The Apply to each action:
range(0,length(outputs('Compose')?['KnContact']))
outputs('Compose')?['KnContact']?[items('Apply_to_each')]
if( equals(items('Apply_to_each'),0) ,'',items('Apply_to_each'))
body('Select_2')?[0]

(3)The last action:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No