I have two large datasets in Bubble (70k entries and growing) that I need to export (backup) on a regular basis. Sadly if I try to export the data as .csv from the admin panel, I only retrieve around 20k lines.
I tried creating buttons that trigger workflows that exports the data as .csv. Say, one button for the first 10k, then 10k to 20k for the second line, and so on, but the second button seems to fail for anything over 1k. And at this rate I would need 70 buttons, to download my full dataset which seems counterproductive.
What is the best way to retrieve large datasets?
Emmanuel recommended me to use a script that uses the Bubble GET API to get returns in JSON objects, which can be converted to text. But I must say I don’t know where to start.
Thanks in advance for your help.