Is there an API to get the Published Items report?

Genome Team

I know you can export the Published Items report from Admin Center -> User Management -> More Actions -> Published Items. But is there an API we can use so we can automatically / programmatically get this report?

David Dolch

You can generate an API token from your Account Menu, under Apps and Integration.

The API token will have the same access rights as the account that generated it.

Genome Team

Thanks David for the quick reply. I'm wondering which API endpoint I need to use? I've looked into documentation that Smartsheet has here https://smartsheet-platform.github.io/api-docs/ and can't seem to figure out which one (or if there is even one) that I need to call to get the Published Items report.

Genevieve P.

Hi @Genome Team

You can use the Smartsheet API to Get the Sheet Publish Status of any sheet that your account has access to, see: https://smartsheet.redoc.ly/tag/sheets#operation/get-sheetPublish

See also the SheetPublish Object information, here.

Cheers!

Genevieve

Genome Team

Thanks Genevieve, we are currently using the Get Sheet Publish Status API but this requires calling this API for each sheet. It would be nice if there is an API we can call to get all of the published items/links.