Forum Discussion
We found an invalid escape sequence in JSON input
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 remo...
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 "'".
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!
and it is not possible add a process to replace this character.Why not? That can be done in Power Query.
Because, when i make the connection it's return me an error.