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.
groupId | |
group1 | email1@domain.com |
group2 | email2@domain.com |
... | ... |
How can I make my data formatted like below?
{
"members":[
{
"id":"group1",
"email":"email1@domain.com"
}
]
}
Thank you very much in advance!
Solved! Go to Solution.
I made the Workflow using JSON Build tool.
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.
Awesome @AkimasaKajitani ! This is exactly what I wanted. Thanks much.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |