Automated CSV export via API?


#22

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.


#23

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)


#24

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


#25

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!


#26

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


#27

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. :slight_smile:


#28

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.


#29

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.


#30

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


#31

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


#32

Hey all, if you’re finding this thread while looking for “normal backups” as Tuur was referencing earlier in the thread, we’ve built a way to do external backups for Airtable automatically to address the need directly.

So if that kind of backups are a priority for you, check out the show and tell here: How to set up automatic external backups for Airtable in 20 minutes

Hope that helps!


#33

Hi @Tuur! I’m looking for a similar solution, but it’s not for backups. I need to export a CSV from AirTable in order to pass data into another program (Vantage) which is not supported by Zapier. Do you have any tips?

Thanks!


#34

Tuur, could you also share it with me please? :slight_smile: Thanks in advance!