Convert Link ID from N8N not working

amp1enator · September 20, 2022, 2:39pm

Hi,

I am using the Seatable Node in N8N to get some tables automatically exported to a csv.

Inside the node of N8N (self hosted) it is possible to activate the Option “Convert Link ID”:

But the result is an completely empty column. When the option is deactivated I am getting the IDs.

As far as I see N8N is using the right command (Line 290):

n8n-io/n8n/blob/master/packages/nodes-base/nodes/SeaTable/RowDescription.ts

import type { INodeProperties } from 'n8n-workflow';

export const rowOperations: INodeProperties[] = [
	{
		displayName: 'Operation',
		name: 'operation',
		type: 'options',
		noDataExpression: true,
		options: [
			{
				name: 'Create',
				value: 'create',
				description: 'Create a row',
				action: 'Create a row',
			},
			{
				name: 'Delete',
				value: 'delete',
				description: 'Delete a row',
				action: 'Delete a row',

This file has been truncated. show original

Does anybody has an idea how to solve this and get the text instead of the ID?

Thanks!

EDIT: Line

Markus · September 20, 2022, 10:26pm

I’ve also recently had this issue. I have multiple columns with links and needed to solve it by having extra seatable nodes querying the ressources and merging them back together.
It was quite a painful and long process for something that I expected to be done by that option, actually.

Just a quick taste:

The subworkflows query each resource in turn, and in the end I assemble the data.

let objekt = $items("get Objekt")[0].json;

objekt["Wohnungseinheiten"] = $items("Assemble Wohnungseinheiten").map(item => item.json);
objekt["Garage / Stellplätze"] = $items("Assemble Garage / Stellplätze").map(item => item.json);
objekt["Grundrisse"] = $items("Assemble Grundrisse").map(item => item.json);

return objekt;

Maybe you can use a similar approach until this is fixed!

Tom · September 21, 2022, 5:21am

Right now I don’t have a system to reproduce this at hand, but it sounds to me now with two confirmations that it should be reported upstream in the N8N issue tracker:

Sign in to GitHub · GitHub

or alternatively in the community forums:

https://community.n8n.io/

IIRC from SeaTable API use, the link / table relation can flip depending in which table the link was created. Perhaps it’s just an off-by-one error looking up the ID in the wrong table and then getting empty results, but as written, I can not reproduce this right now, sorry.

amp1enator · September 21, 2022, 9:11am

Thank you.
@Markus: Great workaround, but I think it will get messy to fast for me…

@Tom: Thanks. Then I am assuming that the Code I mentioned is basically correct and the problem must be somewhere else. I´ve made an Issue for that in Github: Seatable Node: Convert Link ID not working · Issue #4155 · n8n-io/n8n · GitHub

amp1enator · September 27, 2022, 8:11pm

FYI: The solution for this is currently waiting in a push request.

Markus · October 15, 2022, 2:04pm

Can you update here when it’s through? I might have to adjust my workaround

amp1enator · October 20, 2022, 10:21am

Yes! It works. I found time now to apply the N8N Update and test ist. Works very well.

system · October 22, 2022, 10:22am

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.