Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

JSON parse multiple records

fardeen9983
8 - Asteroid

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_NameJSON_value
value.0.field1 //1st responseval
value.1.field2val
value.0.field1 // 2nd responseval

 

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

2 REPLIES 2
randreag
11 - Bolide

Hi @fardeen9983 

 

 

You can use the tile to help you identify each field

 

I attached an example 

 

I hope it helps

dougperez
12 - Quasar

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

Labels