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?

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

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

Paul de Villiers

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.

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.