find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/licensy-ai:licensy-ai-sheets-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: Fast Sheets API
  version: 0.1.0
tags:
- name: Sheets
paths:
  /api/v1/sheets/create-sheet:
    post:
      tags:
      - Sheets
      summary: Create a new Google Sheet
      description: Creates a new Google Sheet with the provided license records and returns the sheet ID
      operationId: create_sheet_api_v1_sheets_create_sheet_post
      requestBody:
        content:
          application/json:
            schema:
              items:
                $ref: '#/components/schemas/LicenseRecord'
              type: array
              title: Records
        required: true
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SheetResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      security:
      - HTTPBearer: []
  /api/v1/sheets/sample-data:
    get:
      tags:
      - Sheets
      summary: Get sample data
      description: Returns sample license records for testing purposes
      operationId: get_sample_data_api_v1_sheets_sample_data_get
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                items:
                  $ref: '#/components/schemas/LicenseRecord'
                type: array
                title: Response Get Sample Data Api V1 Sheets Sample Data Get
      security:
      - HTTPBearer: []
  /api/v1/sheets/write-to-sheet:
    post:
      tags:
      - Sheets
      summary: Write to existing sheet
      description: Append new records to an existing Google Sheet
      operationId: write_records_api_v1_sheets_write_to_sheet_post
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SheetWriteRequest'
        required: true
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SheetOperationResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      security:
      - HTTPBearer: []
  /api/v1/sheets/update-sheet:
    post:
      tags:
      - Sheets
      summary: Update existing records
      description: Update existing records in a Google Sheet based on record ID
      operationId: update_records_api_v1_sheets_update_sheet_post
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SheetUpdateRequest'
        required: true
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SheetOperationResponse'
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      security:
      - HTTPBearer: []
components:
  schemas:
    SheetWriteRequest:
      properties:
        sheet_id:
          type: string
          title: Sheet Id
        records:
          items:
            $ref: '#/components/schemas/LicenseRecord'
          type: array
          title: Records
      type: object
      required:
      - sheet_id
      - records
      title: SheetWriteRequest
    SheetUpdateRequest:
      properties:
        sheet_id:
          type: string
          title: Sheet Id
        records:
          items:
            $ref: '#/components/schemas/LicenseRecord'
          type: array
          title: Records
      type: object
      required:
      - sheet_id
      - records
      title: SheetUpdateRequest
    SheetResponse:
      properties:
        sheet_id:
          type: string
          title: Sheet Id
        message:
          type: string
          title: Message
      type: object
      required:
      - sheet_id
      - message
      title: SheetResponse
    LicenseRecord:
      properties:
        id:
          type: integer
          title: Id
        name:
          type: string
          title: Name
        state:
          anyOf:
          - type: string
          - type: 'null'
          title: State
          default: ''
        license_number:
          anyOf:
          - type: string
          - type: 'null'
          title: License Number
          default: ''
        license_date:
          anyOf:
          - type: string
          - type: 'null'
          title: License Date
          default: ''
        expire_date:
          anyOf:
          - type: string
          - type: 'null'
          title: Expire Date
          default: ''
      type: object
      required:
      - id
      - name
      title: LicenseRecord
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          type: array
          title: Detail
      type: object
      title: HTTPValidationError
    SheetOperationResponse:
      properties:
        success:
          type: boolean
          title: Success
        message:
          type: string
          title: Message
      type: object
      required:
      - success
      - message
      title: SheetOperationResponse
    ValidationError:
      properties:
        loc:
          items:
            anyOf:
            - type: string
            - type: integer
          type: array
          title: Location
        msg:
          type: string
          title: Message
        type:
          type: string
          title: Error Type
      type: object
      required:
      - loc
      - msg
      - type
      title: ValidationError
  securitySchemes:
    HTTPBearer:
      type: http
      scheme: bearer