Hi
I know it has to be something obvious, and that it’s my fault but for the life of me I can’t get items_by_column_values to return any items. I’m using the API explorer and this is my query:
{
items_by_column_values(board_id: 266640420, column_id: "link3", column_value: "helpscout", state: all, column_type: "link") {
id
name
}
}
I’ve checked the board id, and column id and data a hundred times And that same query on monday.com returns tens of items.
Thank you!
edit: just to be clear, I’m not getting any errors but an empty data set:
Welcome to the community. What is the column type of column with the id “link3”? If that is a mirror column I am afraid you can’t do a items_by_column_values on a mirror column. Remember that the data does not “live” on that board but somewhere else. Just to make sure it is working as expected you can change the boardId and columnId to the board and column that is actually holding the data.
I am able to get the items with an items_by_column_values using the text to display part, not by using the web address. It looks like this is “by design”.
I’m afraid I can only confirm what @basdebruin has mentioned here. Only cases when the value is an exact and case-sensitive match will be returned.
I agree it would be a massive improvement to the monday.com API to handle wildcards for this query, but in the meantime, I can only recommend querying for all results in the board, and then filtering through the data. Otherwise, if you are sending items to monday.com via API, you could include some tagging system by using Status columns, for example, to hold the source of the data.
I hope this helps, and I’m glad Bas was able to shed more light on this.