How to handle external API calls

Questions
1

Hello everyone!

I’m wondering what’s the best practice for handling external API calls.

My situation right now:

  • I’m displaying financial information for stocks and using “Get data from external API” every time the data point is visualised by an user.
  • I’m also using “Get data from external API” for multiple conditions.
  • This setup consumes a lot of my API calls (and I’m also wondering whether it slows down my application).
  • Most of the data points I’m showing change every day, but not every hour.

Do you think it would make sense to add the data points to the database and refresh at a fixed frequency?
Or refresh whenever a user wants to visualise a data point and the “Modified Date” timestamp for it is too old?
Should I keep the same set up that I currently have?

Thank in advance for the help

2

Reduce interactions with the database as much as possible. So … temp data that came in from the AP call is immediately available in the flow … thus your conditions should perform better.

1 Like