Remove back slashes from final json output

jakaur32

Hello,

I am attaching my correct  excel input however right after json build tool backslashes get added to my final output.  which shouldn't be the case.  below is the attached final output as well as the workflow.

Below is the actual output i should be getting in the json format.

[
{
"areaCode": "12345",
"areaName": "12345_name",
"State": {
"City": ["York","Mills","Flushing"],
"Zip": "11800"
},
"Country": {
"NA": "America",
"EU": "Germany"
}
},
{
"areaCode": "23451",
"areaName": "23451_name",
"State": {
"City": ["Mills","Flushing"],
"Zip": "10000"
},
"Country": {
"NA": "Canada",
"EU": "Spain"
}
},
{
"areaCode": "34512",
"areaName": "34512_name",
"State": {
"City": [""],
"Zip": "30000"
},
"Country": {
"NA": "Canada",
"EU": "Spain"
}
}
]

Sample Data for Products.xlsx

Sample Workflow.yxmd

IraWatt

Hey @jakaur32,

Heres how you can correct your input to get the JSON build to work:

Exampe Workflow.yxmd