Hi, i am brand new to Make and so far it looks fairly useful for backend operations. My main use for Make would be to schedule retrieval of data from 3rd party api and then to store that in my Supabase table.
However im struggling to find the efficiencies due to the operation cost per insertion of row.
I have a scenario where i have 4 steps.
- Get HTTP request
- Parse JSON
- Iterator step
- Update Postgres table (Supabase)
Lets say the JSON returned has c400 items. The way i have the scenario set up would cost me 400 operations. The kind of data i would be moving could go up to, and beyond 10,000 per week. Im on the core plan. (which i am using to test make’s viability for my use case) and i dont think that would cut it.
Is there a way to reduce the operations needed to insert rows into a table. Ive read somewhere there are batch insert modules but i cannot find them?
Any help from anyone whos had experience with this type of scenario before would be great. If it is indeed 1 operation per row then its probably best to ditch Make as a viable option and just code it