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!

#35

@Tuur interested too!

#36

Hi there @Tuur, I’d really like to access this as well. Can you hook me up? Thanks!

#37

I have a page here - https://www.pagemonk.com/export which I use for downloading CSV files. Are you looking for the same thing via API?

#38

@Tuur Could I i please have access to the script you wrote for auto exporting CSVs? It would be immensely helpful!