Append JSON body responses without parsing

(0) Share

Report

Posted on by michaelshparber

111

I am making a series of API calls via Do..until action.

Each call returns a body response in this form:

[
{
"id": "123",
"status": "CLOSED"
},
{
"id": "456",
"status": "ACTIVE"
}
]

Ho do I append all the responses without using Parse JSON?

I just want to save the appended results as a .json file in Sharepoint.

The problem is that it's appending the square brackets [] from each response together like this (see problem in red):

[
{
"id": "123",
"status": "CLOSED"
},
{
"id": "456",
"status": "ACTIVE"
}
]
[
{
"id": "999",
"status": "CLOSED"
},
{
"id": "888",
"status": "ACTIVE"
}
]

I would like to get this instead (please see comma instead of brackets between the call results:

[
{
"id": "123",
"status": "CLOSED"
},
{
"id": "456",
"status": "ACTIVE"
},
{
"id": "999",
"status": "CLOSED"
},
{
"id": "888",
"status": "ACTIVE"
}
]

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report
The calls are returning an array, which is correct from the point of view of an API call that can potentially return more than one result. So I would do this:

Create an array variable of your own.
Do your API call.
Append the output to your new variable using the expression first(API_Call_Result). This will get the first (and only hopefully) record from within the returned results, and give you an array of results.
Does that make sense?

Was this reply helpful? Yes No
michaelshparber 111 on at

Like (0)

Report

Each of my responses returns an array of many results.
In my sample above there are two results - for each call. So I need total of four results.
So first() is not enough.
In real world I have hundreds of results in each call. So I thought of appending it just as variables - but the brackets get in the way...

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (3)

Report
Actually there is a much easier way. Just union the results together.

Make an array variable.
Do all of your API calls.
Create a compose which uses a union expression to join all of your results into one array.
Assign the output of the compose to your array variable if you need to (but might not be required).
Much better solution.

Was this reply helpful? Yes No
michaelshparber 111 on at

Like (0)

Report

Union! Awesome!
I just need to have to somehow to save this array as a .json file.
How do I do it without Parsing?
In File Content - it allows me only to chose string variables, but now I have an array variable...
Please help @Paulie78

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report
Just convert it to a string with an expression like this:
string(variables('testArray'))

Was this reply helpful? Yes No