Querying 300 records in Airtable?

Need help Plugins
1

Hi,

Am I overloading Airtable’s API rate limit?

I have a repeating group with the Type of Content as my Airtable table (via the Airtable Plugin) and Data Source as my Airtable table with only 3 constraints, each querying a unique field.

I’m trying to return all records that meet the constraints.

The 3 queries are simply searching for a value ("=" operator).
My Airtable table has 300 records in it.

At the moment, the repeating group returns empty and isn’t visible using the Inspect tool when in preview mode.

So, is querying 300 records at one time with 3 constraints via the Airtable plugin too much?

Thanks.

2

It shouldn’t be but airtable does have a rate limit on the free plan. Are you sure you’ve connected everything appropriately?

2 Likes
3

Thanks @jared.gibb. I’ve validated Airtable rate limits are not the issue.

My issue comes down to the logic on my constraints. On my RG’s data source (the Airtable table), as mentioned I’m applying three constraints.

They all have the following syntax:

Airtable field A (single select field) = … each item’s field X.

The constraint when evaluated in testing looks like this:

Airtable field A (single select field) = Apples, Bananas, Oranges

Where each Applies, Bananas, and Oranges are separate items/things/rows in my Bubble datasource.

Here is a mock up of the table structures:

image
image709×284 15.7 KB

So essentially I’m trying to get all the Airtable records where the Airtable field B’s values are equal to one at least one of the values in the list of Field X. In this case, Apples is an item from my Bubble table so Airtable will give me all the records that have Apples in Field B (6789, 1213), and the same for Oranges (1617, 1819). Bananas from field X is not found in Field B.

Struggling to find resources relevant to my use case when querying Airtable lists with a bubble list.

Thanks for any help in advance.