Skip to main content - Store Query Results as CSV


Turn the results of your SQL SELECT statement into a CSV file. Extract your data into files for easier delivery to clients and partners.


API KeyBITIO_API_KEYPasswordβœ…--API Key associated to your account. For more information, see the Authorization documentation.
QueryBITIO_QUERYAlphanumericβœ…--A SELECT statement that returns data. Formatting is ignored.
Folder NameBITIO_DESTINATION_FOLDER_NAMEAlphanumericβž–--The folder structure that you want your CSV to be created in. If left blank, the file will be created in the home directory.
File NameBITIO_DESTINATION_FILE_NAMEAlphanumericβœ…output.csv-The file name that you want your generated CSV to have.
Include Column Names as Header?BITIO_FILE_HEADERBooleanβœ…true-If checked, your CSV file will include a header row with column names.