Querying Smartsheet for All Projects

Neall Alcott · 01/21/20

Does anyone have an example of how to query for all sheets that were created using the project template?

Thanks!

Andrée Starå · 01/22/20

Hi Neall,

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Neall Alcott · 01/22/20

Thanks Andrée - I don't have any specific screenshots to show but what I want to do is query the API to get a list of projects. I'm looking to do some integration and want to verify if a Project already exists. Hence I don't want to get a list of all sheets, just the sheets that were created using the project template. Unless there is a better way to determine that a sheet is a project and not some other use.

Hope this makes sense - I'm new to Smartsheets and from what I'm seeing it's a very flat structure.

Neall

Andrée Starå · 01/23/20

Happy to help!

I'd recommend checking in the Developer Community as well and in the documentation, if you haven't already.

https://stackoverflow.com/questions/tagged/smartsheet-api

https://smartsheet-platform.github.io/api-docs/

I hope that helps!

Best,

Andrée

Querying Smartsheet for All Projects

Comments

Categories