Adding JObject items to a datarow

[tsorrill]

I have de-serialized a json string from an http request and then tried to format that object into a Jtoken variable called JObjects

I am trying to add those objects into my table’s rows. I do a loop for each item in JObjects But am struggling to access the members of my JObjects when I want to do the Add Data Row activity. My ArrowRow input for the activity needs to be the JObjects elements. How do I access these members? items(“_id”).tostring gives me the error options strict on disallows late binding

[Doanh]

In Deserialize JSON activity, you can select TypeArgument = DataTable type as output
Please refer

Convert json to Datatable

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. [image] 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 s…