As we know, ‘\’ is an escape character. In your case, this symbol appears because it is used to escape one double quote inside a pair of double quotes.
For example, “\”” => “””.
But it doesn’t matter, we only need to convert it from string type to json type, it will automatically remove escape characters. I’ve created a test to verify it.
- First, I defined an Array type variable.
- My Lookup activity’s output is as follows:
- Then I used an AppendVariable activity and used an expression
@json(activity('Lookup1').output.firstRow.value)to convert it from string type to json type.
- After I run debug, we can see the result as follows, there is no ‘\’.
CLICK HERE to find out more related problems solutions.