RowID in N8N Coda node (get row)

1

Hi I am using the Coda n8n node with “get row” operation.

The tool requires the RowID to function, however from all documentation I can find on this, including topics on this community, I am understanding that RowID is never exposed (Getting Actual Row ID Within Coda) so I am a little confused as to why an official Coda tool is asking for something which is “never exposed”.

image
image631×652 23.3 KB

How do I provide this tool the rowID it expects? I am guessing I am missing something very obvious. :sweat_smile:

2

Hi Darie - you can get the row ID by searching for the row first, and then mapping the ID. I don’t know your exact workflow here, so that’s only one option. The Coda API does output the Row ID when you search rows, for example.

See the documentation for the “Get row” endpoint here

And the documentation for “List rows” here

notice the "id" parameter within "items" in the api response
notice the "id" parameter within "items" in the api response569×693 22.2 KB

3

Thanks Simon, the issue with searching for a row first (get many rows) is that

  1. there’s thousands of rows
  2. you need a different identifier, essentially faking rowID, to then find real rowID.

I found a hacky solution to this by creating a formula column with:

Split(thisRow + “”, “/”).Last()

This actually exposes the rowID inside a column which I can then send to n8n using a POST function. So much easier! As to why it needs to be this way I don’t know but it at least works.

4

@Darie_Nani

What you mean by faking RowID? There a real RowID() formula that allocates a unique ID to each table row.

5

Yes, this formula, however, it isn’t documented (at least I couldn’t find it in official docs). I came across this in another post on here after asking this question.