Linked Records Tools

Tools for creating links between records in different tables.

6 tools

Available Tools

linkedRecords_createLinkField

Create a link field to connect two tables

Input Schema

`tableId`	stringrequired	Source table ID from listTables
`name`	stringrequired	Name for the link field
`description`	string	Optional description
`linkedTableId`	stringrequired	Target table ID to link to
`linkType`	stringrequired	Relationship type: "one_to_one", "one_to_many", or "many_to_many"
`linkDisplayMode`	string	Display mode: "COUNT", "LABELS", or "CHIPS"
`allowMultipleLinks`	boolean	Allow linking to multiple records
`linkOnDelete`	string	Action on delete: "CASCADE", "SET_NULL", "RESTRICT", "NO_ACTION"
`linkOnUpdate`	string	Action on update
`createReciprocal`	boolean	Create reciprocal field in target table

Example Call

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "linkedRecords_createLinkField",
    "arguments": {
          "tableId": "example",
          "name": "example",
          "description": "example"
    }
  }
}

linkedRecords_linkRecords

Link records between tables

Input Schema

`tableId`	stringrequired	Source table ID
`recordId`	stringrequired	Source row ID to link from
`fieldId`	stringrequired	Link field ID
`linkedRecordIds`	arrayrequired	Array of target row IDs to link to
`preserveOrder`	boolean	Preserve order of linked records

Example Call

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "linkedRecords_linkRecords",
    "arguments": {
          "tableId": "example",
          "recordId": "example",
          "fieldId": "example"
    }
  }
}

linkedRecords_unlinkRecords

Unlink records between tables

Input Schema

`tableId`	stringrequired	Source table ID
`recordId`	stringrequired	Source row ID
`fieldId`	stringrequired	Link field ID
`linkedRecordIds`	arrayrequired	Array of target row IDs to unlink

Example Call

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "linkedRecords_unlinkRecords",
    "arguments": {
          "tableId": "example",
          "recordId": "example",
          "fieldId": "example"
    }
  }
}

linkedRecords_getLinkedRecords

Get linked records for a record

Input Schema

`tableId`	stringrequired	Source table ID
`recordId`	stringrequired	Source row ID
`fieldId`	stringrequired	Link field ID
`expand`	boolean	Include full record data
`limit`	number	Max records to return (default: 50)
`offset`	number	Skip records for pagination
`sortBy`	string	Field to sort by
`sortDirection`	string	Sort direction

Example Call

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "linkedRecords_getLinkedRecords",
    "arguments": {
          "tableId": "example",
          "recordId": "example",
          "fieldId": "example"
    }
  }
}

linkedRecords_bulkLinkRecords

Bulk link/unlink operations on multiple records

Input Schema

`tableId`	stringrequired	Source table ID
`fieldId`	stringrequired	Link field ID
`operations`	arrayrequired	Array of link operations to perform

Example Call

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "linkedRecords_bulkLinkRecords",
    "arguments": {
          "tableId": "example",
          "fieldId": "example",
          "operations": {}
    }
  }
}

linkedRecords_reorderLinkedRecords

Reorder linked records

Input Schema

`tableId`	stringrequired	Source table ID
`recordId`	stringrequired	Source row ID
`fieldId`	stringrequired	Link field ID
`orderedRecordIds`	arrayrequired	Target row IDs in desired order

Example Call

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "linkedRecords_reorderLinkedRecords",
    "arguments": {
          "tableId": "example",
          "recordId": "example",
          "fieldId": "example"
    }
  }
}