Deserialize JSON: Unexpected JSON token when reading DataTable. Expected StartArray, got StartObject

[sushmitha.e]

Hi Team, I am trying to convert json to datatable, as below

But getting error as,

Can I please know how to resolve it.

Thanks.

[1996 (Neelima G)]

Hi @sushmitha.e,

Refer this link

Deserialize json array not working!

Please find my json file below, when I try to deserialize it to an array I receive the error : Deserialize json array : Error reading JArray from JsonReader. Current JsonReader item is not an array: StartObject. Path ‘’, line 1, position 1. Please help, very simple but not working response-data-export.json (9.4 KB) Main.xaml (14.2 KB) { “items” : [ { “job_ID” : 15, “appName” : “Sample_Dynamic”, “dbName” : “Basic”, “jobType” : “MaxL Script”, “jobfileName” : “sample_dynamic.msh”, “user…

Convert json to Datatable

Thanks this worked. The only thing now is they have changed it and now i have to use a Token. So that is the hurdle I’m working on now. So when you use Output Data table i’m going to try to write it to a csv since the output looks to be in that format. Thanks so much for your assistance.

Thanks!

[NIVED_NAMBIAR (NIVED N)]

Hi @sushmitha.e

Check this activity to convert the json to datatable

JSON / JArray Conversion Activities - RPA Component | UiPath Marketplace

Hope it helps you

Regards

NIVED N

Happy Automation

[harsh.jain]

As I tried with it I get this data.
OutputData.txt (4.1 KB)

I tried with that but unable to fetch values for respected properties.

So could you please help how to get my values?