"Search Everything" API request always response with 'totalCount' limited to 100

Hello,

Is there a limit to the total number of search results to 100? For the example, the GET request to URL:

https://api.smartsheet.com/2.0/search/sheets/{sheetId}?query=stuff

always response with "totalCount": 100 even though I know there are more than that. Is there a way to increase the search results beyond 100?

Thanks

Find more posts tagged with

Accepted answers

John_Foster

Hi @ksngdavid,

Wel,l that wasn't easy to find. I had it stored on an old PC and have forgotten all the credentials to get in.

Anyway, I have had a look and I was wrong, the C# app I created did return all results. The code was from not long after I started coding so excuse it being untidy and not very well commented, but I have attached the code as a txt file.

SmartsheetAccess.txt

I have replaced the Smartheet Token and Sheet ID for obvious reasons.

I hope this helps!

John

All comments

John_Foster

Hi @ksngdavid,

I believe that yes the first response only retrieves 100 results, but that you can page through the results. I used to use a C# app that retrieved over 3000 rows and put the results into a SQL database. I can try and dig out the code if that helps, but I would not be able to do this for a few days as I will need to search for the SSD it is on.

John

ksngdavid

Hi @John_Foster

Thank you for your reply. Appreciate very much if you can locate your earlier code. That will definitely help.

David

John_Foster

Hi @ksngdavid,

Wel,l that wasn't easy to find. I had it stored on an old PC and have forgotten all the credentials to get in.

SmartsheetAccess.txt

I have replaced the Smartheet Token and Sheet ID for obvious reasons.

I hope this helps!

John

ksngdavid

Thanks @John_Foster !

Lee Joramo

More generally, you use "Paging" to get the number of results you want. Here is the API documentation:

https://smartsheet.redoc.ly/#section/Work-at-Scale/Paging

You will typically either set:

includeALL=true to get all of the records
or to get a specific number of records pageSize=250 and page=4 to get a specific number of records for a give "page"

Search the API documentation for examples for your specific language's SDK and method

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.