Getting a Template's columns and rows using the API

Dossy Shiobara

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

Genevieve P.

Hi @Dossy Shiobara

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