API和开发者

","excerpt":"//www.santa-greenland.com/community/categories/api-developers/\">","categoryID":320,"dateInserted":"2019-04-21T13:32:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-21T16:02:57+00:00","insertUserID":86166,"insertUser":{"userID":0,"name":"unknown","url":"https:\/\/community.smartsheet.com\/profile\/","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-19T01:49:02+00:00","banned":0,"punished":0,"private":false},"updateUserID":null,"lastUserID":86166,"lastUser":{"userID":0,"name":"unknown","url":"https:\/\/community.smartsheet.com\/profile\/","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-19T01:49:02+00:00","banned":0,"punished":0,"private":false},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":57,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/46321\/x","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46321\/x","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":[],"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":46221,"type":"discussion","name":"Sync to Googlesheets via API?","excerpt":"Hey, has anyone successfully created a sync from Smartsheets into GoogleSheets to sync data from Smartsheets into Google Sheets? I am looking for some samples or for someone to say they have done it and point me in the right direction for making that happen. Thanks, ","categoryID":320,"dateInserted":"2019-04-18T15:25:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-19T12:51:02+00:00","insertUserID":11072,"insertUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-03-17T18:49:31+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-18T16:08:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":555,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/46221\/sync-to-googlesheets-via-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46221\/sync-to-googlesheets-via-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"}],"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":46271,"type":"discussion","name":"SSIS package to read Smartsheet data to export the data into SQL database","excerpt":"I need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the steps.","categoryID":320,"dateInserted":"2019-04-19T11:22:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-19T12:47:06+00:00","insertUserID":86116,"insertUser":{"userID":86116,"name":"dsp9","url":"https:\/\/community.smartsheet.com\/profile\/dsp9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-19T11:17:09+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-18T16:08:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1155,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/46271\/ssis-package-to-read-smartsheet-data-to-export-the-data-into-sql-database","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46271\/ssis-package-to-read-smartsheet-data-to-export-the-data-into-sql-database","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":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":46136,"type":"discussion","name":"Getting last login information via API call","excerpt":"I am hitting the users endpoint(https:\/\/api.smartsheet.com\/2.0\/users) to get all of our user information. I am trying to find out inactive users based on last login date. The API call doesn't return me the last login information for any user. I can see this information when I export the csv of the users from the admin…","categoryID":320,"dateInserted":"2019-04-17T17:25:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-18T14:01:18+00:00","insertUserID":85901,"insertUser":{"userID":85901,"name":"srinisubra","url":"https:\/\/community.smartsheet.com\/profile\/srinisubra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-17T17:19:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":603,"lastUser":{"userID":603,"name":"dAVE Inden","url":"https:\/\/community.smartsheet.com\/profile\/dAVE%20Inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/2f\/a6\/n2fa68b66b9aff39a6e105069eb3e7cfc.jpg","dateLastActive":"2019-07-15T14:06:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":250,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/46136\/getting-last-login-information-via-api-call","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46136\/getting-last-login-information-via-api-call","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":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":45961,"type":"discussion","name":"Column Type difference between API and GUI","excerpt":"Hi All, I have a somewhat confusing issue within a sheet where the API is reporting a different column type to the interactive gui. Attempting to force the column shown by the API from TEXT_NUMBER to MULTI_CONTACT as per the GUI through the API results in a success returned, however the subsequent re-query returns…","categoryID":320,"dateInserted":"2019-04-16T10:31:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-17T04:30:27+00:00","insertUserID":85556,"insertUser":{"userID":85556,"name":"NotSoSmartSheet","url":"https:\/\/community.smartsheet.com\/profile\/NotSoSmartSheet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-16T09:31:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":85556,"lastUser":{"userID":85556,"name":"NotSoSmartSheet","url":"https:\/\/community.smartsheet.com\/profile\/NotSoSmartSheet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-16T09:31:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":130,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/45961\/column-type-difference-between-api-and-gui","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45961\/column-type-difference-between-api-and-gui","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-04\/41\/eb\/41eb51ec86bcfb909c4287e225d5ede4.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-04\/41\/eb\/41eb51ec86bcfb909c4287e225d5ede4.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-04\/41\/eb\/41eb51ec86bcfb909c4287e225d5ede4.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-04\/41\/eb\/41eb51ec86bcfb909c4287e225d5ede4.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-04\/41\/eb\/41eb51ec86bcfb909c4287e225d5ede4.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-04\/41\/eb\/41eb51ec86bcfb909c4287e225d5ede4.PNG"},"alt":"Column_Type_API.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"}],"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}">