Skip to main content
Question

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

  • October 25, 2018
  • 0 replies
  • 71 views

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. Those records are supposed to be created in a separate table as well if they meet certain conditions. The automation works perfectly for records created via grid edit or one-by-one in the form. In the calendar, you go to a week and click "Populate Week" and all scheduled employee's shifts are created for that week.

The automation still works, but what's happening is, only 10 records are being added via the automation. I takes the first 2 or so employees from each day of the week.

Is there a limit like 10 records per run with API_AddRecord-related records? Does anyone know of any way to get around this? I heard that automations might not fully work with API-created records, but I also heard that a Q4 update was supposed to handle this.

Thanks for any suggestions
This topic has been closed for replies.

  • Registered
  • October 25, 2018
It is confusing why you think automations have anything to do with API Calls. How automations work is under the hood managed by QuickBase. But if you were using API Calls (which is outside of automations, there is NO limit of the number of records. I don't know where you heard that but automations do not discriminate between data entered interactively vs via API Calls.

  • Quickbase Staff
  • October 25, 2018
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

  • Registered
  • October 25, 2018
Another alternative in this case, would be to consider using the API_CopyMasterDetail.