Getting the unknown character error while deserializing the API response string

Help Activities
1

Hi All,

I am trying to deserialize the API response as shown below, using deserialize json activity. But i am getting the error as “Deserialize JSON: Unexpected character encountered while parsing value: r. Path ‘’, line 0, position 0”.

@"responseStatus,id,external_id__v,errors
SUCCESS,153623,
SUCCESS,153624,
SUCCESS,153625,
SUCCESS,153626,
SUCCESS,153627,
SUCCESS,153628,
SUCCESS,153629,
SUCCESS,153630,
SUCCESS,153631,
SUCCESS,153632,
SUCCESS,153633,
SUCCESS,153634,
SUCCESS,153635,
"
Thanks in advance.

2

hi @Athulya_S_Chandran
you can deserialize by using Below syntax
Coverts JsonString To Datatable

syntax :
datatable=Newtonsoft.json.jsonconvert.deserializeobject(of datatable)(jsonstringVariable)

it Helps!

3

Your String looks like a CSV data, but not like a JSON Data

4

Tried this getting the same error

5

Yeah its the response of a csv data upload. Could you please help me to deserialize it.

6

We dont deserialize it, we parse the CSV Data

  • Read CSV File Actvitiy

OR

  • generate Datatable activity

But keep in mind: The CSV string is also invalid, as it defines more columns as it have values for

7

hi @Athulya_S_Chandran

Can you please share json string So will perform and send the code

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.