As a result, this solution will not work since AppSheet needs to be able to read the same columns in the table every time the app syncs. a different set of columns is returned with each new request. Additionally, the columns returned appear to be unstable, i.e. Unfortunately, AirTable handles this differently, and only returns some but not all of the columns present in the table (although the number of columns returned is larger than 21). For many other data storage providers, not specifying specific columns is equivalent to requesting all columns. I have tried a workaround, which was to avoid specifying any column to read. Since the table that you were trying to add to your app had more than 21 columns, the number of parameters in the request to read this table exceeded 21, and thus the request was rejected by AirTable. By default, every GET request has 60 seconds of caching means the first API call will come from a third party application API and other API calls under the next 60 seconds from the caching server. If I make 5 API calls and haven’t received them back after 1000ms, does this mean I can make 5 more new calls while still waiting for the o. Any request that contains more than 21 parameters will be rejected. Key Issue : Airtable API is hard to integrate, because it has limits. My List Records calls take about 1 second each to complete (5 fields), which suggests I may be able to make new calls before even receiving the previous ones. It appears that currently, AirTable imposes a hard limit of at most 21 parameters. Roughly speaking, each time AppSheet reads data from AirTable, AppSheet will send a request that contains a list of parameters to AirTable, and some of these parameters are names of the columns to be read. See below the feedback from Appsheet support, who really took their time to find out what was going on:Īfter quite a lot of testing and investigation, I believe I have finally found the root cause of the problem. It looks like the API does not handle more than 21 columns well. With one case I got an error in Appsheet, that turned out to be a limit on the Airtable site. I was trying to build an app based on Airtable using Appsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |