We found an invalid escape sequence in JSON input

[ROQTEduardo_Lar]

Hello! i'm having a problem with a connection, when i try connect with an API, the return a DataFormat.Error, this error is caused because have a value using a invalid character "\'" and i can't remove this one. Is there a way to change this?
Thank you for help!

[lbendlin]

likely you ae making the Web.Contents call and the JSON.Document step at the same time. Separate these steps.

Show your sanitized Power Query code.

[ROQTEduardo_Lar]

Hello! yes, i have a sample.

[lbendlin]

so it's not the backslash that's the issue - it's the escaped single quote. Since your "observation"  string uses double quotes this single quote escape is not necessary.  Either change the setting in the source (to not escape single quotes) or add a process step to replace "\'" with "'".

[ROQTEduardo_Lar]

understand! But in this case i can't change the setting in the source and it is not possible add a process to replace this character.
So i need another way to input this information!

[lbendlin]

and it is not possible add a process to replace this character.

Why not?  That can be done in Power Query.

[ROQTEduardo_Lar]

Because, when i make the connection it's return me an error.

[lbendlin]

Please show a sample of the return payload.