Create CSV feed from Bubble for external service?

I want to send information to a 3rd party service.

That service is looking for a CSV url.

I included a pic of the 3rd party service’s setup page.

What’s the best way to provide this?

I could schedule an export to an FTP or something, but that seems clunky/wrong.

For small CSVs you could create this as long text string that you then convert to base64 and store as a file on S3 using Bubble’s file upload interface. For larger projects you could build a small AWS Lambda that takes a couple of Bubble API endpoints, first to read data from, and the second to call with an AWS S3 URL that contains the CSV. The AWS Lambda simply reads data, builds a CSV, converts to base64, and stores it on S3. None of it is as bad as it sounds.

Thank you for the answer! Unless someone recommends a way more native way or plugin to do this, I’ll mark this as the solution!

1 Like

When in doubt offload data processing onto a secondary service. The price point of AWS Lambda for data processing is far better than Bubble, which is aimed at hosting and content delivery. Two different problems.

2 Likes

That makes sense. My app will already need AWS for image hosting, so we’re already halfway there.