API export to excel to include the rowpermalink
trying to include the rowpermalink in my sheet export according to the API doc the ?include=rowpermalink in the URL should do it however it does not show in the row with all the other data from the sheet. any help would be greatly apprecitated.
$URL = "https://api.smartsheet.com/2.0/sheets/****************?include=rowPermalink"
$Headers = @{
Authorization = "Bearer *************************"
Accept = "application/vnd.ms-excel"
}
$MyFile = "c:\temp\TestDB.xlsx"
Invoke-WebRequest -Uri "$URL" -Method Get -Headers $Headers -OutFile $MyFile
Best Answer
-
Hi @palefty
The Smartsheet API does not possess a native method to directly fetch or incorporate clickable row permalinks when you export a sheet to an Excel file. So, users need more intuitive, clickable links within their exported Excel sheets.
To address this, I have implemented a workaround:
(I used Smartsheet SDK to implement the workaround)
Fetching Permalinks: The code interacts with the Smartsheet API to retrieve each row's permalink values.
Incorporating into the sheet: These permalink values are then populated into a designated column. When you export the sheet as an Excel file, you'll notice a column filled with URLs corresponding to the permalinks for each row in Smartsheet.
Making the Links Clickable: As a final step, to enhance user experience and ease of access, the code processes the Excel file to convert these plain URL texts into clickable hyperlinks. Thus, when users click these links in the Excel sheet, they're directed to the appropriate Smartsheet row online.
With the implemented code, users can easily navigate to Smartsheet rows directly from their Excel sheets.
Answers
-
Hi @palefty
The Smartsheet API does not possess a native method to directly fetch or incorporate clickable row permalinks when you export a sheet to an Excel file. So, users need more intuitive, clickable links within their exported Excel sheets.
To address this, I have implemented a workaround:
(I used Smartsheet SDK to implement the workaround)
Fetching Permalinks: The code interacts with the Smartsheet API to retrieve each row's permalink values.
Incorporating into the sheet: These permalink values are then populated into a designated column. When you export the sheet as an Excel file, you'll notice a column filled with URLs corresponding to the permalinks for each row in Smartsheet.
Making the Links Clickable: As a final step, to enhance user experience and ease of access, the code processes the Excel file to convert these plain URL texts into clickable hyperlinks. Thus, when users click these links in the Excel sheet, they're directed to the appropriate Smartsheet row online.
With the implemented code, users can easily navigate to Smartsheet rows directly from their Excel sheets.
-
@jmyzk_cloudsmart_jp thank you this worked Perfectly!!!!!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives