API Calls to create, delete and update multiple Records at once

I need to rely heavily on make for my logic layer. While make internally processes data rather fast API-Calls to tadabase slow my scenarios down drastically. Especially whenever I want to edit/delete/create a bunch of records. I’d love to be able to do all the processing in make at once and that just handover my records as bunch.

It depends on exactly what you’re doing but if you have a long sequential path that a single make scenario executes, you may be able to break that out into simultaneous separate scenarios. I had a parent records with 6 different tables with child records, I was able to split this in make so it ran 5 times faster than a single sequential pathed process… or there is no reason even if you have many of the same table hat you couldn’t potentially split that out into separate threads.

1 Like

Okay, that approach might work for some scenarios, but not all of them. How do you trigger the others, then? Do you send a webhook to a “main” scenario and have it trigger the others?

My best practice at the moment is to minimize API calls. So, I often retrieve far more data than actually needed and use a data store in Make to process it. While this significantly improves speed, it also burns through operations quickly.

The main issue is writing data into Tadabase. For example, I have several template-based workflows. My users can create a template for a daily schedule and then load it into their daily plans. Each template consists of multiple records. When a template contains 20–30 records, loading already takes over a minute because Tadabase’s write API calls are painfully slow, and I don’t see a way to parallelize them.

Exactly that, the main scenario branches off to separate scenarios with http requests to webhooks for each of the other tables, but that doesn’t sound feasible in your example.

These Template workflows, are these Tadabase Automation Templates? If so, what is this data you’re importing, it’s from another system?

no, no. I based the idea of some old Build it with Tim Video “iterating over connected records” or something similar.
I have a table for Daily Events connected to itself and a Selection Field:

  • isTemplate
  • part of Template
  • individual
    Creating a Template then means I add a Record and connect other records in the table to it.
    Loading means connecting a template record (filter the Form by ‘is Template’) to your selected day.
    Than make can find the records connected to the Template, modify them and add them to the selected day

@andreas

You can try playing around webhooks. https://catch.tadabase.io/

It has the capability to do bulk operations. Although it has a lot of limitations, it works fine for me now.

You can construct the arrays in Make then send them to the webhooks.