I am reading JSON data from SQL Database in Azure Data Factory. I have Azure Data Factory (ADF) pipeline, contains "Lookup" activity, which reads the JSON Data from SQL DB and bring into ADF Pipeline. Somehow the escape character (" \ ") get inserted in JSON data when I see at the output of Lookup activity of ADF.
For Example, the output of Lookup activity become like this: {\ "resourceType\ ":\ "Sales","id" :\ "9i5W6tp-JTd-24252\ "
Any idea how to remove the escape character from JSON in pipeline?
Update:
Thanks for the update Joseph. When I try your steps, It doesn't work for me.
- In lookup am reading data from SQL DB.
- This is my Append variable:
After running it, I still see escape character
{
"firstRow": {
"JSONData": "{\"resourceType\":\"counter\",\"id\":\"9i5W6tp-JTd- and more
{"resourceType":"Sales","id":"9i5W6tp-JTd-24252"}
to{"resourceType":Sales,"id":9i5W6tp-JTd-24252}
,like this? - Joseph Xu