topic Re: How to convert SQL array of objects to CSV for email attachment in Community Chat

How to convert SQL array of objects to CSV for email attachment

shaked — Mon, 02 Feb 2026 17:23:06 GMT

Hi,

I have a result from a SQL query that comes as an array of objects, like this:

[

{ NAME: "BON", NUMBER: 21 }

, { NAME: "JON", NUMBER: 51 }

]

I want to convert this into a CSV file so I can send it as an email attachment. What’s the best way to do this in Workato?

Re: How to convert SQL array of objects to CSV for email attachment

francbaviello — Tue, 03 Feb 2026 09:40:04 GMT

Hi @shaked , you can to use:

'Compose CSV': where you set the 'CSV data lines source list' field with the array of objects;

'Send email': where you set the 'Binary file content' field with the value 'CSV contents'.

Re: How to convert SQL array of objects to CSV for email attachment

shivakumara — Tue, 03 Feb 2026 10:33:44 GMT

Hi @shaked ,

You can use the Compose CSV action to generate the file content, as the content remains the same.
Please refer to the attached screenshot for reference.

Thanks and Regards,
Shivakumara K A