create_record

create_record

Generate a new record in a datasheet by extracting key information from user input. Convert provided text into a JSON object based on a predefined schema for structured data storage.

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