# Linked Records via Node-Red **URL:** \ **Category:** Support, Troubleshooting, & Help\ **Tags:** node-red, linked-record\ **Created:** [March 6, 2026, 1:35am UTC](https://community.tulip.co/t/linked-records-via-node-red/16159 "2026-03-06T01:35:13Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![rinfantozzi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/rinfantozzi/32/7688_2.png) [@rinfantozzi](https://community.tulip.co/u/rinfantozzi)\ **Post date:** [March 6, 2026, 1:35am UTC](https://community.tulip.co/t/linked-records-via-node-red/16159/1 "2026-03-06T01:35:13Z")
Hey Tulip Community! I am currently trying to link records that are generated from a Node-Red flow using the node-red-tulip-api node and haven’t been able to find what is wrong with my request format. When I send the following msg.body to the tulip-table node I receive the following error: **Field Data Sources:** MY\_TABLE\_#\_link\_left\_column & MY\_TABLE\_#\_link\_right\_column (from each table where link exists): ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/8b09ea71f4118eafa839005d3cc0d427532f9f7c.png) **The Request format:** ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/2/2bb77100be9f12b46f968ff17359a8fc279ed4a6.png) This function node annotated above is connected between the Create Record tulip node (working 🙂) and the link node. ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/b/bd0bbd0296b1790e5c9f7f1cf7d552a7fc719f3e.png) I get a 400 (malformed request) response when the Link Record node runs. Based on my investigation thus far, it appears the path variable is not including the “msg.tableLinkId“ in the path of the response coming out of the link node. Here’s the output in response → req → path ```auto PUT /api/v3/tableLinks//link HTTP/1.1 content-type: application/json Host: my_company.tulip.co Authorization: (removed because API key lol) Connection: keep-alive Transfer-Encoding: chunked ``` **Other general questions I have about Link Records:** My plan is to use linked records to display the results of a few different tables (currently 3) into a single table view for operators to view. Should I continue with this approach or try to determine another solution? If anyone has implemented a similar solution or knows how I can resolve this, any help would be greatly appreciated 🙂 . ---
**Author:** ![thorsten.langner](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@thorsten.langner](https://community.tulip.co/u/thorsten.langner)\ **Post date:** [March 6, 2026, 8:18am UTC](https://community.tulip.co/t/linked-records-via-node-red/16159/2 "2026-03-06T08:18:44Z")
Not sure if this is what its about but I recognized two things: ```auto msg.body = { "leftRecord": "TABLE_1_ID_link_left_column", "rightRecord": "TABLE_2_ID_link_right_column", }; ``` there is a comma `, ` after the last entry before `};` This implies there is more key-value pairs following… ```auto msg.tableLinkId = "id"; ``` Is this only for testing? Is there a real record with the Id `"id"` ? Or did you mean to put a variable id ? ---
**Author:** ![rinfantozzi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/rinfantozzi/32/7688_2.png) [@rinfantozzi](https://community.tulip.co/u/rinfantozzi)\ **Post date:** [March 6, 2026, 3:50pm UTC](https://community.tulip.co/t/linked-records-via-node-red/16159/3 "2026-03-06T15:50:16Z")
Hey Thorsten, I’m not sure if the comma after the “TABLE\_2\_ID\_link\_right\_column” could cause this issue but I did remove it just to be safe 🙂 . The “id“ used in `(msg.tableLinkId = “id”;)` was used for testing only. In the real payload I am setting that in the msg.tableLinkId to be the epoch datetime of the record generation. When I check the debug after the link node I can see that the msg.tableLinkId does match the upstream setup. Example value from debug node: ```javascript msg.tableLinkId = “1772810940” ``` ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/7/7169c30ad876d5b08b69f125df1953de3cfd2a79.png) I’m not 100% sure from the API documentation if the tableLinkId field is meant to be: ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/840e336b9b7cec88438fa15e4e0661c22282df11.png) 1.) the ID of the table that contains the linked field or 2.) the table UID. 3.) the UID of the linked field column from the “left” table. Currently I have this as the ID of the table the table that contains the linked field. (number 1 above). Here’s a quick list of resources I’ve used so far to troubleshoot: - [node-red-tulip-api (node) - Node-RED](https://flows.nodered.org/node/@tulip/node-red-tulip-api) - [Link records](https://support.tulip.co/apidocs/link-records-1) I appreciate your response 🙂 . If there is any other details I can provide let me know. Thanks! ---
**Author:** ![thorsten.langner](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@thorsten.langner](https://community.tulip.co/u/thorsten.langner)\ **Post date:** [March 9, 2026, 8:02am UTC](https://community.tulip.co/t/linked-records-via-node-red/16159/4 "2026-03-09T08:02:24Z")
> [@rinfantozzi](#): > > I’m not 100% sure from the API documentation if the tableLinkId field is meant to be: When you look close, the `aK7mP3qRb9TzY1cHd_link_right_column` and `aK7mP3qRb9TzY1cHd_link_left_column` have the same random string. This isolated random string is the link ID: `aK7mP3qRb9TzY1cHd` You can find this out by using the Table api: `/tables/{tableId}` [Look up a Tulip Table](https://support.tulip.co/apidocs/look-up-a-tulip-table) ```auto ... "columns":[ { "name": "id" "label": "ID" "description": "" "dataType":{ "type": "string" } "hidden": false "unique": true } { "name": "aK7mP3qRb9TzY1cHd_link_right_column" "label": "Picture_ID" "description": "" "dataType":{ "columnOrientation": "right" "tableLinkID": "aK7mP3qRb9TzY1cHd" <-------------------here "type": "tableLink" } "hidden":boolfalse "unique":boolfalse } ... ```