Schedule Get data from API and save to database

I have a few different API calls set up to retrieve data from another system that we use. The current setup works to pull the data ‘live’ but that leads to performance issues, so I want to schedule the API to retrieve the data (every hour, day, etc.) and then save to bubble db.

I think I’m supposed to setup a recurring event that would call the API, but I’m not quite getting it right and I don’t see how/where I would set it up to save to the db.

I’ve watched several videos and read some forum posts on similar topics, but I know I’m missing something. Any help is appreciated!

Also looking at doing this, bumping this to see if anyone has a response.