Alteryx Designer Desktop Discussions

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

JSON Build adding member to a group

Alc2020
7 - Meteor

I have a sample data like below.  I'm trying to use JSON build in preparation for uploading my data to my API.  I have a problem with the formatting.  Any help please from anyone would be great.

 

groupIdemail
group1email1@domain.com
group2email2@domain.com
......

 

How can I make my data formatted like below?

 

 

{
   "members":[
      {
         "id":"group1",
         "email":"email1@domain.com"
      }
   ]
}

 

 

Thank you very much in advance!

 

3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus

If your data is really that simple then I would consider building your JSON using the formula and summerize tools.

 

BenMoss_0-1617436918017.png

 

Ben

AkimasaKajitani
17 - Castor
17 - Castor

I made the Workflow using JSON Build tool.

 

AkimasaKajitani_0-1617454925544.png

Output result :

{"members":[{"id":"group1","email":"email1@domain.com"},{"id":"group2","email":"email2@domain.com"}]}

 

When you would use JSON Build tool, you can refer the output of JSON Parse tool. Because JSON parse tool's output is the same of JSON Build tool's input.

AkimasaKajitani_2-1617455132612.png

 

AkimasaKajitani_1-1617455106154.png

 

Alc2020
7 - Meteor

Awesome @AkimasaKajitani !  This is exactly what I wanted.  Thanks much.

Labels