Error reading JSON to Collection: Bad JSON escape sequence: \R. Path '', line 1, position 17.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-07-21 05:17 PM
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
------------------------------
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-07-21 05:57 PM
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!
------------------------------
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-07-21 06:16 AM
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
------------------------------
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
------------------------------
