需要附件API的帮助
我如何从第三方系统使用API不使用附件id拉附件添加到smartsheet行
答案
-
艾蒂安Mermillod ✭✭✭✭
你好,
下载任何附件都需要附件Id。还有一种方法可以为给定的工作表/行列出附件。使用该方法,您将能够检索附件id。
-
DivyaP ✭
谢谢您的回复
是否有可能通过API只获得最近修改的行表..我的意思是,是否有任何列被更新或添加注释或添加附件到行?
-
艾蒂安Mermillod ✭✭✭✭
不,没有任何直接方法来列出最近修改的行。
- 你可以创建一个网络钩子来拦截最近的即时更改。
- 或者你可以只阅读表格:每一行都有一个Modified属性
类别
The general length is usually 26 characters, <\/strong>however I would not suggest limiting your solution to expect that count in case it fluctuates in the future. <\/p> You may want to build your database to allow for some extra characters in there just in case, or have some exception handling that would notify you if a shared secret is ever generated that is longer than what you're expecting.<\/p> Cheers,<\/p> Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-01 15:35:09","updateUser":{"userID":148352,"name":"sgolux","url":"https:\/\/community.smartsheet.com\/profile\/sgolux","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T23:14:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":97976,"type":"question","name":"When a sheet is deleted, are any webhooks associated with that sheet deleted or disabled?","excerpt":"Hello. Imagine you have created a sheet, and used the webhook API to designate a webhook about that sheet, and enabled that webhook. QUESTIONS: If you delete the sheet, are you guaranteed a webhook event for a deleted sheet? And if so, how would you know the event was about the sheet deletion? Is the webhook associated…","categoryID":320,"dateInserted":"2022-11-20T23:52:02+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T11:38:35+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":"2022-12-05T23:14:12+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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-05T20:32:02+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":63,"score":null,"hot":3338366437,"url":"https:\/\/community.smartsheet.com\/discussion\/97976\/when-a-sheet-is-deleted-are-any-webhooks-associated-with-that-sheet-deleted-or-disabled","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97976\/when-a-sheet-is-deleted-are-any-webhooks-associated-with-that-sheet-deleted-or-disabled","format":"Rich","lastPost":{"discussionID":97976,"commentID":352269,"name":"Re: When a sheet is deleted, are any webhooks associated with that sheet deleted or disabled?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352269#Comment_352269","dateInserted":"2022-11-25T11:38:35+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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-05T20:32:02+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":"2022-11-24T19:29:58+00:00","dateAnswered":"2022-11-24T11:23:41+00:00","acceptedAnswers":[{"commentID":352209,"body":" Hi @sgolux<\/a><\/p> When a sheet is deleted, the webhook will become disabled<\/em> with a status of A status change callback will occur to indicate that the webhook status has changed with a The webhook is automatically re-enabled if access to the sheet is restored (so yes, if the deleted sheet is restored).<\/p> You can find this information under Webhook Status<\/strong> in the API Documentation, under the \"Disabled_Scope_Inaccessible\" status, here: https:\/\/smartsheet.redoc.ly\/tag\/webhooksDescription#section\/Webhook-Status<\/a><\/p> As a note, I believe that this is the same behaviour if you lose sharing access to the sheet as well, since you will no longer have access to that data.<\/p> If it is important to know the difference between sheet being deleted and loss of sharing access, I would suggest looking at that via event reporting,<\/strong> if your plan has access to it. <\/strong>Here's more information:<\/p>DISABLED_SCOPE_INACCESSIBLE<\/code><\/strong>. <\/p>
scopeObjectId<\/code> containing the ID of the deleted sheet.<\/p>
<\/p>