+1Hi everyone,
I have a loop set up that loops through records 50 at a time until the end of the day’s transactions. I would like to build a dataset of all records retrieved from each run of the loop to be exported to Excel. I thought about using a list but I cannot seem to find the right actions to append the data in within each iteration. Could someone give me some guidance or suggest a better way to attack this please?
TIA,
Steve
Best answer by jon.stueveapeople
Both
there are many ways to do this type process, using CSV, Excel, Database, or an in-memory DataTable per Aaron’s suggestion.
+10Generally, a data table will work best for this. You can add as many columns and rows to the table as you need. You don’t need to pre-allocate the table -- it will dynamically grow as items are added. If you need the rows in a specific order, be careful with the Data Table: Add row action. I’ve seen people use it incorrectly and get the order of their rows backwards.
+7Hi Steve,
You can utilize the log to file functionality where the data can be stored in comma separated values format or create a template of excel with the required fields that you want to insert the from the API Output.
Thanks,
Rajesh E
+7Both
there are many ways to do this type process, using CSV, Excel, Database, or an in-memory DataTable per Aaron’s suggestion.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.