MSSQL to CSV to E-mail


I'm using MSSQL node for reading data from SQL table and I want to output into either .csv or .xlsx and send it over e-mail as attachment.

I'm getting error "This node only handles CSV strings or js objects."

That's very interesting, but unless you tell us which bit you are having trouble with it is difficult to help.
Search the node red flows site for CSV to find how to do that and search for email for how to do that.


I'm having trouble in both side i.e. from SQL to CSV and unable to attach CSV to mail.

Show us the output (from a debug node) of your sql query and tell us what you want to see in the csv file.

What problem are you having attaching the file to an email?

I Also would like to have a better understanding of how to achieve this proses as i need the same on one of my projects ,

Thanks and looking forward to your responses

The data from mssql-plus SELECT is an array. Have you tried feeding through a CSV?

Note, if necessary, use a change node to move the data array into payload before the CSV node.

As for making the data an email attachment, there are several examples in the forum on this.


I'll check. Thanks.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.