For each row in Data table New Version

[sarvesh.chowkekar]

Hello,
I created a data table but in the activity, “for each row in datatable”, I am unable to find the proper syntax to execute this.
Its a simple table with 2 columns and 3 rows. I am stuck and everywhere else online I see the older version of that activity.
Can someone help me with the newer version?

[sarvesh.chowkekar]

[postwick (Paul)]

It’s the same as the old version, you give it a datatable to loop through. And in Item you don’t reference a column. Item is a variable that you use in the Body to reference data in the current row of the loop. Just leave it at CurrentRow then in the Body you’d do CurrentRow(“username”).ToString wherever you want the username value for the current row.

DataTables and Excel Automation with Studio (v2020.10)

[ppr (Peter Preuss)]

Lets assume you want to loop over the above JSON (JARRAY, parseable into a dataTable)

strJSON - Your Above shown JSON String

Assign Activity
dtData | DataType: DataTable =

Newtonsoft.Json.Linq.JArray.Parse(strJSON).ToObject(Of DataTable)

Then we can do: