Search API Request Returning Old Data for A Period of Time
I am using the search sheet REST API call for the first time. I tested against a known value in a sheet and it returned the correct rows. (the value was a choice in a multi-choice column.) Then I modified the sheet to remove the matching value and saved. Then I reran the REST API call and it still retrieved the row, even though the value had been removed. I did this several times over the next few minutes and still saw the same issue. When I actually retrieved the row using the Get Row call and the RowID from the search results, the matching value is not there.
When I ran the search again about 30 mins later, the search performed correctly and did not return any results.
It appears that the search api is searching against a cached version of the sheet for some period of time. Is this true? If so, what is the period of time?
Answers
-
Yes, the Search function can require up to ten minutes before being able to identify newly added and updated data, or in your case, recently removed data. (See: Search Sheet)
If you'd like to provide our Product team with feedback on this functionality, please fill out this form, here!
Thanks,
Genevieve
-
@Genevieve P. Thanks for that info. Good to know that the gap is fairly brief.
-
Recently the smarsheet search function cached old version over 2 hours, is it normal?
The issue is first found by using api /sheets/{sheetId}/rows to add new row then do search row using api /search/sheets/{sheetId}?query=updated_value, which is keeping to return total count= 0 over 2 hours. Try Search from SmartSheet UI search function and getting same issue. Hope SmartSheet technical support can address this.
