What is the maximum number of sheets user can get from List sheet api response?

mukund waghmode

I want to know max number of sheets I can get from list sheet api. Is there any limit?

Genevieve P.

Hi Mukund,

As far as I'm aware, there is no limit to the number of sheets returned from the List Sheet action via API - the List Sheets operation should return all of the sheets that the user (access token owner) has access to.

Keep in mind that this is one of several Smartsheet API operations that support paging of results (see here).

If you're not seeing the sheets you expect to see in the API response, it's possible that results are being paged and the objects you're looking for are not contained within the initial page of results (the default page size = 100).

To see if this is the case, you could try including the includeAll=true querystring parameter on the API request URL.

Genevieve P.

Hi Mukund,

As far as I'm aware, there is no limit to the number of sheets returned from the List Sheet action via API - the List Sheets operation should return all of the sheets that the user (access token owner) has access to.

Keep in mind that this is one of several Smartsheet API operations that support paging of results (see here).

If you're not seeing the sheets you expect to see in the API response, it's possible that results are being paged and the objects you're looking for are not contained within the initial page of results (the default page size = 100).

To see if this is the case, you could try including the includeAll=true querystring parameter on the API request URL.