Using the API to get attachment URLs
I have PDF row attachments in a sheet. I need to get a direct URL to the attachment but I can't see a way to do this in the API.
Using the GUI to "send" the file provides a link - so I'm trying to get something similar through the API. I'm aware that the the URL using the GUI method expires after 30 days. I would prefer them to be permanent, but if that isn't possible, a 30 day link will suffice.
Best Answer
-
You make a call to
https://api.smartsheet.com/2.0/sheets/$Sheet_ID?include=attachments
substituting $Sheet_ID for the sheet ID and get the attachment id for each row
Then call
https://api.smartsheet.com/2.0/sheets/$Sheet_ID/attachments/$This_Attachment_ID
which will return the direct link for the attachment.
/marc
Answers
-
You make a call to
https://api.smartsheet.com/2.0/sheets/$Sheet_ID?include=attachments
substituting $Sheet_ID for the sheet ID and get the attachment id for each row
Then call
https://api.smartsheet.com/2.0/sheets/$Sheet_ID/attachments/$This_Attachment_ID
which will return the direct link for the attachment.
/marc
-
Thanks this kind of worked, however the url expires within a minute so it isn't useful.
I tried adding an expiration of 7776000000 ms (90 days) and it seemed like it lasted slightly longer, but was expired within a few minutes.
-
@jzadra Hi, how did change an expiration?
I got the url but it doesnot work.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in API & Developers
- We have setup a Power Automate RPA on a dedicated PC to run a series of repetitive steps which are triggered by a new row of data entering one of our smartsheets. The RPA has its own login credentials…
- I'd like to be able to collaborate or even open to purchasing of SDK for PHP. Although PHP is not directly supported, one of us has to take an initiative, and wondering if anybody has a starting point…
- I've been trying to figure out how to configure Kofax's Call REST Web Service step so I can use an API to attach local PDFs to specific rows of a Smartsheet. I keep hitting dead ends or examples for e…