Create URL from fixed text and input fields

Questions & Answers
1

I’m creating a scenario that integrates Zendesk with Monday.com. The data flows from Zendesk to M.C. One of the fields on my M.C board is a Link type. In one of the modules, I’m trying to build the URL string from hardcoded text plus a field from the Input to the module. The module fails with this error:

The operation failed with an error. 200 invalid value, please check our API documentation for the correct data structure for this column. https://api.developer.monday.com/docs/change-column-values [ Error Code: ColumnValueException / Error Details: {“column_value”:"{“url”=>"\"[https://<>.zendesk.com/agent/tickets/\](https://%3c%3cdomain%20goes%20here%3e%3e.zendesk.com/agent/tickets/)"+13", “text”=>13}",“column_type”:“LinkColumn”} ]

In the module field to update M.C I have this:
“https://<>.zendesk.com/agent/tickets/”+{{14.id}}
where {{14.id}} is the field from the input. (I’ve omitted the full domain name)

Submitted to support but thought I’d check here as well.

Thanks in advance!

1 Like
2

@Guy_Weisenbach

The main issue is that you have the “+” included as a character. You need to remove it (not needed here) or use the addition operator. Pick one of these:

https://<>.zendesk.com/agent/tickets/{{1.type}}
{{"https://<>.zendesk.com/agent/tickets/" + 1.type}}

I sometimes just use a “Set multiple variables” module to “test” expressions to make sure I’m getting the values I’m expecting

2 Likes
3

Thanks! I’ll give this a try.