API & Developers

was not found\"","excerpt":"Working on implementing a basic webhook based smartsheet connector to fetch usage data for users under one organization. During the Oauth2.0 flow, requested for following scopes \"READ_USERS, ADMIN_USERS, ADMIN_WEBHOOKS\". I am making the following javascript-sdk api calls : - - smartsheetClient.users.listAllUsers…","categoryID":320,"dateInserted":"2019-09-10T16:17:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-11T18:43:57+00:00","insertUserID":92871,"insertUser":{"userID":92871,"name":"amitk-productiv","url":"https:\/\/community.smartsheet.com\/profile\/amitk-productiv","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-16T19:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99141,"lastUser":{"userID":99141,"name":"dave-inden","url":"https:\/\/community.smartsheet.com\/profile\/dave-inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-13T16:05:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":308,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/57416\/webhook-error-code-1151-scope-sheet-object-id-was-not-found","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/57416\/webhook-error-code-1151-scope-sheet-object-id-was-not-found","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":56496,"type":"discussion","name":"Python Script For Refresh Sheet","excerpt":"Hello Smartsheet Community, I need to write a script in Python to refresh a sheet. In my sheet I am using the Today function to calculate the total net days from one specific date. I take that data and use it as a widget on my dashboard. Problem is, the widget doesn't update unless the I physically open the sheet. Is there…","categoryID":320,"dateInserted":"2019-08-28T13:25:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-28T17:35:46+00:00","insertUserID":96856,"insertUser":{"userID":96856,"name":"vnjeffery96856","url":"https:\/\/community.smartsheet.com\/profile\/vnjeffery96856","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/32\/3c\/n323cc445fe6b613a3132f9ad94c01563.jpg","dateLastActive":"2019-09-24T11:35:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99141,"lastUser":{"userID":99141,"name":"dave-inden","url":"https:\/\/community.smartsheet.com\/profile\/dave-inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-13T16:05:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1151,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/56496\/python-script-for-refresh-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56496\/python-script-for-refresh-sheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":56361,"type":"discussion","name":"Integration with ServiceNow, the ITSM tool","excerpt":"We use Servicenow for technical incident management. Some incidents evolve into work packages for specific tech teams. These teams use SmartSheet for task management. So migrating an incident in ServiceNow to an action item in SmartSheet would be handy. Anyone done that? ","categoryID":320,"dateInserted":"2019-08-27T13:24:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-27T15:04:39+00:00","insertUserID":28096,"insertUser":{"userID":28096,"name":"Dale Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Dale%20Murphy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/09\/85\/n09854db3c85d2fcac04eb0a42036548e.jpg","dateLastActive":"2023-07-26T14:37:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":314,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/56361\/integration-with-servicenow-the-itsm-tool","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56361\/integration-with-servicenow-the-itsm-tool","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":56081,"type":"discussion","name":"smartsheet dashboard is not auto updating","excerpt":"Hi Team, Im leveraging the API to publish data to a smartsheet. Then i have a smart dashboard set up to graph that data. But when i push new data to the sheet, the dashboard charts don’t auto-update.[It says the source is modified but it’s not ...it is the same] I need this to be automatic, so when someone goes to the…","categoryID":320,"dateInserted":"2019-08-23T15:04:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-25T13:40:38+00:00","insertUserID":101386,"insertUser":{"userID":101386,"name":"sandeep","url":"https:\/\/community.smartsheet.com\/profile\/sandeep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-23T15:02:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99141,"lastUser":{"userID":99141,"name":"dave-inden","url":"https:\/\/community.smartsheet.com\/profile\/dave-inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-13T16:05:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":945,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/56081\/smartsheet-dashboard-is-not-auto-updating","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56081\/smartsheet-dashboard-is-not-auto-updating","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":54981,"type":"discussion","name":"How to delete a column with conditional formatting rule using smartsheet C# SDK?","excerpt":"How to delete a column with conditional formatting rule using smartsheet C# SDK? We are getting error - \"The column specified is used in a conditional formatting rule, so the column cannot be deleted and its type cannot be changed.\".","categoryID":320,"dateInserted":"2019-08-13T03:52:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-20T11:11:36+00:00","insertUserID":99646,"insertUser":{"userID":99646,"name":"Buddhadev.Karmakar99646","url":"https:\/\/community.smartsheet.com\/profile\/Buddhadev.Karmakar99646","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-20T05:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45236,"lastUser":{"userID":45236,"name":"Alejandra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Alejandra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/8a\/fe\/n8afeceb592ad5845f46c7d931defba07.JPG","dateLastActive":"2020-05-15T18:56:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":126,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/54981\/how-to-delete-a-column-with-conditional-formatting-rule-using-smartsheet-c-sdk","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54981\/how-to-delete-a-column-with-conditional-formatting-rule-using-smartsheet-c-sdk","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":55096,"type":"discussion","name":"How to un-hide all columns in a smartsheet using smartsheet C# SDK?","excerpt":"How to un-hide all columns in a smartsheet using smartsheet C# SDK?","categoryID":320,"dateInserted":"2019-08-14T06:45:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-14T12:14:23+00:00","insertUserID":99646,"insertUser":{"userID":99646,"name":"Buddhadev.Karmakar99646","url":"https:\/\/community.smartsheet.com\/profile\/Buddhadev.Karmakar99646","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-20T05:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":81231,"lastUser":{"userID":81231,"name":"lmarchisio","url":"https:\/\/community.smartsheet.com\/profile\/lmarchisio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-11T19:23:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":208,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/55096\/how-to-un-hide-all-columns-in-a-smartsheet-using-smartsheet-c-sdk","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55096\/how-to-un-hide-all-columns-in-a-smartsheet-using-smartsheet-c-sdk","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">