PHP code example of infamoustrey / smartsheet
1. Go to this page and download the library: Download infamoustrey/smartsheet library . Choose the download type require .
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
infamoustrey / smartsheet example snippets
$smartsheetClient = new \Smartsheet\SmartsheetClient([ 'token' => 'yourapitoken' ]);
$smartsheetClient->getSheet('sheetid');
$smartsheetClient = new \Smartsheet\SmartsheetClient([
'token' => 'yourapitoken',
]);
$smartsheetClient->listSheets(); // Collection<Sheet>
$smartsheetClient->getSheet('4583173393803140'); // Sheet
$smartsheetClient->getRow('4583173393803140', '7813666446436228'); // Row
$smartsheetClient->getFolder('7116448184199044'); // Folder
$smartsheetClient->getWorkspace('7116448184199044'); // Workspace
$smartsheetClient->listWorkspaces(); // Collection<Workspace>
$smartsheetClient->listContacts(); // Collection<Contact>
$smartsheetClient = new \Smartsheet\SmartsheetClient([ 'token' => 'yourapitoken' ]);
$smartsheetClient->listSheets(); // Collection<Sheet>
$smartsheetClient = new \Smartsheet\SmartsheetClient([ 'token' => 'yourapitoken' ]);
$sheet = $smartsheetClient->getSheet('4583173393803140');
// Access some fields
$sheet->getId(); // '4583173393803140'
$sheet->getName(); // 'sheet 1'
// Add some rows
$sheet->addRow([
'ID' => "39424808324",
'Transaction Desc' => "Toys",
'Amount' => 754.23,
]);
$sheet = $smartsheetClient->getSheet('4583173393803140');
$sheet->getColumns(); // array
$sheet->getRows(); // Collection<Row>
$sheet->getColumnId('Primary'); // string
$sheet->addRows([
['Primary' => 'row 1', 'Status' => 'Open'],
['Primary' => 'row 2', 'Status' => 'Closed'],
]);
$sheet->updateRow('7813666446436228', [
'Status' => 'Done',
]);
$sheet->updateRows([
'7813666446436228' => ['Status' => 'Done'],
'1122334455667788' => ['Status' => 'Queued'],
]);
$sheet->deleteRow('7813666446436228');
$sheet->deleteRows(['7813666446436228', '1122334455667788']);
$sheet->rename('Renamed Sheet');
$sheet->copyTo('Copied Sheet', '7116448184199044');
$sheet->copyRowsTo(['7813666446436228'], '9988776655443322');
$sheet->addColumn([
'title' => 'Status',
'type' => 'TEXT_NUMBER',
]);
$sheet->addColumns([
['title' => 'Status', 'type' => 'TEXT_NUMBER'],
['title' => 'Owner', 'type' => 'TEXT_NUMBER'],
]);
$sheet->shareSheet([
[
'email' => '[email protected] ',
'accessLevel' => 'EDITOR',
],
]);
$sheet->getShares();
$sheet->createRow(['Primary' => 'new row']);
$sheet->replaceFirstRow(['Primary' => 'updated first row']);
$sheet->replaceRows($rows, 'Primary');
$sheet->sync($rows, 'Primary');
$sheet->dropAllRows();
$sheet->dropAndReplace($rows);
$sheet->dropAllColumnsExcept(['Primary', 'Status']);
$sheet->addSummaryField('Total', '=COUNT([Primary]:[Primary])');
$sheet->getSummaryFields();
$sheet->getSummaryFieldByName('Total');
$sheet->updateSummaryField([
'id' => 123,
'title' => 'Total',
'formula' => '=COUNT([Primary]:[Primary])',
]);
$sheet->updateSummaryFieldByName('Total', [
'title' => 'Total',
'formula' => '=COUNT([Primary]:[Primary])',
]);
$sheet->deleteSummaryField('123');
$sheet->deleteSummaryFields(['123', '456']);
$sheet->deleteAllSummaryFields();
$row = $smartsheetClient->getRow('4583173393803140', '7813666446436228');
$row->getId();
$row->getSheet(); // Sheet
$row->getCells(); // Collection<Cell>
$row->getCell('Primary'); // Cell|null
$row->addAttachmentLink([
'attachmentType' => 'LINK',
'name' => 'Project Docs',
'description' => 'External project documentation',
'url' => 'https://example.com/docs',
]);
$row->addAttachment('/path/to/file.pdf');
$row->delete();
$smartsheetClient = new \Smartsheet\SmartsheetClient([ 'token' => 'yourapitoken' ]);
$workspace = $smartsheetClient->getWorkspace('7116448184199044'); // \Smartsheet\Resources\Workspace
$workspace->getId(); // '7116448184199044'
$workspace->getName(); // 'New workspace'
$workspace->getSheets(); // array
// Fetch a sheet by name
$workspace->getSheet('sheet name'); // Sheet
// Create a sheet with some columns
$workspace->createSheet('sheet name', [
[
"title" => "Primary",
"type" => "TEXT_NUMBER",
"primary" => true
]
]);
$smartsheetClient = new \Smartsheet\SmartsheetClient([ 'token' => 'yourapitoken' ]);
$folder = $smartsheetClient->getFolder('7116448184199044'); // Folder
// Access some fields
$folder->getId(); // '7116448184199044'
$folder->get('name'); // 'Projects'
$folder->getPermaLink(); // 'https://app.smartsheet.com/...'
$folder->getSheets(); // array
$sheet = $folder->getSheet('sheet name');
$folder->createSheet('sheet name');
$folder->createSheets([
'sheet one',
'sheet two',
]);
$contacts = $smartsheetClient->listContacts(); // Collection<Contact>
$sheet = $smartsheetClient->getSheet('4583173393803140');
$sheet->getData(); // full API payload as an array
$sheet->get('permalink'); // a single field from the payload
$sheet->toJSON(); // payload encoded as JSON
bash
vendor/bin/phpstan analyse src tests --memory-limit 1G