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

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

DeborahParfitt — Tue, 06 Jul 2021 16:17:00 GMT

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
------------------------------

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

EmersonF — Tue, 06 Jul 2021 16:57:00 GMT

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!
------------------------------

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

TobiasArnold — Wed, 07 Jul 2021 05:16:00 GMT

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
------------------------------