cancel
Showing results for 
Search instead for 
Did you mean: 

Error reading JSON to Collection: Bad JSON escape sequence: \R. Path '', line 1, position 17.

DeborahParfitt
Level 3
Hello Team

I am trying to read a JSON object to Collection using the Utility - JSON object  and get the following error message

Internal : Could not execute code stage because exception thrown by code stage: Bad JSON escape sequence: \R. Path '', line 1, position 17.

Completely new to this JSON functionality. However I  understand the records I'm reading in are JSON nested objects. Can someone help to explain what the error means and how to rectify.

Many thanks

Debbie

------------------------------
Deborah Parfitt
RPA Developer
BNPParibas PF UK
Europe/London
------------------------------
2 REPLIES 2

EmersonF
MVP
Can you post this Json for us? Try using Symphony JSON solutions in our DX
Blue Prism Digital Exchange

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------
Sr Cons at Avanade Brazil

TobiasArnold
Level 6
Hi Debbie,

if \R is part of a JSON string, this isn't a valid JSON string. \ is a JSON escape sequence and the deserializer tries to interpret the following character. Like \n gives you a new line.
If the result should be \R you have to double-escapce the \. The JSON value should look like \\R

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------