Database

Airtable local sync: searchable entities, .search() filters, and operators.

The Airtable plugin syncs data locally. Use corsair.airtable.db.<entity>.search({ data, limit?, offset? }) with the filters listed per entity.

New to Corsair? See database operations, data synchronization, and multi-tenancy.

Bases

Path: airtable.db.bases.search

const rows = await corsair.airtable.db.bases.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
id	string	equals, contains, startsWith, endsWith, in
name	string	equals, contains, startsWith, endsWith, in
permissionLevel	string	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---

Records

Path: airtable.db.records.search

const rows = await corsair.airtable.db.records.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
id	string	equals, contains, startsWith, endsWith, in
createdTime	string	equals, contains, startsWith, endsWith, in
baseId	string	equals, contains, startsWith, endsWith, in
tableId	string	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---