Alteryx Designer Desktop Discussions

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

converting Table to JSON response

itskris5
5 - Atom

Hello Alteryx Community,

 

I am trying to convert a table data to JSON.

 

example table has the following values.

 

ID: 1
First_Name: Jane
City: London

Country: UK
Participant: 123

I am looking to have the above values converted to the following format. 

{
"values" : {
"ID" : "1" ,
"First_Name" : "Jane" ,
"City" : "London" ,
"Country" : "UK" ,
"Participant" : "123" 
}}

Appreciate the help. Thank you.
1 REPLY 1
echuong1
Alteryx Alumni (Retired)

You'll have to make some modifications, but the JSON Build tool is a good starting place.

 

echuong1_0-1617153687187.png

 

Labels
Top Solution Authors