I’m on the Professional (Legacy) plan so mainly asking relating to this plan but can upgrade if necessary.
I have a data type called “SIM Cards” which has a field ICCID which is a unique ID for that SIM card. It then has a field period_usage, and a field status which is either active or inactive. period_usage is a number field.
What I’m looking to do, is have every 15 or 30 minutes (but whatever is realistic, ideally no longer than an hour apart) have a workflow that runs on ALL of the SIM Card records where the status is “Active” and:
- Use an API call to GET the current cellular data usage from an external system by sending the current SIM Cards ICCID
- Update the current SIM Cards period_usage field to this number
- Do a POST API call to a different external system, and send this number to that system
- Repeat for each SIM Card on the list
Both API calls work today manually, as in I can manually retrieve the data usage via the one API call and also manually post the data usage via the other.
It’s mainly the recurring workflow I want, as I want it to check all SIMs for usage every so often and update the other system.
I don’t necessarily need to know step by step how to do this, just more if it’s possible as I can always get one of our developers to do it for me. I know there’s Backend Workflows where this would probably be done, just not sure the best way. I also would like feedback if using Bubble for this makes sense, or if I should do my original plan of using a dedicated server running Linux that has this scripted. It’s possible that there could be 200-300 SIM cards that it would be running this on, but most likely will be less than 75 for the first year of use.