Hi devs and monday support.
We have noticed that, despite what is written in documentation, often the items_by_column_values query doesn’t return a match even if we wait 30 seconds after the insertion of a new item.
Sometimes we get a match after 3 minutes.
How can we improve/fix this behavior?
At moments where the server is experiencing lot of traffic, this might take a little longer than 30 seconds. If you are using a timeout here, I would go with a 60 seconds timeout just in case.
Having said that, 3 minutes is a lot for this.
Please send us an email to appsupport@monday.com with the query you used and a timestamp (date, hour, minute and location) if you experience that again so we can take a look into our logs.
I have experienced the same issue even up to 5 minutes and stopped using querying items_by_column_values if the item has been added anytime recently. Instead, I retrieve a list of every item on the board and its values and have to search that list. It is more reliable and can be used right after adding the item.
Just in case you miss the other topic, our team is working on something new (I can not share much right now) that will make the changes done to the board immediately available via items_by_column_values.
I do not have an ETA on but keep an eye on the changelog because we will announce it once it is ready