smartsheet
Smartsheet SDK for JavaScript
This is a client SDK for connecting to the Smartsheet API from Node.js applications.
System Requirements
The SDK is compatible with actively supported Node.js versions 14.x or later.
Installation
To install this SDK run the following command in a terminal window:
npm install smartsheetExample Usage
To call the API you must have an access token. You can generate an access token in Smartsheet UI under Account > Personal Settings > API Access.
The following is a brief sample using promises that shows you how to:
- Initialize the client
- List all sheets
- Load one sheet
// Initialize the client
var client = require('smartsheet');
var smartsheet = client.createClient({
accessToken: '<access_token>', // Replace <access_token> with your API token
logLevel: 'info'
});
// The `smartsheet` variable now contains access to all of the APIs
// Set queryParameters for `include` and pagination
var options = {
queryParameters: {
include: "attachments",
includeAll: true
}
};
// List all sheets
smartsheet.sheets.listSheets(options)
.then(function (result) {
var sheetId = result.data[0].id; // Choose the first sheet
// Load one sheet
smartsheet.sheets.getSheet({id: sheetId})
.then(function(sheetInfo) {
console.log(sheetInfo);
})
.catch(function(error) {
console.log(error);
});
})
.catch(function(error) {
console.log(error);
});See the node-read-write-sheet project for a code example that shows how to call methods to read and write to a sheet using this SDK.
Documentation
- The Smartsheet API documentation with corresponding SDK example code can be found here.
- For an example of using the Javascript SDK see the sample project here.
Advanced Topics
For details about more advanced features, see Advanced Topics.
Developer Agreement
Review the Developer Program Agreement.
Acknowledgements
We would like to thank the following people for their contributions to this project:
- Cameron Bowie - cameronbowie
- Nathan Armstrong - armstnp
- Emily Koh - emilykoh
- Steve Weil - seweil
- Kim Brandl - kbrandl