Forum Academy Marketplace Showcase Pricing Features

Populate db from CSV on Amazon S3

I have a large (1,000,000 row) CSV file stored on Amazon S3. It’s a simple file with just 4 columns of numbers and booleans.

I’ve tested a GET function on Postman to make sure I have access to the file, and it returns the expected values. (feel free to try it here: GET https://s3.us-east-2.amazonaws.com/xydata/All+Pixels.csv)

I can’t figure out how to configure the Bubble API Connector to retrieve the data and then populate my database with it. The API Connector does Initialize without a problem, but I’m not sure where to go from there.

any help would be appreciated.
Thanks!

The GET calls should return the objects, not the file. It should return a list of JSON, not a CSV file (Bubble can’t use this as an API).

1 Like