I need to have an automatic update of the data collected in the Adalo application in a BI dashboard. I have achieved this thanks to the Power Automate tool. But when doing it I found that it consumes the actions. So although I have an account of 100,000 actions, When you perform a “Get All” call with the Adalo API the actions are counted in the following way:
Let’s say you have 300 records in a collection in Adalo.
Each request is 1. So if you do a GET ALL for get all 300 of them, and then you then do a GET ONE for each one of those, then you’re up to 301.
If this operation is not workable, what other ways do you think of?
I assume we’re talking about Adalo Collections API here?
Ideally, your backend should send only GET ALL to receive the whole collection’s data from Adalo Collection, and then parse it on its side. There is no need to send GET ONE for each record as the information is already contained in GET ALL.
Keep in mind though that GET ALL has a limit of 1000 records returned, and if your collection has more, you’ll have to implement pagination.
If you need to update every record (PUT), then every update will consume one action and nothing can be done with it.
In my opinion, for a transaction-intensive tasks it’s better to migrate to external database (e.g. Xano, Supabase, etc.).