Get Sheet (ID) by Name using Smartsheet API

Hi @jokano1

I would use List Sheets to get a list of all the sheets I have access to (see here), which will bring back the sheet Name and ID. Then loop through to match the Name and get the Sheet ID for your next call.

Cheers,

Genevieve

Hi @OptimusPrime

https://api.smartsheet.com/2.0/sheets

will get you a list of all the sheets that your account has access to. 🙂

Hi @OptimusPrime

That is not a link to a website, it's an example of the API URL that you can use, for example in Postman, to generate a list of sheets. 🙂 I've updated it so there's no hidden hyperlink which may have caused the confusion.

Here's a link to the API Documentation with more information:

https://smartsheet.redoc.ly/tag/sheets/

Hi @OptimusPrime

I'm not a developer so I won't be the best person to help write any code; I would suggest posting in a developer forum such as StackOverflow if you would like help creating API calls.

I will say, thinking about this again, you can likely use Search Everything instead, with your key phrase as the query and then the scope being "sheetNames" if that's easier:

https://smartsheet.redoc.ly/tag/search#operation/list-search

Hi @OptimusPrime

The Community is primarily a member-to-member space to ask questions, share best practices, and chat about Smartsheet with other users (versus Smartsheet staff - although we do pop in to help).

It's very likely that there are other members who are developers that may be able to give you the support you're looking for! Although I would note that the StackOverflow community linked above may be a better space for that, as it's built specifically for developers.

If you're looking for someone to create solutions on your behalf, you could post in the Community Job Board area as there are a number of consultants here in the forum that may be a good fit. You could also contact Smartsheet's Consulting Team, here if that helps!

As a side note, did the Search Everything work better for your purposes?

Cheers,
Genevieve