This is a client SDK for connecting to the Smartsheet API from Node.js applications.
The SDK is compatible with actively supported Node.js versions 14.x or later.
To install this SDK run the following command in a terminal window:
npm install smartsheet
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.
- 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.
For details about more advanced features, see Advanced Topics.
Review the Developer Program Agreement.
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