How to query open data that is downloadable from a URL?

Hello bubblers,

I’m working on an application that needs to reference a city’s open data. They publish this in two forms: (1) as a downloadable CSV file, and (2) as a downloadable JSON file.

These files are updated daily and quite large in size (100k+ records), so manually downloading to upload into my Bubble database is certainly not ideal.

I’m wondering - what is the most efficient way to query this data?

Appreciate any ideas or insight you have to offer!

  • Josh