I just recently started working with the SmartSheet Activity Package, and had to perform some Data Manipulation with it.
I am used to pulling data out in the form of DataTables, after which I can either pull them into a For Each Row, or LINQ, but I am not able to do so with the outputs from SmartSheet activities, since the Data is stored inside a Sheet Variable.
LINQ doesn’t work since AsEnumerable is not a member of SmartSheet APIs.
I tried to convert it into a DataTable, but wasn’t able to.
Any idea how this conversion can be performed?
Help would be most appreciated, and thanks in advance!