How to remove unwanted \ from JSON output

[ClaytonA]

I am trying to remove unwanted characters from my JSON output file.

Value before RegEx_Replace = "{\"Test\":\"Attribute1\"}"

Instead I would like to output "{"Test":"Attribute"}" or {"Test":"Attribute"} for the value part of the JSON.

When I try to remove the \" and just put a single " (double quote), Alteryx automatically puts a \" to replace it.

I am assuming this is just the formatting of the JSON but need to remove the \'s to achieve one of the desired outputs above. 

Please let me know if I am doing something incorrect.

Thank you for your help in advance. 

[IraWatt]

Hey @ClaytonA,

The JSON build tool requires you to format your data into a JavaScript object structure like this for it to figure out what is an array/object/value/ect:

Check the JSON parse tool example to get an idea of how to structure your data for it. The example I attached creates a customer list JSON with each customer having the fields User ID and Profile Final which is the outputted perfectly to a JSON file: