Attach file to row using PHP
The smartsheet api docs provide this documentation to attach a file to a row.
curl https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/attachments
\ -H "Authorization: Bearer ll352u9jujauoqz4gstvsae05" \ -H "Content-Type: application/msword" \ -H 'Content-Disposition: attachment; filename="ProgressReport.docx"' \ -H "Content-Length: FILE_SIZE" \ -X POST \ --data-binary @ProgressReport.docx
How do I translate this into the appropriate calls to a curl session in php?
I assume that I need to create a header block such as
$headersAttachment = array( "Authorization: Bearer " . $AccessToken, "Content-Type: application/pdf", 'Content-Disposition: attachment; filename="mydoc.pdf"', // **is this for just the filename or the full path?** "Content-Length: " . $FileSizeOfMyDoc );
and use it like so
$curlSession = curl_init($rowsURL . '/' . $rowId . '/attachments'); curl_setopt($curlSession, CURLOPT_RETURNTRANSFER, TRUE); curl_setopt($curlSession, CURLOPT_HTTPHEADER, $headersAttachment); curl_setopt($curlSession, CURLOPT_POSTFIELDS, $body); curl_setopt($curlSession, CURLOPT_POST, TRUE); $getSheetResponseData = curl_exec($curlSession);
What do I need to put in $body so that the data from the file is uploaded?
The smartsheet api docs say
The following example request shows a simple upload that adds a file attachment to a sheet:
POST https://api.smartsheet.com/2.0/sheets/4509093797881732/attachments Authorization: Bearer ll352u9jujauoqz4gstvsae05 Content-Disposition: attachment; filename="ProgressReport.docx" Content-Type: application/msword Content-Length: 5463
< Binary content for file >
As shown in this example, the contents of the file is included in the body of the POST request. In most programming languages, this is done by reading the file from an input stream and writing it out to the output stream of the HTTP request.
this is done by reading the file from an input stream and writing it out to the output stream of the HTTP request. <--- How Do I Do This In PHP?
As an after thought, how can I check this with Postman?
Thanks in advance. Any help would be awesome.
Answers
-
Hi Roger,
We don't currently support PHP, so I don't have any advice for you in that area. Essentially, you will be passing REST + JSON over the wire. You will need to sort out the following headers for your PHP calls:
POST /2.0/sheets/{sheetId}/rows/{rowId}/attachments
Host: api.smartsheet.com
Content-Type: image/jpeg; charset=binary
Accept-Encoding: gzip, deflate, br
Content-Disposition: attachment; filename="Image.jpeg"
Content-Length: 1048945
Authorization: Bearer TOKENHERE
The file size is in bytes. I believe you can put the path in your filename param if you need to. I was talking with a colleague and it sounds like you have already sorted this out with them, so that's great! Let us know if you have any other questions.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Roger Jarrett Did you figure out if this is possible? how?
Cheers
-
This is how I did it
$baseURL = "https://api.smartsheet.com/2.0";
$sheetsURL = $baseURL . "/sheets/";
$AccessToken = '<<Your Access Token>>' ;
$SheetId = '<<Your Sheet Id>>' ;
$sheetURL = $baseURL . "/sheets/" . $SheetId;
$rowsURL = $sheetURL . "/rows";
$rowId = '<<Your Row Id>>' ;
$AttachmentPath = 'File name/path of File to Upload.pdf' ;
$AttachmentLength = filesize($AttachmentPath) ;
$PDFContent = file_get_contents($AttachmentPath) ;
$PDFUrl = $rowsURL . '/' . $rowId . '/attachments' ;
$headersAttachment = array(
"Authorization: Bearer " . $AccessToken,
"Content-Type: application/pdf",
'Content-Disposition: attachment; filename="' . pathinfo($AttachmentPath, PATHINFO_FILENAME) . '.pdf"',
"Content-Length: " . $AttachmentLength
);
$curlSession = curl_init();
curl_setopt_array($curlSession, array(
CURLOPT_URL => $PDFUrl,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => $PDFContent,
CURLOPT_HTTPHEADER => $headersAttachment,
CURLOPT_SSL_VERIFYHOST => false,
CURLOPT_SSL_VERIFYPEER => false,
)
);
$SheetResponseData = curl_exec($curlSession);
if ($SheetResponseData === FALSE)
{
if (curl_errno($curlSession))
{
$ErrMsg .= 'Curl error: ' . curl_error($curlSession) . '<br>' ;
}
}
else
{
$sheetObj = json_decode($SheetResponseData, true);
if (strstr($SheetResponseData, 'errorCode') !== FALSE)
{
$ErrMsg .= 'Data error: [' . $sheetObj['errorCode'] . '] ' . $sheetObj['message'] . '<br>' ;
}
else
{
// now extract the rowId of the newly created row
// $rowId = sprintf("%.0f", $sheetObj['result']['id']) ;
$Success = TRUE ;
}
}
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
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives