create_record

create_record

Add new records to a datasheet by extracting and structuring key information from provided text. Use the Fields JSON Schema to ensure data adheres to the required format and create JSON objects for seamless integration.

Instructions

Create a new record in the datasheet. Extract key information from user-provided text based on a predefined Fields JSON Schema and create a new record in the datasheet as a JSON object.

Input Schema

Name	Required	Description
`attachments_fields`	No	A JSON object containing Attachment type field data. Keys represent field names and values are arrays of attachment objects. The structure of attachment objects must conform to the Fields JSON Schema provided by the "get_fields_schema" tool. You need to use the "upload_file_via_url" tool to obtain the attachment objects.
`fields`	Yes	A JSON object containing non-Attachment type field data. Keys represent field names and values represent field values. Omit unspecified fields in the API request. The structure of field values must conform to the Fields JSON Schema provided by the "get_fields_schema" tool.
`node_id`	Yes	The ID of the datasheet where the new record will be created.

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "attachments_fields": {
      "additionalProperties": {
        "items": {
          "additionalProperties": false,
          "properties": {
            "height": {
              "type": "number"
            },
            "mimeType": {
              "type": "string"
            },
            "name": {
              "type": "string"
            },
            "size": {
              "type": "number"
            },
            "token": {
              "type": "string"
            },
            "url": {
              "type": "string"
            },
            "width": {
              "type": "number"
            }
          },
          "required": [
            "token",
            "name",
            "size",
            "mimeType",
            "url"
          ],
          "type": "object"
        },
        "type": "array"
      },
      "description": "A JSON object containing Attachment type field data. Keys represent field names and values are arrays of attachment objects. The structure of attachment objects must conform to the Fields JSON Schema provided by the \"get_fields_schema\" tool. You need to use the \"upload_file_via_url\" tool to obtain the attachment objects.",
      "type": "object"
    },
    "fields": {
      "additionalProperties": {},
      "description": "A JSON object containing non-Attachment type field data. Keys represent field names and values represent field values. Omit unspecified fields in the API request. The structure of field values must conform to the Fields JSON Schema provided by the \"get_fields_schema\" tool.",
      "type": "object"
    },
    "node_id": {
      "description": "The ID of the datasheet where the new record will be created.",
      "type": "string"
    }
  },
  "required": [
    "node_id",
    "fields"
  ],
  "type": "object"
}

AITable MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from AITable MCP Server

Related Tools

MCP directory API