Convert Table To JSON

[Alc2020]

Hi,

I have the following table.

		home_address
first_name	last_name	address_line1	address_line2	city	state	zip	country
John	Doe	#123 Street 123	Suite 123	Brooklyn	New York	12312	US
Name2
and so on

How can I make this into a JSON output like below?

{
  "first_name": "John",
  "last_name": "Doe",
  "home_address": {
    "address_line1": "#123 Streat 123",
    "address_line2": "Suite 123",
    "city": "Brooklyn",
    "state": "New York",
    "zip": "12312",
    "country": "US"
  }
}

Thank you very much.

[christine_assaad · Accepted solution]

Hi @Alc2020 

Please check the attached. I built a hierarchy for the address to appear the way you want it. Hope it helps. Cheers!

[ChiN]

hi @Alc2020 ,

We have Json build tool that can do that. Check out the workflow attached. Does this format work for you?

[messi007]

@Alc2020,

Please see below:

Attached the workflow,

Hope that Helps,

Regards,

[Alc2020]

Thank you very much for your help!