Getting Actual Row ID Within Coda

So I’m aware that I can use RowID() to return the ID value within the table, but based on the return results from the API this isn’t the same as the actual row ID, it’s actually the index (at least I think so).

I need the actual “id” i.e. “i-ft58426d56a2dds” to be accessible from within the table, so that I can use it in a webhook. Is that possible?

Hi @Murray_Adcock,

:slight_smile: no we dont expose it anywhere - are you looking to access same row every time ? you could give it a name and use that way through api - you dont need an internal row id for that.

our api to access row is https://coda.io/apis/v1beta1/docs/{docId}/tables/{tableIdOrName}/rows/{rowIdOrName}

more info here: https://coda.io/developers/apis/v1beta1#operation/upsertRows

Thank you.

1 Like

Thanks, but the name is a little too tricky. There could be multiple rows with the same title at the moment, plus it’s a user editable field. Does the “name” have to be the tagged column? If not, I could just create a column with a guaranteed unique field.

To be clear, I’m looking to set up a button that links to a webhook and passes information to a third-party tool, which manipulates it and passes it back (effectively a Zapier “Zap” like interaction, but without Zapier as we don’t want to migrate to that system); I want the passed back value to go to the row on which the button was triggered. Whilst the interaction should be fairly instantaneous, we have a number of people working on this doc simultaneously, so it’s certainly possible that the tagged column get change without someone realising.

EDIT: Actually, thinking about this more closely, it’s a guarantee that we will have identical names within the data set. I’m using the table as a cross-channel content scheduler, storing everything from long-form articles to social media posts, but we have functionality where you can “push” an article to social media and use the fact that the “name” is the same to track that relationship. I’ll be able to use “name” for genuinely instant interactions, but any kind of long-form tracking requires access to the ID, so it’s a shame I can’t access it from within Coda directly.

1 Like

Hi @Murray_Adcock,

Thanks for highlighting your use case. I am asking folks on the team more familiar with this area to figure out how we can help.

For now, here’s a workaround that could help. (not ideal, but may be as a stop gap measure?)

  1. Open record in detail view (like here https://cl.ly/151faea219e2/Screen%2520Recording%25202019-02-15%2520at%252012.56%2520PM.gif)
  2. Once you have a url for the row, you could use https://coda.io/developers/apis/v1beta1#operation/resolveBrowserLink to retrieve the URL for the row.

Thank you.

Interesting, I was looking into ways to do this myself, though again it’s a shame it can’t be (easily) automated. I was wondering if there might be a way to resolve the link directly in a function. Will continue looking into it :wink:

1 Like

Could you use the following formula in a hidden field as your makeshift ID?

Middle(Random(false),3,16)