Help

Re: How to create a new table in an existing base through the API?

4047 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dev_Local
6 - Interface Innovator
6 - Interface Innovator

I have searched the API docs, and I see no way to do this.

With the AirTable API, how do I create a new tab (new table) in an existing base? and then populate it?

I do not see this feature of inserting or creating an new tab into an existing base, only the ability to insert rows into an existing table that was created by a human that opens a web browser and clicks.

We have needs to automate the creation of new tables in an existing base (and down the line, creating new bases programatically).

17 Replies 17
Nathan_Beckstea
6 - Interface Innovator
6 - Interface Innovator

RE: API Limitations…

Can someone speak to the 10 records per second API limitation? Is this limitation per account or per base? I.e. can we write 10 records to multiple bases at the same time?

Hi @Nathan_Beckstead - the API documentation says:

The API is limited to 5 requests per second per base. If you exceed this rate, you will receive a 429 status code and will need to wait 30 seconds before subsequent requests will succeed.

The [official JavaScript client](https://github.com/Airtable/airtable.js) has built-in retry logic.

If you anticipate a higher read volume, we recommend using a caching proxy. This rate limit is the same for all plans and increased limits are not currently available. 

The “10 records” thing is that the API allows the creation of records one by one or in batch of up to 10 (with a single request), so at 5 requests per second you could potentially create 50 records per second.

It also notes “per base”, rather than per account or per API key.

JB

Got it.

Mr. Bowen, you are a AT Community gem! Just caught your podcast on BuiltOnAir as well. Thank you for all you do for the community!

NAB

Is this still true? Has it been updated?

Karthik_Nataraj
4 - Data Explorer
4 - Data Explorer

I tried the blocks API, it is possible to create a table using an app. I was able to create a table with proper schema, although there is no destroy table in blocks

Rutger
5 - Automation Enthusiast
5 - Automation Enthusiast

Any updates on this? Is this feature in your backlog?

Marwan_Refaat
4 - Data Explorer
4 - Data Explorer

This feature is a huge bottleneck especially in the use case where you have a different table per person – would be awesome if this could be supported!

Thomaso
5 - Automation Enthusiast
5 - Automation Enthusiast

Can we please get an answer please - I have just upgraded to the PRO plan to find out that the “Run a script” function after a trigger does not contain all of the functions contained in the Blocks SDK.

I purchased the plan to specifically to attempt to do this - so will not be renewing the subscription unless we get an answer.