How do I get a report id from the permalink?

jdpy19
jdpy19 ✭✭
edited 11/16/23 in API & Developers

I have not been able to find a path forward in the api documentation, but ultimately I need the report ID after a user pastes their report permalink. How do I get a report ID from a report permalink?

Answers

  • Hi @jdpy19

    There currently isn't a way to use the URL of a Report or Sheet in Smartsheet to get the ID. You'll need to ask for the ID directly (found in the Properties tab).

    Another alternative would be to have the reports created in the same workspace or folder. Then you can get that item to find the IDs within it.

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • jdpy19
    jdpy19 ✭✭

    Hi @Genevieve P. ,

    I am able to use the permalink id (example below) in the permalink to fetch a sheet using this endpoint "https://api.smartsheet.com/2.0/sheets/{sheetId}" where sheetId is the permalink id instead of the sheet id found in the properties tab. It seem like an odd api design decision to allow sheet ids to be interchangeble but not supporting it for other objects (reports). Does the engineering team have the same support for reports on the roadmap?

    Thank you,

    Jake

  • Hey @jdpy19

    I was unaware that the Get Sheet endpoint was able to use the permalink instead of the sheet ID, I must have been going off of outdated information. Thank you for clarifying! All other requests (Report, Dashboard, Folder, etc) require a direct ID.

    To pass your feedback to the Product team, please feel free to create an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. Ideas are reviewed on a monthly basis and the top-voted posts each month will receive a public status update.

    Thanks,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions