API data appears not displaying properly in database

Need help Database
1

Hi all,

I’ve noticed data i run from an externsl API fails to pass new data. It keeps repeating an old data range (15-18-Nov). I’ve run the API via other external means and it shows the correct data, but when it comes to updating the bubble database, it reverts back to the old fixed date range- I’ve even created a new database to pass the data, yet once the data hits the database, it shows the same rage of old data. GPT4 suggests API is caching old data, the solution it offers don’t help… any ideas?

date range:

image
image217×587 2.91 KB

2

Would saving current date/time as the last step in the workflow saving the API info work in your situation?

3

Sometimes using the API Connecter, the default data used to validate the call is persistent in future calls. This can occur when a field is empty in subsequent calls. Have you checked the logs to ensure you are actually passing a new date?

1 Like
4

Sorry not quite sure what you mean…

5

Hi, thanks, your explanation sounds plausible… i’ve checked the log and yes it’s running the right API but the data is still not updating in the database correctly.

6

Need more info to help you. Can you send the editor links with steps to review?

7

Thanks… I’ve realised it’s not bubble, it’s the api… for some reason it fixes the range regardless of the dates i put in… I’ll share the link with you privately once I learn how to do that :crazy_face:

8

Thanks all-
I 've realised that I set the limit of the API too high hence the repeated data. Thanks for your help.