API & Developers

The Remover User method has been deprecated and does not work.<\/p>

Deactivate User, while it removes the user's ability to access Smartsheet in any way, it still leaves all their Shares intact - so they still show up on sheets as having access, and on the downloaded Sheet Access reports. And Business Plan SysAdmins can't even access this method anyway. <\/p>

At this time, there is no reasonable way to remove a user's shares through the API without going through every sheet, report, workspace, dashboard...<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}]},{"discussionID":102525,"type":"question","name":"Export Smartsheet as CSV using API - \"media type not supported\"","excerpt":"I'm able to export a smartsheet document as JSON with the API, however, our endpoint doesn't support nested data. So I'd like to get it either as flattened JSON or CSV. Sample #4 here shows the CSV option: \/\/ Sample 4: Get sheet as CSV curl https:\/\/api.smartsheet.com\/2.0\/sheets\/{sheetId} \\ -H \"Authorization: Bearer…","categoryID":320,"dateInserted":"2023-03-13T17:39:33+00:00","dateUpdated":null,"dateLastComment":"2023-03-14T15:55:39+00:00","insertUserID":159333,"insertUser":{"userID":159333,"name":"mindmischief","title":"","url":"https:\/\/community.smartsheet.com\/profile\/mindmischief","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-17T23:02:25+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"updateUserID":null,"lastUserID":159333,"lastUser":{"userID":159333,"name":"mindmischief","title":"","url":"https:\/\/community.smartsheet.com\/profile\/mindmischief","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-17T23:02:25+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":32,"score":null,"hot":3357540912,"url":"https:\/\/community.smartsheet.com\/discussion\/102525\/export-smartsheet-as-csv-using-api-media-type-not-supported","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102525\/export-smartsheet-as-csv-using-api-media-type-not-supported","format":"Rich","tagIDs":[227],"lastPost":{"discussionID":102525,"commentID":367189,"name":"Re: Export Smartsheet as CSV using API - \"media type not supported\"","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/367189#Comment_367189","dateInserted":"2023-03-14T15:55:39+00:00","insertUserID":159333,"insertUser":{"userID":159333,"name":"mindmischief","title":"","url":"https:\/\/community.smartsheet.com\/profile\/mindmischief","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-17T23:02:25+00:00","banned":0,"punished":0,"private":true,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-14T15:55:55+00:00","dateAnswered":"2023-03-14T14:22:50+00:00","acceptedAnswers":[{"commentID":367149,"body":"

I'm able to export a sheet to CSV using a PowerShell script and the sample code provided for the API. One thing I did notice, was that I also received the \"Invalid Accept header. Media type not supported.\" message when I didn't have the correct Sheet ID being used. So even though the message points to your Accept header, that may not be where the problem is.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}]},{"discussionID":101740,"type":"question","name":"How to create webhook for sheet as third party?","excerpt":"Hi Smartsheet Community, Our startup has fairly simple use case to update our backend systems when a third party Smartsheet document is updated that we have view access to. Based on our research, I understand that as a third party, the only way to receive webhook notification updates is by using a Smartsheet WorkApp which…","categoryID":320,"dateInserted":"2023-02-24T19:55:51+00:00","dateUpdated":null,"dateLastComment":"2023-02-27T13:32:14+00:00","insertUserID":158729,"insertUser":{"userID":158729,"name":"nick_luckylabs","url":"https:\/\/community.smartsheet.com\/profile\/nick_luckylabs","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbx1OrRM0y_lCA_5Tzty2EhQ1ojoImMXgZXcS3n=s96-c","dateLastActive":"2023-02-27T18:18:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-03-15T14:03:01+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":34,"score":null,"hot":3354773885,"url":"https:\/\/community.smartsheet.com\/discussion\/101740\/how-to-create-webhook-for-sheet-as-third-party","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101740\/how-to-create-webhook-for-sheet-as-third-party","format":"Rich","tagIDs":[219,227,371,448],"lastPost":{"discussionID":101740,"commentID":364497,"name":"Re: How to create webhook for sheet as third party?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/364497#Comment_364497","dateInserted":"2023-02-27T13:32:14+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-03-15T14:03:01+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-27T18:03:01+00:00","dateAnswered":"2023-02-27T13:32:14+00:00","acceptedAnswers":[{"commentID":364497,"body":"