Iterating through datatable, writing JSON Array results back to row

Build
#1

I’m using the “For Each” action to go through a Datatable, pushing the value from the first column to an API, return a JSON array.

So for example, “101” returns:
[
{
“value”: “Red”,
“session_user_id”: “jsmith”,
“last_modified”: “2019-09-16T13:27:13Z”
},
{
“value”: “Blue”,
“session_user_id”: “sjones”,
“last_modified”: “2019-09-15T17:59:07Z”
}
]

“102” returns
[
{
“value”: “Orange”,
“session_user_id”: “jsmith”,
“last_modified”: “2019-06-25T21:52:56Z”
}
]

And so on. The formatting is consistent but I have no idea how many items will return with each call.
When done, I want to end up with a datatable that looks like this:

image

How do I do that?

#2

@bzilch

Can you post the entire JSON, I will try and get back to you?

Actually, if you can get the values, simply store them in an array or list so that you can loop and add them to data table using build data table and add data row activities.

Otherwise, you can use write cell activity to write data directly to excel while looping the JSON