Extract value of a key in json but receiving "deserialize json: unexpected character encountered while parsing value: . path '', line 0, position 0. uipath error" error

Help Something Else
1

Hello everyone,
I’m having an issue while using a deserialized json to get a value.
“deserialize json: unexpected character encountered while parsing value: . path ‘’, line 0, position 0. uipath error”
I’m trying to do it with another method but it is not possible.

2

Hi @dhouha.cherif ,

Could you provide us with the Json Data that is being used ? Or a Screenshot of the Data ?

3

{
“code”: 804,
“message”: “Document signe”,
“signature_restant”: 5000576,
“date_consentmnt”: “28/10/2022 10:25:13”
}
If you do a copy and paste it is going to work but since it is the response of another API request i don’t know why it does not work. It’s like there is an invisible char before the json

4

@dhouha.cherif ,

In that case Peform a Debug and Check the values in the Immediate Panel. Let us know if you do find extra characters / spaces involved in the data, Maybe a Trim would help as well.

You could Take a Screenshot of the Immediate Panel and send it here after you have checked the values in the Data variables.

5

image
image1900×869 65.9 KB

6

@dhouha.cherif ,

A Confirmation from the Immediate Panel will be much clear as to why the Error is happening. It does seem like a Trim is needed or Removal of Empty Lines.

Check by Logging resp in Immediate Panel and resp.Trim as well, addtionally perform the below as well :

resp.TrimStart(Environment.NewLine.ToCharArray)
7

image
image1740×795 58.8 KB

8

@dhouha.cherif ,

It does seem that there are extra spaces at the beginning, Use resp.Trim at first to Check if the Deserialization works else you could use the resp1 variable as you have already used TrimStart on the value and have obtained the modified value. Check both the Expressions in Deserialize Json Activity and Check if it works.

9

if i understood right i should have something like this?
image

10

@dhouha.cherif ,

Yes. Does this setup work ?

11

From your screenshot we do see something like a comma on the begin

grafik
grafik999×211 5.05 KB

so lets try for a customized trim like

YourStringVar.Trim((","+" "+vbCrLf).ToCharArray)

12

Unfortunately , it did not work

13

Unfortunately , it did not work

14

no problem, check in the immediate panel following:
ASC(YourStringVar(0))

Let us know the result, please

For working with the immediate panel have a look here:

15

The only method that worked is to :

  • Trim the input like you guys said
  • Put the output in a text file
  • read the text file and define an output variable
  • Use the output variable for deserialize
16

We use "ASC(YourStringVar(0)) " for what exactly?I had as a response : 63

17

@dhouha.cherif ,

Could you let us know if it was the same error ?

18

Can you try following trimming (quick check in immediate panel is possible)
YourStringVar.Trim((Chr(63)+“,”+" "+vbCrLf).ToCharArray)

we analyzed the first character to get the details, which we use later for the custom trimming

19

image
image1459×259 15.1 KB

20

as you can see in the immediate panel the trimming result looks good on the first check so far.
About further issues let us always know the exception message details as well