Automated CSV export via API?

[Steven_Zhang]

1. There’s no API call for exporting a table as CSV right? (couldn’t find it in API documentation)

2. Has anyone written a script that mimic that functionality by iterating through all the records, replacing linked record IDs with names, and then, generating said CSV? If not, I’ll work on writing one…

[Tuur]

Hi Valentin!

For know this is only available for my clients. Like I said earlier…

If I ever have a solution for the ‘general public’ I’ll let you guys now.

Meanwhile, something like https://www.integromat.com might be a solution?

Best,

Arthur.

[openside]

I’d be willing to build a custom connector to zapier, integromat, workato, etc that did a bulk export. Assuming you already use one of these integration platforms you could then push it anywhere. Let me know if someone would be interesting in sponsoring such a project. (dan@openside.com)

[Martin_Low]

Would you mind sharing this tool with me as well? Thank you!

[Angelik_Laboy]

Hey @Tuur, I don’t if it is possible but I would love to have access to such script. It would be very useful for my upcoming project!

[Sujan_BBP_Sharm]

Hi @Tuur, would it be possible to run a daily CSV export for one of the bases through something like Zapier?

[Tuur]

I suspect you could do a Google sheet export with one of those…

Maybe https://www.integromat.com has more advanced features. @Julian_Kirkness can probably tell us something about that. :slightly_smiling_face:

[Sujan_BBP_Sharm]

Thanks @Tuur, I took a look at integromat and there doesn’t really seem to be anything in terms of a daily csv report. I created a free acount and there are some triggers but those are in relation to records being updated in a view. Actions also don’t seem to have an option to download “.csv”. If @Julian_Kirkness has any insight that he could provide, it would be really appreciated.

[Tuur]

That’s a shame…

If you’re really stuck I can help you with a (paid for) custom solution. Just send me a PM and I’ll be glad to help you.

[Glen_Aguayo]

Hi there, @Tuur. I’d be interested in that solution. Can you PM me, so I can learn more?

[W_Vann_Hall]

I can’t speak to its accuracy, but there is a php routine for generating CSVs via the API available on codegists.