I do not understand how I could iterate on Object

[Florent_Delage]

Hello !
I’ve readed some topics but I do not understand how I could iterate on a JObject. I’m using a deserialize JSON to create JObject.

This is my response from HTTP Request
“{"Result":[{"Order":0,"RelatedTable":"CookingModes","Name":" Sans cuisson"},{"Order":1,"RelatedTable":"CookingModes","Name":"Bouilli"},{"Order":2,"RelatedTable":"CookingModes","Name":"Cru"},{"Order":3,"RelatedTable":"CookingModes","Name":"Cuit"},{"Order":4,"RelatedTable":"CookingModes","Name":"Etuvée"},{"Order":5,"RelatedTable":"CookingModes","Name":"Frits"},…”

My objective is to add each propery into a data table. I do not understand how I could reach each property into my for each. And I do not understand why I can’t change the type of argument into for each.
Thanks for any help !

[ppr (Peter Preuss)]

@Florent_Delage

I do not understand how I could reach each property into my for each.

For each activity | item in myJObject("Result").Values(of JObject)

myJObject is the output from Deserialize JSON

[ppr (Peter Preuss)]

@Florent_Delage

And I do not understand why I can’t change the type of argument into for each

[FirstAid] For Each Activity - Forcing TypeArgument

This FirstAid Tutorial will describe how the auto calculated typeargument of a for each activity can be forced Introduction In newer versions, the TypeArgument of the For each activity is automatically derived and is no longer offered for manual configuration Depending on different combinations of UiPath Studio version Selected project compatibility (Legacy, Windows…) UiPath.System.Activities version Use of variable vs. code statement the following behavior can occur: The Typ…

[Shiva_Nikhil]

@Florent_Delage
After deserialize json

Use deserialize json array activity after that use for each for it output

Inside for each use add datarow

[ppr (Peter Preuss)]

A flat oneliner would look like this:

Assign acitvity:
dtResult = myJObject("Result").ToObject(Of Datatable)

[Florent_Delage]

@ppr

For each activity | item in myJObject("Result").Values(of JObject)

Thank you, it’s working at last, only a problem of using the correct syntax for cast… Pfffiu ! Two hours on this issue. Thanks !