Any way to create a URL from an external report to a Smartsheet with parameters?

cbsarge

Hello. I was hoping I could create a link to a Smartsheet and pass it filtering parameters based on content in the external reporting platform. Something like:

https://app.smartsheet.com/sheets/123456789098765432?view=grid&someID=somevalue

where this link would go to sheet 123456789098765432 and filter the results on someID equaling the value I feed it from the external report.

Brian_Richardson

If you can capture and save the row ID for a given row then you can use the URL:

https://app.smartsheet.com/sheets/1234567?view=grid&rowId=1231241244

You can get the Row ID by right clicking a row and choosing properties, or you can use the API and a tool like Bridge to get row Ids based on search criteria.

However, you cannot do &MyUniqueNumber=1234234 or &Description=My+Idea or something like that. The permalinks for Smartsheet won't "search" the sheet for you.

cbsarge

Actually, the Smartsheet Data Connector (or whatever they're calling it lately) DOES pull the row ID. It shows as ID_ROWID_ in the resulting field list of the dataset in SQL Server Report Server. I was able to use that combined with the link to the sheet to go right to that row. Thanks for setting me on the right path!

The link from my SSRS report assigned to the Action for the cell is:

I had to post this as a picture because the hosting Vanilla forum didn't seem to like me using a link.

Brian_Richardson

If you can capture and save the row ID for a given row then you can use the URL:

https://app.smartsheet.com/sheets/1234567?view=grid&rowId=1231241244

You can get the Row ID by right clicking a row and choosing properties, or you can use the API and a tool like Bridge to get row Ids based on search criteria.

However, you cannot do &MyUniqueNumber=1234234 or &Description=My+Idea or something like that. The permalinks for Smartsheet won't "search" the sheet for you.

cbsarge

Do you know if there's any way to use the Smartsheet Connector ODBC driver to get the rowID?

Brian_Richardson

I'm sorry, I'm not familiar with the ODBC connector, but I would tend to doubt that rowID is exposed there. There's no function/formula available to expose rowID. You have to either manually get it from Properties or leverage the API to get/search the sheet and get the row IDs.

I did try some experimentation with adding &rowNumber=xx to the URL. rowNumber is the attribute in the API response. That doesn't work though.

There's at least one product enhancement request here for a function to expose the row ID that you can vote up and comment for your specific case.

https://community.smartsheet.com/discussion/130111/use-the-internal-row-id

cbsarge

Actually, the Smartsheet Data Connector (or whatever they're calling it lately) DOES pull the row ID. It shows as ID_ROWID_ in the resulting field list of the dataset in SQL Server Report Server. I was able to use that combined with the link to the sheet to go right to that row. Thanks for setting me on the right path!

The link from my SSRS report assigned to the Action for the cell is:

I had to post this as a picture because the hosting Vanilla forum didn't seem to like me using a link.

Brian_Richardson

Oh cool!