Forum Discussion

TylerParker's avatar
TylerParker
Qrew Assistant Captain
7 years ago

Automation to add records to one table from a table whose records are created via API_AddRecord is being limited

I have a calendar add-on that uses API_AddRecord to add multiple records (employee shifts and their work assignment details) to one table all at once, in this test case I used today it was 287 records...
Account and realm management
APIs and custom code
App builders
MattSaforrian's avatar
MattSaforrian
Quickbase Staff
7 years ago
Hi Tyler,

Automations don't care how a record is added. Is it possible that your add on is creating records too quickly and so hits our webhook rate limit? If possible, I would recommend that you create multiple records using API_ImportFromCSV.

Best,

-Matt
  • TylerParker's avatar
    TylerParker
    Qrew Assistant Captain
    7 years ago
    Thanks Matt, that's what I was getting at. I'm reading on the Automation Limits page but maybe I should be looking into the Webhook limits? I didn't know that Automations relied on webhook limits underneath. The add-on does indeed only take about 2-3 seconds to run. Would extending the time accommodate webhook limits? If so, how many seconds do you think I would need to tell the code to wait before finishing if I was to create roughly records 350 with one click?
  • SuryaExpert's avatar
    SuryaExpert
    Qrew Assistant Captain
    7 years ago
    Matt, Isn't the limit on Webhooks 10 per second? Or has it been increased lately? Also, webhooks created by Automations are json based, right? So does the webhook limit still apply for automations?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    The webhook limit was raised to 20 per second.  So I suggest if they are being added one by one to limit them to that speed.