Convert json to Datatable


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)

I am attaching example for your case

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