Items_by_column_values sometimes doesnt return values, and after a period of time it might do

Hey,

Im making an API call (can see below). sometimes it will return values and sometimes it will not.
If I will wait I might get values back. didnt find any pattern…
When querying the record itself, it finds it with the correct value in the status.

The condition column type is a Select (which should support this functionality, according to the API docs).
Is any one can assist me to understand why I do not see the relevant records always?

Thanks!
Eitan

query ($boardId: Int!, $columnId: String!, $columnValue: String!){
items_by_column_values (board_id: $boardId, column_id: $columnId, column_value: $columnValue) {
id
name
column_values{
title
value
id
text
additional_info
type
}
}
}

Parameters:
{“boardId”:XXXXXXX, “columnId”:“status1”, “columnValue”:“Ready For Review”}

Hi @eitanal,

Welcome to the community! We hope you like it here :rocket:

When you get no values returned, do you get an error? What kind of response do you see?

Hey,
I receive a response with 0 match, like when searching a value that doesn’t exists.
And after some time, making the same call will return the correct result.

This email message and its attachments are for the sole use of the intended recipient(s) and may not be shared with any other party. They may contain confidential information of 888 Holdings plc or its direct and indirect subsidiaries (together, the “888 Group”) and are to be regarded as confidential information under any non-disclosure agreement. Any review, use, disclosure or distribution by persons or entities other than the intended recipient(s) is prohibited. Nothing in this message is capable of or intended to create any legally binding obligation. The 888 Group will only ever assume a legally binding obligation where recorded in a written agreement duly executed by the authorized signatories of the relevant 888 Group company. The 888 Group accepts no liability for any personal views expressed in this message. If you are not the intended recipient, please contact the sender by return and destroy all copies of the original message and its attachments. Thank you

@eitanal, @alessandra

This is the expected result. The update of the part of the database that is used to perform searches is asynchronous. Therefore, changes to items will not immediately be reflected when using the Items_by_column_values. Of course, if they NEVER show up, that is NOT expected.


Jim - The Monday Man
:magic_wand: Column Magic :sparkles:- the magical columns toolbox app

Hello @eitanal!

As @JCorrell says, for this query, there are a few seconds between the moment in which a change is made in the board and the moment that change is visible for this method. Try waiting for some time. If it takes, let’s say longer than a minute for the change to be visible using this method, please do let us know!

Hey,

I understand it might take some time for an action to be reflect in the board (UI).
But, when I use: get item by id query (items (ids:)), the change can be seen immediately, which “items_by_column_values” query still doesn’t reflects it.
It takes almost 1 minute (just tested it) for this query to retrieve the relevant values after the change.
More over, I’m changing the status also by API call, and that makes the issue to be up to 2 minutes delay (sometimes)…

The question is:
** Why the get item query (items (ids:)) do get the correct response immediately and the items_by_column_values doesn’t.

Thanks!
Eitan

Hello again @eitanal!

The regular items query has a different mechanism than items_by_column_values, that is why one of them is immediate and the other takes time to show the changes.

If you see a big delay like the one you mention (2 minutes), please send an email to appsupport@monday.com with:

  • Item ID of the item that was changed prior to the request
  • Query being used
  • User ID of the user whose API key is being used for the request
  • Timestamp of the request (Location, date, hour, minute)

So that our technical team can take a closer look into it :slightly_smiling_face:

Cheers,
Matias