Help

Access table from an OpenAI GPT

Topic Labels: API
212 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Access_to_Airta
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

0 Replies 0