Reformat JSON output - single quotes

Question

I need to reformat a JSON output that I received from a CSV file. The specific issue is with the value "Prop_2":"Horse'", where I want to replace the single quote. I attempted to use the expression replace(@{variables('JsonData')},''', '*'), but it didn't yield the expected result.

Can you advise on the correct way to format the JSON output to achieve my goal?

Answer 1

You can use this expression :

@replace(variables('var1'),'''','*')

Check this thread, it is similar to your issue : https://stackoverflow.com/questions/77730234/how-to-replace-single-quote-in-json-with-a-special-character-in-azure-data-facto