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

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.
Best Answers
-
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.
-
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.
Answers
-
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.
-
Do you know if there's any way to use the Smartsheet Connector ODBC driver to get the rowID?
-
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
-
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.
-
Oh cool!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives