8
n8n 中文网amn8n.com

通过API链接NocoDB记录🔗

中级

这是一个Engineering领域的自动化工作流，包含 12 个节点。主要使用 Set, NocoDb, HttpRequest, ManualTrigger 等节点。 通过API链接NocoDB记录🔗

前置要求
  • •可能需要目标 API 的认证凭证

使用的节点 (12)

Set
NocoDb
StickyNote
HttpRequest
ManualTrigger

分类

工程
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "2Pm4HYVtOrq8H0EK",
  "meta": {
    "instanceId": "bcc0fe85b176c2837affb21bb7d7397fad2549880e73dc1f7a42e76ae94fd996",
    "templateCredsSetupCompleted": true
  },
  "name": "Linking NocoDB Records via API 🔗",
  "tags": [
    {
      "id": "8AEG2zFZndeg1imh",
      "name": "nocodb",
      "createdAt": "2025-05-14T02:58:20.883Z",
      "updatedAt": "2025-05-14T02:58:20.883Z"
    },
    {
      "id": "Y3u7fuGgTL5xyaVG",
      "name": "database db",
      "createdAt": "2025-03-13T10:14:54.572Z",
      "updatedAt": "2025-04-07T06:12:25.593Z"
    }
  ],
  "nodes": [
    {
      "id": "1285cb8b-45ab-4a87-9155-af8e06a195aa",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1888e045-284f-4b1d-b3fd-8ddecc2d5bc2",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -140
      ],
      "parameters": {
        "color": 3,
        "width": 260,
        "height": 580,
        "content": "# NocoDB Many to Many Link Record\n\n## API POST to Link Records\nhttp://localhost:8080/api/v2/tables/{tableId}/links/{linkFieldId}/records/{recordId}\n\n## NocoDB Data API\nhttps://data-apis-v2.nocodb.com/#tag/Table-Records/operation/db-data-table-row-nested-list\n\n## NocoDB Meta API\nhttps://meta-apis-v2.nocodb.com/\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "6f9aac5b-e767-44bc-aba9-12b80500da78",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        -460
      ],
      "parameters": {
        "width": 220,
        "height": 620,
        "content": "### Target Table\n\nThis is the table you are linking to — the \"destination\"\n\n#### Example I Show:\nONE Video Production (Target) is linked to MANY Scenes (Source)\n\n#### Many to Many - Target and Source are insignificant\nExample:  MANY Video Productions have MANY Scenes - i.e. You can use scenes in various productions, and you want to keep records where those scenes are being used"
      },
      "typeVersion": 1
    },
    {
      "id": "6adaeec0-ab7b-4dca-8147-0801f0a215f8",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        600,
        -120
      ],
      "parameters": {
        "width": 220,
        "height": 280,
        "content": "### Source Table (Many)\n\nThis is where the link field lives — the \"starting point\" for the link\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8c028f2f-840c-4287-b6cc-fc6123eff6a7",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1340,
        -140
      ],
      "parameters": {
        "color": 3,
        "width": 440,
        "height": 440,
        "content": "## In Other Words\n\nPOST:\nhttps://<YOUR NOCODB URL -- see 'Set Variables' node>/api/v2/tables/<TARGET TABLE ID -- see 'Set Variables' node>/links/<TARGET TABLE COLUMN ID -- see 'Get Target Table Meta Data' node>/records/<TARGET TABLE RECORD ID -- see 'Get Target Table Row' node, 'Formula' Column using RECORD_ID()>\n\nBODY (single record):\n[ { \"Id\": <SOURCE TABLE RECORD ID -- see 'Get Source Table Row' node, 'Formula' Column using RECORD_ID()> } ]\n\nBODY (many records from source):\n[\n  { \"Id\": <1st Record ID> },\n  { \"Id\": <2nd Record ID> },\n  ...{ \"Id\": <X Record IDs> },...\n  { \"Id\": <Last Record ID> }\n]\n"
      },
      "typeVersion": 1
    },
    {
      "id": "2d86e7fb-936d-4f4c-8d1d-c6e50fa90a38",
      "name": "Grab Target Table Row",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        440,
        0
      ],
      "parameters": {
        "id": "={{ $json.target_table_row_id }}",
        "table": "mc5ihmltcqfco2v",
        "projectId": "p82se8ug6ui5lt0",
        "authentication": "nocoDbApiToken"
      },
      "credentials": {
        "nocoDbApiToken": {
          "id": "Lrr0RsBkym1lNmzu",
          "name": "NocoDB Token account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "699ea454-8841-465b-90d7-d093c4086cff",
      "name": "Set Variables",
      "type": "n8n-nodes-base.set",
      "position": [
        220,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9dd187fd-3957-4549-81ff-1d2190efd711",
              "name": "my_nocodb",
              "type": "string",
              "value": "<Your NocoDB URL, example: nocodb.myserver.com>"
            },
            {
              "id": "cc3e739a-d2ed-498c-bbc4-0f24b1134a87",
              "name": "target_table_id",
              "type": "string",
              "value": "<the ID of TARGET Table, see Video>"
            },
            {
              "id": "dcfdd5d4-4114-46b2-988a-2c10676ceae2",
              "name": "target_table_row_id",
              "type": "string",
              "value": "<the Record-ID of TARGET Table that you want to link to, see Video, example: 5>"
            },
            {
              "id": "e4962b5b-9c62-4c98-ab01-44f7142bf7e3",
              "name": "source_table_row_id",
              "type": "string",
              "value": "<the Record-ID of SOURCE Table that you want to link from, see Video, example: 23>"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "a2c900e3-4515-4e9b-a99c-d62014f70c6c",
      "name": "Get Target Table Meta Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        880,
        0
      ],
      "parameters": {
        "url": "=https://{{ $('Set Variables').item.json.my_nocodb }}/api/v2/meta/tables/{{ $('Set Variables').item.json.target_table_id }}",
        "options": {},
        "sendHeaders": true,
        "authentication": "predefinedCredentialType",
        "headerParameters": {
          "parameters": [
            {
              "name": "accept",
              "value": "application/json"
            }
          ]
        },
        "nodeCredentialType": "nocoDbApiToken"
      },
      "credentials": {
        "nocoDbApiToken": {
          "id": "Lrr0RsBkym1lNmzu",
          "name": "NocoDB Token account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "ece698e5-29d1-493a-97d3-4ea66ef36e15",
      "name": "Get Source Table Row",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        660,
        0
      ],
      "parameters": {
        "id": "={{ $('Set Variables').item.json.source_table_row_id }}",
        "table": "mm94d1xdbfrn1oe",
        "projectId": "p82se8ug6ui5lt0",
        "authentication": "nocoDbApiToken"
      },
      "credentials": {
        "nocoDbApiToken": {
          "id": "Lrr0RsBkym1lNmzu",
          "name": "NocoDB Token account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "bf318290-c151-4eb0-944e-37b66cb69d8e",
      "name": "Link Record from Source to Target",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1100,
        0
      ],
      "parameters": {
        "url": "=https://{{ $('Set Variables').item.json.my_nocodb }}/api/v2/tables/{{ $('Set Variables').item.json.target_table_id }}/links/{{ $('Get Target Table Meta Data').item.json.columns[11].id }}/records/{{ $('Grab Target Table Row').item.json['Record ID'] }}",
        "method": "POST",
        "options": {},
        "jsonBody": "=[ { \"Id\": {{ $('Get Source Table Row').item.json['Record ID'] }} } ]",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "authentication": "predefinedCredentialType",
        "headerParameters": {
          "parameters": [
            {
              "name": "accept",
              "value": "application/json"
            },
            {
              "name": "content-type",
              "value": "application/json"
            }
          ]
        },
        "nodeCredentialType": "nocoDbApiToken"
      },
      "credentials": {
        "nocoDbApiToken": {
          "id": "Lrr0RsBkym1lNmzu",
          "name": "NocoDB Token account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "993d1c7c-c7fc-49af-b046-4a9a87351799",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        360,
        280
      ],
      "parameters": {
        "color": 5,
        "width": 560,
        "height": 80,
        "content": "## Video Guide: https://youtu.be/-srzNushUsk"
      },
      "typeVersion": 1
    },
    {
      "id": "3eaf41c0-235f-4f29-82a4-d875d1dcb9d0",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        190,
        -40
      ],
      "parameters": {
        "color": 2,
        "width": 160,
        "height": 200,
        "content": "### Set These!\n\n\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "0c26a980-72d0-4c49-941a-8c555ca94b08",
  "connections": {
    "699ea454-8841-465b-90d7-d093c4086cff": {
      "main": [
        [
          {
            "node": "2d86e7fb-936d-4f4c-8d1d-c6e50fa90a38",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ece698e5-29d1-493a-97d3-4ea66ef36e15": {
      "main": [
        [
          {
            "node": "a2c900e3-4515-4e9b-a99c-d62014f70c6c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2d86e7fb-936d-4f4c-8d1d-c6e50fa90a38": {
      "main": [
        [
          {
            "node": "ece698e5-29d1-493a-97d3-4ea66ef36e15",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a2c900e3-4515-4e9b-a99c-d62014f70c6c": {
      "main": [
        [
          {
            "node": "bf318290-c151-4eb0-944e-37b66cb69d8e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1285cb8b-45ab-4a87-9155-af8e06a195aa": {
      "main": [
        [
          {
            "node": "699ea454-8841-465b-90d7-d093c4086cff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 工程

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

新的 OpenAI 图像生成
使用OpenAI GPT-Image-1模型生成自定义AI图像
Set
Split Out
Http Request
+
Set
Split Out
Http Request
6 节点Max aka Mosheh
设计
AI智能助手：与Supabase存储和Google Drive文件对话
AI智能助手：与Supabase存储和Google Drive文件对话
If
Set
Wait
+
If
Set
Wait
62 节点Mark Shcherbakov
工程
支持文本、语音、图像和PDF的AI驱动WhatsApp聊天机器人（RAG）
支持文本、语音、图像和PDF的AI驱动WhatsApp聊天机器人（RAG）
Set
Code
Switch
+
Set
Code
Switch
35 节点NovaNode
工程
API架构提取器
API架构提取器
If
Set
Code
+
If
Set
Code
88 节点Polina Medvedieva
工程
使用Bright Data网络爬虫进行结构化批量数据提取
使用Bright Data和Webhook通知的异步批量网络爬取
If
Set
Wait
+
If
Set
Wait
16 节点Ranjan Dailata
工程
发布视频和图片 - 新 Blotato 节点
使用 Blotato 和 Airtable 自动发布内容到 9 个社交平台
Set
Code
Wait
+
Set
Code
Wait
51 节点Max aka Mosheh
社交媒体
工作流信息
难度等级
中级
节点数量12
分类1
节点类型5
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Max aka Mosheh

Max aka Mosheh

@aiwithapex

Max is an IBM-certified AI developer with a BS in Computer Science and 20+ years in software, AI consulting, and leadership. He founded several modest ventures and serves as Board President of RedeemTheOppressed.org. Married with five children, he’s raised over $3.5M for persecuted minorities. Ventures: Motivate-Mate.com | | MusicWithMax.com | VoiceAIBonanza.com | ApexWebServices.com | HeimishGiving.org | ForAfricanJews.org | AI Automation community - https://www.skool.com/ai-with-apex/about

外部链接
在 n8n.io 查看 →

分享此工作流

分类

多模态 AI
1540
人工智能
1108
内容创作
695
AI 摘要总结
516
营销
419
AI 聊天机器人
251
工程
241
市场调研
203
杂项
193
其他
176
销售
162
IT 运维
156
文档提取
147
AI RAG 检索增强
146
构建模块
144
社交媒体
137
潜在客户开发
125
个人效率
117
开发运维
111
人力资源
101
客户支持
97
客户培育
87
客户关系管理
82
财务
81
产品
77
客服机器人
76
设计
70
工单管理
67
安全运维
57
发票处理
53
加密货币交易
49
文件管理
39
项目管理
35
内部知识库
32

分类: 34