I am using Json Build option to create a json ouput file but the problem is that I dont need my records inside an object
For example
The output Alteryx is producing is
{
"Record": [
{
"Customer Number": null,
"Customer Name": "Tariq Jamal",
"Email": "tariq003@syntio.com",
"Phone": "4169951111",
"City": "Toronto",
"Status": "Activated",
"Last Modeified": "2019-10-24 08:53:45",
"CVP Card": "2005267074657860000"
},
{
"Customer Number": null,
"Customer Name": "Jeff V",
"Email": "jeffv@gmail.com",
"Phone": "5325737363",
"City": "Oakville",
"Status": "Activated",
"Last Modeified": "2019-04-24 09:20:48",
"CVP Card": "1025753780104880000"
}
]
}
But i need
[
{
"Customer Number": null,
"Customer Name": "Tariq Jamal",
"Email": "tariq003@syntio.com",
"Phone": "4169951111",
"City": "Toronto",
"Status": "Activated",
"Last Modeified": "2019-10-24 08:53:45",
"CVP Card": "2005267074657860000"
},
{
"Customer Number": null,
"Customer Name": "Jeff V",
"Email": "jeffv@gmail.com",
"Phone": "5325737363",
"City": "Oakville",
"Status": "Activated",
"Last Modeified": "2019-04-24 09:20:48",
"CVP Card": "1025753780104880000"
}
]
I am attaching my workflow
Solved! Go to Solution.
@tjamal1 The reason why the record tag is being created is you can't create an array at the top level without having having a array.
What you can do is use the formula tool to update the JSON file created.
Replace([JSON], '{"Record":', '')
Replace([JSON], Right([JSON], 3), '}]')
These formulas will remove the Record: and fix the JSON brackets.
@tjamal1 Attached is the workflow.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |