Using API: How to list sheets in HOME root folder?

Eize Gever

Hi guys,

I would like to retrieve only the sheets in the HOME (root folder).

Using /home I can fetch all of of the data under HOME folder but this call may return a lot of data which I don't need (Workspaces, Folders).

How can I fetch only the Sheets in Home's top-level folder ?

Thanks!

Aviv.

Genevieve P.

Hi @Eize Gever

You will want to use the /home endpoint and list contents.

Using the include parameter you can get just sheets.

Please see our API documentation for more details, here:  https://smartsheet-platform.github.io/api-docs/#list-contents

Additionally, if you want to get the list of sheets in a specific folder, you you can use Get Folder: https://smartsheet-platform.github.io/api-docs/#get-folder

Cheers,

Genevieve

Eize Gever

Alternatively, how can I use List Sheets with a specific folder as filter ?

Genevieve P.

Hi @Eize Gever

You will want to use the /home endpoint and list contents.

Using the include parameter you can get just sheets.

Please see our API documentation for more details, here:  https://smartsheet-platform.github.io/api-docs/#list-contents

Additionally, if you want to get the list of sheets in a specific folder, you you can use Get Folder: https://smartsheet-platform.github.io/api-docs/#get-folder

Cheers,

Genevieve