API和开发人员

\". Is it possible to delete the \"unknown sheet\" references using the API and Python code?","categoryID":320,"dateInserted":"2023-04-13T23:10:20+00:00","dateUpdated":null,"dateLastComment":"2023-04-17T19:03:08+00:00","insertUserID":129958,"insertUser":{"userID":129958,"name":"Lucas Rayala","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!7HVumwhOGBb","dateLastActive":"2023-06-08T19:48:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-08T20:51:15+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":60,"score":null,"hot":3363186208,"url":"https:\/\/community.smartsheet.com\/discussion\/104018\/inbound-links","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104018\/inbound-links","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ANNOUCFRYP81\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-17T19:03:08+00:00","acceptedAnswers":[]}},"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":103963,"type":"question","name":"What is the maximum limit of batch size to insert, update, or delete the rows?","excerpt":"Hi, For https:\/\/smartsheet.redoc.ly\/tag\/rows API for \"Add Rows\", \"Update Rows\" and \"Delete Rows\", how many records can we insert, update and delete per call request? Is there any limitation in the number of rows or batch size? If so, what's the limit and what kind of error would we receive beyond the limit? I did not…","categoryID":320,"dateInserted":"2023-04-13T04:32:35+00:00","dateUpdated":null,"dateLastComment":"2023-04-17T17:23:50+00:00","insertUserID":156304,"insertUser":{"userID":156304,"name":"nishikamanira","url":"https:\/\/community.smartsheet.com\/profile\/nishikamanira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T18:13:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":156304,"lastUser":{"userID":156304,"name":"nishikamanira","url":"https:\/\/community.smartsheet.com\/profile\/nishikamanira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T18:13:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":123,"score":null,"hot":3363114985,"url":"https:\/\/community.smartsheet.com\/discussion\/103963\/what-is-the-maximum-limit-of-batch-size-to-insert-update-or-delete-the-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103963\/what-is-the-maximum-limit-of-batch-size-to-insert-update-or-delete-the-rows","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-14T11:59:11+00:00","acceptedAnswers":[]}},"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":103736,"type":"question","name":"Trying to connect Acumatica to Smartsheets","excerpt":"I keep getting an error and cannot find any explaination anywhere. There error says Unable to parse request. The following error occurred: Field \"value\" was not parsable. value must be a primitive type at [Source: java.io.PushbackInputStream@318c0afb; line: 1, column: 1012]. Could someone explain what I am doing wrong","categoryID":320,"dateInserted":"2023-04-07T01:42:02+00:00","dateUpdated":"2023-04-12T13:16:04+00:00","dateLastComment":"2023-04-13T14:10:55+00:00","insertUserID":158549,"insertUser":{"userID":158549,"name":"mcoman","url":"https:\/\/community.smartsheet.com\/profile\/mcoman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-04T14:13:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-08T20:51:15+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":3362227377,"url":"https:\/\/community.smartsheet.com\/discussion\/103736\/trying-to-connect-acumatica-to-smartsheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103736\/trying-to-connect-acumatica-to-smartsheets","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-13T14:10:55+00:00","acceptedAnswers":[]}},"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":281,"urlcode":"Support","name":"Support"},{"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":103488,"type":"question","name":"Remove licenses from users using SmartSheet API","excerpt":"Hello all. I have a list of users who I want to transition to free collaborators. I want to do this using the API. I first tried using the deactivate method but it doesn't reclaim the license. It just blocks access to Smartsheet. I also tried using the update user method. The user sees that they are unlicensed. However, in…","categoryID":320,"dateInserted":"2023-04-01T14:32:33+00:00","dateUpdated":"2023-04-03T08:51:11+00:00","dateLastComment":"2023-04-13T08:46:41+00:00","insertUserID":157718,"insertUser":{"userID":157718,"name":"AAsad","url":"https:\/\/community.smartsheet.com\/profile\/AAsad","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-04-26T10:09:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":120501,"lastUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DVF5D4UGT64P\/nS8NWAZKSMCNG.png","dateLastActive":"2023-05-24T13:16:22+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":98,"score":null,"hot":3361736954,"url":"https:\/\/community.smartsheet.com\/discussion\/103488\/remove-licenses-from-users-using-smartsheet-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103488\/remove-licenses-from-users-using-smartsheet-api","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-13T08:03:49+00:00","dateAnswered":"2023-04-13T07:34:52+00:00","acceptedAnswers":[]}},"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":103741,"type":"question","name":"Is it possible to create bulk\/multiple sheets using Create Sheet API in a single call?","excerpt":"Is it possible to create bulk\/multiple sheets using Create Sheet API in a single call? FYI: I am aware of looping the request to create multiple sheets, but how can I perform bulk creation within a single call? Please help me with knowing how to achieve this. The response schema in the API documentation allows me to think…","categoryID":320,"dateInserted":"2023-04-07T10:26:28+00:00","dateUpdated":"2023-04-11T09:05:59+00:00","dateLastComment":"2023-04-13T04:14:52+00:00","insertUserID":156304,"insertUser":{"userID":156304,"name":"nishikamanira","url":"https:\/\/community.smartsheet.com\/profile\/nishikamanira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T18:13:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":156304,"lastUser":{"userID":156304,"name":"nishikamanira","url":"https:\/\/community.smartsheet.com\/profile\/nishikamanira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T18:13:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":51,"score":null,"hot":3362223680,"url":"https:\/\/community.smartsheet.com\/discussion\/103741\/is-it-possible-to-create-bulk-multiple-sheets-using-create-sheet-api-in-a-single-call","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103741\/is-it-possible-to-create-bulk-multiple-sheets-using-create-sheet-api-in-a-single-call","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ANC0POFV49XW\/screenshot-284916-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot (4916).png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-12T15:16:51+00:00","acceptedAnswers":[]}},"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}">