API和开发者

与来自世界各地的其他开发人员联系,并使用Smartsheet API就想法进行协作。

讨论表

Ran my program to update the same row with same…","categoryID":320,"dateInserted":"2019-08-05T02:21:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-06T23:06:06+00:00","insertUserID":98746,"insertUser":{"userID":98746,"name":"Jagadeesh_D","url":"https:\/\/community.smartsheet.com\/profile\/Jagadeesh_D","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-05T02:14:42+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":2,"countViews":972,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/54326\/activity-log-smartsheet-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54326\/activity-log-smartsheet-api","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"}],"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":53691,"type":"discussion","name":"Smartsheet Consultants Needed","excerpt":"Hi community, Our organization just purchased Smartsheet Enterprise License - and is looking for consultants to build the solutions which require API integration. We have contacted with Smartsheet internal team and they quoted us $12,900 + extra travel expense, just for 2 days on-site \"discovery and planning workshop\",…","categoryID":320,"dateInserted":"2019-07-24T19:24:40+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-26T04:39:32+00:00","insertUserID":97466,"insertUser":{"userID":97466,"name":"G Chen","url":"https:\/\/community.smartsheet.com\/profile\/G%20Chen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hAnBYZlsJz4!pP1E6QMpocQ!7mU-m9ZIhil","dateLastActive":"2021-02-19T17:48:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":237,"lastUser":{"userID":237,"name":"Richard Rymill SBP","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Rymill%20SBP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/56\/cc\/n56cc5e719e36b8b84e97c4c58049f914.jpg","dateLastActive":"2023-02-24T10:59:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":146,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/53691\/smartsheet-consultants-needed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53691\/smartsheet-consultants-needed","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":263,"urlcode":"Government","name":"Government"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":41656,"type":"discussion","name":"Graphs 2 variables","excerpt":"Hi I wanted to know if anybody had tried to this type of graph in Samrthseet and if it's possible? Thank you for your help! ","categoryID":320,"dateInserted":"2019-02-15T08:35:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-24T07:23:25+00:00","insertUserID":10378,"insertUser":{"userID":10378,"name":"Noemi Kecskes","url":"https:\/\/community.smartsheet.com\/profile\/Noemi%20Kecskes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-03-14T08:37:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","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-03-17T12:51:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":586,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/41656\/graphs-2-variables","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41656\/graphs-2-variables","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ec\/f2\/ecf2be31e89635570c6b0f019c74b472.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ec\/f2\/ecf2be31e89635570c6b0f019c74b472.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ec\/f2\/ecf2be31e89635570c6b0f019c74b472.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ec\/f2\/ecf2be31e89635570c6b0f019c74b472.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ec\/f2\/ecf2be31e89635570c6b0f019c74b472.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ec\/f2\/ecf2be31e89635570c6b0f019c74b472.png"},"alt":"graph.png"},"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":265,"urlcode":"Reports","name":"Reports"},{"tagID":271,"urlcode":"Services","name":"Services"}],"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":53356,"type":"discussion","name":"Using an API with Smartsheet","excerpt":"I am interested in pulling information from the ISBN database into a Smartsheet using their API Does anyone know of a good resource to use to set this up in Smartsheet? Thanks","categoryID":320,"dateInserted":"2019-07-18T16:54:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-18T17:02:09+00:00","insertUserID":74206,"insertUser":{"userID":74206,"name":"Art Schneiderheinze","url":"https:\/\/community.smartsheet.com\/profile\/Art%20Schneiderheinze","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PI7JNYDF7Q80\/nTL55D89VG7YK.png","dateLastActive":"2022-03-03T01:36:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","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-03-17T12:51:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":96,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/53356\/using-an-api-with-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53356\/using-an-api-with-smartsheet","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"}],"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}">
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":32,"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":"

Hi @nick_luckylabs<\/a> <\/p>

Licensed users on either a Business<\/strong> or Enterprise<\/strong> plan have access to the Smartsheet API. Here's the link to the Developer's Portal.<\/a><\/p>

Even if you have view-only access to the sheet, you should still be able to use your Access Token to watch the sheet for changes using Webhooks. Here's the API documentation on Webhooks.<\/a><\/p>

Cheers,<\/p>

Genevieve<\/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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":101597,"type":"question","name":"What's the easiest way to grab all specific JSON data from a Smartsheet JSON?","excerpt":"I have a sheet that I have imported. I have a column that I'm trying to grab all the values from and add them to a list in Python what would be the easiest way to go about this from the development end?","categoryID":320,"dateInserted":"2023-02-23T02:02:19+00:00","dateUpdated":"2023-02-23T19:43:53+00:00","dateLastComment":"2023-02-23T17:45:18+00:00","insertUserID":158634,"insertUser":{"userID":158634,"name":"DougSmartsheetDev","url":"https:\/\/community.smartsheet.com\/profile\/DougSmartsheetDev","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-28T14:04:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":158634,"lastUser":{"userID":158634,"name":"DougSmartsheetDev","url":"https:\/\/community.smartsheet.com\/profile\/DougSmartsheetDev","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-28T14:04:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":104,"score":null,"hot":3354296857,"url":"https:\/\/community.smartsheet.com\/discussion\/101597\/whats-the-easiest-way-to-grab-all-specific-json-data-from-a-smartsheet-json","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101597\/whats-the-easiest-way-to-grab-all-specific-json-data-from-a-smartsheet-json","format":"Rich","tagIDs":[227],"lastPost":{"discussionID":101597,"commentID":364020,"name":"Re: What's the easiest way to grab all specific JSON data from a Smartsheet JSON?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/364020#Comment_364020","dateInserted":"2023-02-23T17:45:18+00:00","insertUserID":158634,"insertUser":{"userID":158634,"name":"DougSmartsheetDev","url":"https:\/\/community.smartsheet.com\/profile\/DougSmartsheetDev","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-28T14:04:06+00:00","banned":0,"punished":0,"private":false,"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-02-23T19:17:36+00:00","dateAnswered":"2023-02-23T16:39:05+00:00","acceptedAnswers":[{"commentID":363969,"body":"