Search api not finding results consistently

Paul de Villiers
edited 07/02/20 in API & Developers

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?

Tags:

Answers

  • Genevieve P.
    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 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

  • 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.
    Genevieve P. Employee Admin

    Hmm, that's definitely not expected behaviour... but I'm glad you figured something out!