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-17T05:28:40+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-20T15:23:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":74,"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":151,"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":104027,"type":"question","name":"Smartsheets and Acumatica","excerpt":"Acumatica shows a list of templates that can be used with the product. We have created several and have issues finding out new templates after publishing them. I wonder if anyone has found a way to find missing templates.","categoryID":320,"dateInserted":"2023-04-14T12:04:48+00:00","dateUpdated":null,"dateLastComment":"2023-04-17T16:17:28+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":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-20T15:23:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":64,"score":null,"hot":3363222736,"url":"https:\/\/community.smartsheet.com\/discussion\/104027\/smartsheets-and-acumatica","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104027\/smartsheets-and-acumatica","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-17T16:17:28+00:00","acceptedAnswers":[]}},"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":103907,"type":"question","name":"Does anyone have a Swagger file for the RM API?","excerpt":"Haven't been able to find a swagger file (JSON) for the RM API, wondering if anyone has either built one or got a Postman collection they can share? Many thanks Iain","categoryID":320,"dateInserted":"2023-04-12T02:49:38+00:00","dateUpdated":"2023-04-12T11:00:09+00:00","dateLastComment":"2023-04-17T01:19:54+00:00","insertUserID":122327,"insertUser":{"userID":122327,"name":"Iain Elliott","url":"https:\/\/community.smartsheet.com\/profile\/Iain%20Elliott","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2ijWf28cW6Y!wn1UNwCCPcQ!akRFmwL_HS2","dateLastActive":"2023-06-20T22:56:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":122327,"lastUser":{"userID":122327,"name":"Iain Elliott","url":"https:\/\/community.smartsheet.com\/profile\/Iain%20Elliott","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2ijWf28cW6Y!wn1UNwCCPcQ!akRFmwL_HS2","dateLastActive":"2023-06-20T22:56:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":80,"score":null,"hot":3362963372,"url":"https:\/\/community.smartsheet.com\/discussion\/103907\/does-anyone-have-a-swagger-file-for-the-rm-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103907\/does-anyone-have-a-swagger-file-for-the-rm-api","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-17T01:19:54+00:00","acceptedAnswers":[]}},"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":102011,"type":"question","name":"Add a link to an existing cell that has validation turned on -- want to override the validation","excerpt":"I have the following code that has been working properly for quite sometime. It adds links to multiple sheets and cells. It is run from an account that has ADMIN access (and I can perform the desired functions in the UI successfully). #############ORIGINAL CODE################# def set_sheet_link(ss_client,…","categoryID":320,"dateInserted":"2023-03-02T15:47:33+00:00","dateUpdated":null,"dateLastComment":"2023-04-15T06:03:33+00:00","insertUserID":136708,"insertUser":{"userID":136708,"name":"Kevin Scott","url":"https:\/\/community.smartsheet.com\/profile\/Kevin%20Scott","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4UL2mT5z3OVuBhESrc8pLZ8jU5TMW0Z-mWFmn4=s96-c","dateLastActive":"2023-05-03T16:06:52+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-20T15:23:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":189,"score":null,"hot":3359316666,"url":"https:\/\/community.smartsheet.com\/discussion\/102011\/add-a-link-to-an-existing-cell-that-has-validation-turned-on-want-to-override-the-validation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102011\/add-a-link-to-an-existing-cell-that-has-validation-turned-on-want-to-override-the-validation","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-15T05:07:04+00:00","dateAnswered":"2023-04-14T23:11:11+00:00","acceptedAnswers":[]}},"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":103755,"type":"question","name":"What happens when webhook ongoing verification times out or gets a non-200 response","excerpt":"Hello - Your docs state that after every 100 callbacks is delivered to a webhook callback URL, there will be an ongoing verification request, similar to the original verification request. If that request happens to land when the server on the callback URL is down (which would lead to a timeout) or perhaps is in some kind…","categoryID":320,"dateInserted":"2023-04-07T17:10:08+00:00","dateUpdated":"2023-04-11T09:05:43+00:00","dateLastComment":"2023-04-13T17:11:20+00:00","insertUserID":148352,"insertUser":{"userID":148352,"name":"sgolux","url":"https:\/\/community.smartsheet.com\/profile\/sgolux","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T14:19:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":148352,"lastUser":{"userID":148352,"name":"sgolux","url":"https:\/\/community.smartsheet.com\/profile\/sgolux","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T14:19:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":110,"score":null,"hot":3362296288,"url":"https:\/\/community.smartsheet.com\/discussion\/103755\/what-happens-when-webhook-ongoing-verification-times-out-or-gets-a-non-200-response","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103755\/what-happens-when-webhook-ongoing-verification-times-out-or-gets-a-non-200-response","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-13T13:55:54+00:00","dateAnswered":"2023-04-13T12:45:20+00:00","acceptedAnswers":[]}},"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">