README
Smartsheet Get Filtered Sheet
Get the data of a sheet and return only the rows that match a given criteria.
Example: Return every row in a sheet where the Status column is set to Complete.
Smartsheet Javascript SDK and is meant to be used alongside it.
NOTE: This module requires theA GET Sheet request will return all of the current data of the sheet by default. Sometimes only certain rows are needed for a process instead.
This module solves this by:
- Getting the current sheet data.
- Searching through the rows to find matches with the given value.
- Returning only the row objects that match the given criteria in an array.
Installation
npm install smartsheet-get-filtered-sheet
Usage
//Assumes smartsheetClient has been instantiated elsewhere already
const getFilteredSheet = require('smartsheet-get-filtered-sheet');
const options = {
sheetId: 4583173393803140,
columnId: 2331373580117892,
filterValue: 'Complete'
};
getFilteredSheet(smartsheetClient, options)
.then((results) => {
console.log(results);
})
.catch((err) => {
console.log(err)
});
Arguments
The function takes two arguments, your Smartsheet client object and an options object.
smartsheetClient
This module is used alongside the Smartsheet Javascript SDK. Pass in your current Smartsheet client object for use in the requests.
options
options.sheetId
The id of the sheet you are filtering
options.columnId
The id of the column to look for that will have the value to decide if the row is returned or not.
options.filterValue
The value to search for in the sheet. A match determines that a row should be returned.