JSON parse multiple records

[fardeen9983]

In my scenario, I have multiple API calls that I make through the download tool, and against each URL record I am getting the DownloadData as JSON response of the same structure. Now I want to parse this data turning it to a tabular format. The response has following structure

{
    "value" : [
      {
        "field1" : val,
        "field2" : val,
        .....
      } 
    ]
}

So after JSON parsing I get following data format

JSON_Name	JSON_value
value.0.field1 //1st response	val
value.1.field2	val
value.0.field1 // 2nd response	val

Passing this as input to text to column will combine values from different responses into single record. So how do i differentiate between them?

[randreag · Accepted solution]

Hi @fardeen9983 

You can use the tile to help you identify each field

I attached an example 

I hope it helps

[dougperez]

Have you tried to use Regex or JSON Parse to parse this?