Convert JSON Array to CSV

[rmorgan]

Ive done this before

I have the attached JSON Array and when using the activity JSON to CSV gives
Json to CSV: Object reference not set to an instance of an object.

PW43_4.txt (7.2 KB)

[ppr (Peter)]

just ensure the surrounding { } or add it when it is missing

As an alternate we can do:

JsonConvert.DeserializeObject(Of DataTable)(myJObject("Result").tostring)

we convert the JSON to a datatable and can use e.g. the write CSV file activity later

[rmorgan]

I may have to ask you to expand slightly on your solution, my knowledge of JSON etc is pretty poor to be honest,

I have fixed the input file and added the surrounding {}

Read the Text File

Deserialised it into an Array

but can’t get any further

[ppr (Peter)]

first very important thing is that you check that the JSON is surrounded with { } (in your txt it was missing / invalid JSON string)

the Result property value is the JSON representation of a datatable. So were able to use for a deserialization and can convert from this JSON string the corresponding Datatable

Ensure following:

Create a variable: dtResult | Datatype: DataTable

Just use an assign acitvity

dtResult = JsonConvert.DeserializeObject(Of DataTable)(yourDeserializeJSONOutputVar("Result").tostring)

[rmorgan]

Amazing thankyou, this will save the office so much time