Hello everyone!! I have a few work horse make.com scenarios that process data for my app. One of the use cases is where a customer submits a new entry and we need to either update an existing row, or create a new row.
My current process is:
External app submits the data that needs to come to glide
I use “Get Rows” to get all the rows from the glide table, then insert a router to determine if we are adding a new row (i.e. row not found), or updating a current row (if row found)
This is proving to use ALOT of data as now I am nearing 10MB for every get rows fetch in make.com, AND it is getting slower. The reason I cannot just edit or add the row is that the external app does not know, and has no way of ever knowing the rowID in the Glide table, otherwise I could circumvent all of this.
What are others doing that is possibly more efficient? I know when working with other databases there is an upsert option, either update or insert, and with other query’s we can filter for criteria, but it appears Glide’s “get rows” in make.com is an all or nothing command? I have over 10K rows to fetch.