I have created a personal token with data.records:read scope.
I have created an action in OpenAI GPT with schema:
openapi: 3.0.0
info:
title: Airtable Direct Access API
version: 1.0.0
servers:
- url: https://api.airtable.com/v0/appM376pMJS0ddkXZ/tblbxbPFVM8FaZdos
description: Airtable API server for the specified table
paths:
/records:
get:
operationId: getRecordsFromView
summary: Fetches all records from a specific view in the table.
parameters:
- name: viewId
in: query
required: true
schema:
type: string
default: viwPnVZGLgVvdOvsF
description: The ID of the view in the Airtable table to filter the data by.
responses:
'200':
description: Successfully retrieved records from the specified view
content:
application/json:
schema:
type: object
properties:
records:
type: array
items:
type: object
properties:
id:
type: string
fields:
type: object
additionalProperties: true
createdTime:
type: string
format: date-time
components:
securitySchemes:
BearerAuth:
type: http
scheme: bearer
bearerFormat: "JWT" # Note: Airtable uses Bearer tokens, not JWT. Adjust comment as needed.
schemas: {} # Explicitly defined, empty schemas object to resolve validation error.
security:
- BearerAuth: []
The schema was accepted but when I click on test, the GPT says:
I'm unable to fulfill this request as it requires specific parameters that I haven't been given, such as the ID of the view in the Airtable table to filter the data by. If you have a specific task in mind that involves accessing records from an Airtable view, please provide more details or the necessary parameters so I can assist you properly.
However the viewID is there and is correct.
The Authentication is entered as Type "API Key" and Auth Type "Bearer".
I hope someone can help me to identify what is wrong.