Unexpected character error in json

Help Studio
, , , , , , , , , ,
1

hello

i am getting below error

image
image1920×1080 464 KB

when i am checking line 124 in son it contains some data like below
image
image695×302 10.9 KB

i am desrialising jsong using below way not using direct desrialize json activity as it is changing my date format
image

please help me on same
if such characters are there in json file then how we can manage

2

JSON is invalid
grafik
grafik

We need to escape:
grafik

3

why invalid can u explain a bit

image
image1920×1080 265 KB

this error i m geeting after putting in validate json

4

double quote is to surround the string. When a double quote is used inside the string it would confuse the string start/end. Therefore it has to be escaped.

We shared the JSON Lint validator, so you can explore by yourself.

https://www.json.org/json-en.html

Details:

grafik
grafik1457×484 73.4 KB

5

ok how to handle this using UiPath

6

@Mathkar_kunal

It will be quite difficult because the original JSON is not valid. So basically, no application could parse this Json and UiPath either.

You can try some string manipulation, for instance retrieve this particular Node, split the string with “:” caracter and try to find if there is 0 or more that 2 double caracter in each string of the split table. Replace the extra double qutoe by a simple quote or \".

It’s quite difficult, hard to maintain and not recommanded. So the best practice is to rework the Json file and how the data are inserted.

Best regards,