Converting SQLite Query to a CSV File

Hello!

Quick question, I'm hoping you folks can help me out with. I've created an SQLite database to store time-based data about my system and want to create and export a .csv file of specific queries on demand.

So far I'm able to create a query, send the returned database results in a message, and convert to a CSV, and create a file; however, it looks like only a portion of the data is being transmitted.

There are 14 columns of data I expect to be exported, but only 5 are visible in the .csv file. See screenshots for output.


image

How is the csv node configured ?

CSV node configured as shown.

Your template line says things like bin50 which doesn’t match the debug that shows things like b50

That was it. Thank you! It works like a charm now.

Hey Zacharyalan,
Could you possibly share your flow? I am stuck in this function to export sqlite to csv.

Thanks

Hey can you possibly share the flow ,i am unable to export sqlite to csv

@shipra, please don't ask the same question on multiple threads. Since you are working with Nick in the other thread and this thread is over a year old, I'm going to close it.