Search api not finding results consistently
Hi Guys
We are doing an all-sheets search via the API and cannot figure out why, on one of the sheets, it is not including certain rows:
The search is:
https://api.smartsheet.com/2.0/search?scopes=cellData&query=“97 *”
We are trying to match all rows where the column starts with 97*
The results consistently ignore the cells which end in /H
so it gets
97/145 and 97/D but does not get 97/H
On another sheet it gets all 3....
Can anyone shed any light on this issue?
Answers
-
Genevieve P. Employee Admin
Hi Paul,
Based on this information I'm unable to see why 97/H wouldn't be included. I would suggest reaching out toSmartsheet Support (here)with more information about your sheet & how it's set up so they can troubleshoot this with you directly.
Thanks!
Genevieve
-
Thanks for the feedback - I did further testing and found that, for no apparent reason, 97/H simply will not be detected when searching for '97*' - however, when search for '97/H' specifically it finds it... so I extended my API calls to first search for '97*' and then follow it up with a search for '97/H' - after which I merged the results.
It's a work-around but it gets the job done :-)
-
Genevieve P. Employee Admin
Hmm, that's definitely not expected behaviour... but I'm glad you figured something out!