Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
aruiz-itp
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