Question on autopopulate fields in messages

Hi @nyxophyl!

I believe what you may be confused about here are the column IDs for each column on your board.

It sounds like the column ID for this date column is “date4.” Typically, this is how all column IDs will be structured. For example, Timeline columns will have the column IDs “timeline,” or “timeline2,” or “timeline4”… etc. etc.

This is how you can differentiate between the different columns of the same type within your boards. Column IDs are board-specific.

Regarding your overall question, I’m not totally sure I understand. What is your integration recipe doing? I think this is the context I’m missing.

Thanks!

Hi @Helen,
many thanks for the hint. That was exactly what I missed. I never tried to query the ID of the columns as I thought this will be just another big number that I could not use. And yes, the ID of the date column is indeed date4.
As background, my integration gets the prepared message, e.g. when a new item is created and needs to replace the autopopulated fields with the values from the board via the monday.com API and shows it as the complete text to the user on an external messaging server.
And just as a question: did I miss this information in your documentation for developers? As I think it is very useful to know what is needed to query your API to get the values of these autopopulated fields in a recipe’s message.

Hey @nyxophyl 👋

Thank you for following up here! That’s a great question.

We did recently change our interface to use the actual column names, instead of showing the IDs of th columns in the notification configuration, in an effort to make the interface more user-friendly. In general, when you try and construct the message in an integration recipe, you will need to query the column values of those specific columns by ID, and then insert that as text into your message directly.

Within your app, you should receive a payload that will contain the Item ID that triggered the integration recipe, and you can use that to query specific column values of that item, using a query like the below:

query {
  items (ids:1248088168) {
    column_values (ids:"status") {
      text
    }
  }
}

Where the Item ID is used from the triggering item, and the column ID comes from the user’s message config. The result of this query will typically look like so:

You can then input that result into your actual message. Hope this makes a bit more sense!

-Alex

Hi @AlexSavchuk,
thanks for the additional info. Yes, it makes it more clear. And I already could continue with Helen’s answer 😀.
Cheers, Marcus

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