
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2020 02:36 PM
Hello,
Can I somehow export data to csv file using Scripting block?
I need to generate a pretty complex csv file (with more than 100 columns) with a predefined column order, values by default and specific formatting. That is why I do not see feasible using standard “Download CSV” functionality.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2020 05:01 PM
Hey @Yury_Bykov - welcome to the community!
Yes, you can build a CSV in Script Block but then comes the question - what do you do with it? Scripts cannot write to your file system.
One approach - save the CSV file created in Script to a record as an attachment. Then you can view and download the CSV document.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 18, 2020 01:55 AM
Hey @Bill.French, thanks a lot for the hint, looks promising!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 18, 2020 08:47 AM
Or save the CSV to a " multilineText" field.
The attachment field type still requires a file.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 18, 2020 08:51 AM
But that’s not difficult to overcome.
- Script Block builds the CSV blob and uploads to public space with a signed URL
- Script Block updates the record with an attachment
- Script Block deletes the public space document (or allows the signed URL to expire)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 18, 2020 09:09 AM
Do you have a public space that you recommend?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 28, 2020 07:57 PM
Exporting in a custom CSV format would be really great. I can upload the CSV to somewhere external, but then I can’t share my script as others should not trust my host.
I feel like allowing links to URL.createObjectURL(data: Blob)
, or a new method output.file(data: Blob, filename: string)
would be great APIs.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 20, 2022 12:26 AM
for me I would to use it to export after I remove duplicates across tables and have a new list of records.
so when I get that list I would like to export it as a CSV to re-inject it in a brand new table.
ps I don’t really get the answer, there is nothing in the scripting documentation that talks about export or CSV
