Converting dictionary to a different JSON response

Question

Hi, 
 How can I convert the below dictionary- 
 { name:"Vivek", place:"XYZ" } 
 
 to something like this:

"{\"name\":\"Vivek\",\"place\":\"XYZ\"}" 
 
 It is a bit from what a!toJson function returns. Any lead will be helpful. 
 
 Thanks!

Stefan Helzle · Accepted Answer

What is your use case? 
 If you really need to do that, you can do a toJson() followed by a substitute() call to replace " with \". 
 Feels like you want to escape a JSON string. For this you would need to escape more characters. 
 docs.microsoft.com/.../how-for-json-escapes-special-characters-and-control-characters-sql-server

baratc · Answer

Hi Vivek 
 Please try the below code which is closer to your output. 
 a!localVariables( local!data:{ {name:"Vivek", place:"XYZ"} } , local!final:substitute(insertkeyval("name",local!data["name"],"\","\"),"=","\:\"), local!final2:substitute(insertkeyval("place",local!data["place"],"\","\"),"=","\:\"), local!data2:concat(local!final,",",local!final2), local!data2 
 ) 
 
 sample output "
ame\:\Vivek\,\place\:\XYZ\"

Converting dictionary to a different JSON response

Top Replies