I have a list of data records that contain nested objects and fields. I want to convert the data to a csv. I also want to filter the records based on certain fields to make sure only the relevant data is included in the csv.
How can I achieve this?
There are a few ways to go about it.
1) Loop through each record from source list and add filtered records to a Workato list. This list of filtered records can then be used to create csv using "CSV by Workato" or "Collection by Workato".
2) Using Workato formula mode, filter records and select relevant fields for CSV. You can do nested filter and nested selection of fields.
3) Using Collection by Workato, create a temporary data table to store source list records, then write SQL queries to filter records. You will need to flatten the data structure.
Check this recipe to see the above 3 methods in action: https://www.workato.com/recipes/991259
Let us know if it works for you!
Send us a ticket, we will try our best to assist you with your problem