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
-
Hi Paul,
Based on this information I'm unable to see why 97/H wouldn't be included. I would suggest reaching out to Smartsheet Support (here) with more information about your sheet & how it's set up so they can troubleshoot this with you directly.
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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 :-)
-
Hmm, that's definitely not expected behaviour... but I'm glad you figured something out!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives