Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Access table from an OpenAI GPT

Topic Labels: API
713 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