Convert json to Datatable

[Florent_Salendres]

Hi,

There is a simpler way to Deserialize JSON to Datable using the Deserialize JSON Activity.
The trick is to specify the Type argument in the property as bellow and A datatable variable as output.

The only requirement is to have a json representing tabular data, which is your case but was not the case of the OP.

I posted (see link bellow) quite a while ago another example to “navigate” through the jobject to reach the tabular data (once again you do not need it but this can help someone)

How to parse JSON object and sub JSON object of currency API

Hi, Quick workaround which will help you extracting the rates. Do a first “Deserialize Json” on the given string and set the TypeArgument as Jobject - Assign value to your variable Do a second “Deserialize Json”. "[" & jObjVar("rates").ToString & "]". the “” are required if you want to deserialize as a datatable (with TypeArgument and output to Datatable) to write directly to excel after, As it will requires you a Jarray. The will give the following horizontal output (as it is the case for d…

I am attaching example for your case

test.json (377 Bytes)
JsonToDT.xaml (5.7 KB)

Cheers