Getting a Template's columns and rows using the API
Is there a method for retrieving a Template's columns and rows using the API?
Trying to use the "Get Sheet" API method (e.g., /sheets/{sheetId}
) with a Template ID returns a "Not Found".
For now, I'm working around this by doing a "Create Sheet from Template", inspecting that temporary sheet as I need to, then deleting the sheet. This seems a bit wasteful and sub-optimal, and will result in a LOT of unnecessary sheets piling up in the trash bin for 30 days.
Is there an official way for us to request features? A "Get Template" API method (e.g., /templates/{templateId}
) that works just like the "Get Sheet" API method would be super helpful, here.
Thanks,
Dossy
Best Answer
-
There currently isn't a way to get Template information like this via the API; the Template item would need to be turned into a sheet so you can access the rows directly to get this information wit Get Sheet, as you've been doing.
Here's the documentation on the Template Object which lists the data types you can retrieve.
Please let the Product team know about your feedback through this form, here!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
There currently isn't a way to get Template information like this via the API; the Template item would need to be turned into a sheet so you can access the rows directly to get this information wit Get Sheet, as you've been doing.
Here's the documentation on the Template Object which lists the data types you can retrieve.
Please let the Product team know about your feedback through this form, here!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives