How to get the value of a column in a custom integration?

Hi :wave:
I’m trying to use a column value in a receipt instead of column id.
In the receipt, {site name,siteNameId} will return the id of the column selected by the user.
How can I get the value of the column selected by the user instead of having the column ID?
Is there a real documentation somewhere with all this stuff?

Hi @jeromeskiply

There is a columnValue available in the recipe builder, e.g.

When {status, columnId} changes to {something, columnValue}

in this case you configure which columnId the columnValue takes it’s values from. Is this what you are looking for or do you want to get the value of the column in the action. If the latter, then you can do that in your custom action and code it in your backend.

Hope this answers your question

1 Like

Thanks for your help @basdebruin. On the trigger side, it is ok.
I’m trying to retrieve the value of the column selected by the user in the action to send it to my endpoint.
I have a column with id “siteId”, and when the user change the value of an other column (status), I need to send the value of the column with id “siteId”. I could send the itemId to my app, and then make an api request to find the value of siteId, but it could be much more straight forward to send it directly… I saw a “general value” field in the custom action form, so I was wondering if there was a way to do that.

OK, understood.

I did not tested this yet but I don’t think you can use the columnValue in your action builder. When you
endpoint is called (by the trigger) you can retrieve the value of a column / item by calling the monday API from your endpoint. I use something like this to do that in my endpoint

const dates = await mondayService.getColumnValues(token, itemId, [
columnIdStart,
columnIdEnd,
]);

I get the columnId’s from the action in my endpoint and I use a service (getColumnValues) that call the API. This gives me the value of both dates columns in JSON format.

1 Like

Yes, I was doing the same until now. Thanks for your feedback.

@dipro do you confirm that we can’t get directly the value of the columns in the action? What is the purpose of the “General value” in the custom action fields type?

Today I got it working with a Status column and a StatusColumnValue in the action part of the builder. However, the Status column should be in the recipe sentence. I tried trigger output as the source of the Status column (as it is also in my trigger) but in that case you can’t select the StatusColumnValue.

Hope that helps

Hey Jerome,

Unless the column ID you’re looking for is configured in the recipe sentence, it won’t be passed to your action. This is because the integration’s context is a board (not a specific column).

In this case, your action should call the API to get the value of the column, and then do whatever application logic you’re looking to achieve.

I hear what you’re saying though, and will pass on the feedback to our apps team!

2 Likes