[Integration] Airtable - Database operations

[MAlshaik]

Category: Data

Priority: P1 | Complexity: Medium

Description

Integrate with Airtable for database operations.

Credential Definition

export const AirtableCredential = {
  name: 'airtable',
  type: 'bearer',
  schema: z.object({ accessToken: z.string() }),
  authenticate: {
    type: 'header',
    properties: { Authorization: 'Bearer {{accessToken}}' },
  },
};

Operations

airtableCreateRecord

// Input: { baseId, tableId, fields }

airtableGetRecords

// Input: { baseId, tableId, filterByFormula?, sort?, maxRecords? }

airtableUpdateRecord

// Input: { baseId, tableId, recordId, fields }

airtableDeleteRecord

// Input: { baseId, tableId, recordId }

API Docs

https://airtable.com/developers/web/api

Acceptance Criteria

• Bearer credential
• All 4 operations
• Formula filtering
• Zod schemas
• Unit tests