Welcome!

Querying Smartsheet for All Projects

Neall Alcott

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

Thanks!

Find more posts tagged with

Comments

Andrée Starå

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

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å

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

Sign in to join the conversation!

Quick Links

Trending discussions

when will the australian region work with apps like zapier
I know this is a problem with EU region as well, but wanted to know when regions other than north america will get support for apps like zapier. Everywhere I have read it is always the app developers saying they are waiting on smartsheets. I have tried cloning the connection app on the websites like zapier and maker and…
Can the creation of timelines (from templates) be automated?
Hi - my organization has been using Smartsheet for several years and we're looking to automate wherever possible for consistency and efficiency. Whenever a new project starts, the PMO creates a timeline (save as new) from a template that's specific for that project type. The PMO manually updates the default value in a few…
New regression : column names bein trimmed by the api
I've a sheets where the columns names are the following (without the quotes) : "Expiration Date " "Expiration Date " So, the first one has a space at the end and the second one hasn't. Previously that was supported by smartsheet API AND the user interface, although it's not possible anymore. What's funny : Most features on…