日历通知/提醒

heyjay ✭✭✭✭

11/18/21 在API和开发者

您好，我们将此通知用于里程碑的自动问候。除了自定义消息，我们希望在我们的帖子上包含一个图像。然而，当我们试图包含图像的列，它不通过。该消息显示了图像的文件名(见下图)。添加“附件”也不适合我们。请建议。

…

标签:

日程表视图

0 ·

答案

吉纳维芙P。员工管理

11/19/21

嗨@heyjay

根据您的屏幕截图，看起来您正在Teams中接收此警报，对吗?如果是这样，目前还没有办法从Teams中的Smartsheet bot中将图像作为警报的一部分显示出来，无论是作为单元格图像还是附件。请向我们的产品团队提供您的增强请求ob欧宝娱乐app手机下载填一下这张表格，在这里!

欢呼,

吉纳维芙

0 · 在Facebook上分享在Twitter上分享

类别

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

I have also identified such a problem when importing a grouped Excel sheet into Smartsheet using the API and specifying a Header Row.<\/p>

Here is the Python function code to fix this problem<\/p>

First, import with header_row_index=None.<\/li>

Next, update the Columns of the sheet with the values of the header_row cells.<\/li>

Finally, delete the unnecessary rows.<\/li><\/ul>
\n \n https:\/\/gist.github.com\/jmyzk\/fc19c95a8da132aa624a33c0a50bfd86\n <\/a>\n<\/div>

<\/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":106078,"type":"question","name":"Python SDK API to add rows with Multi Columns to Smartsheet","excerpt":"I have a script that reads columns from my source Smartsheet (SS) and gets the values from the columns in the SS and stores them in variables. This code works. Where I am getting stuck is assigning the variables (2 or more columns) to a new row and then adding the row to the destination SS. For example: Source SS, reads…","categoryID":320,"dateInserted":"2023-06-06T17:04:21+00:00","dateUpdated":"2023-06-06T19:16:22+00:00","dateLastComment":"2023-06-07T16:05:05+00:00","insertUserID":148855,"insertUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2023-06-07T21:50:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":148855,"lastUserID":148855,"lastUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2023-06-07T21:50:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":104,"score":null,"hot":3372226766,"url":"https:\/\/community.smartsheet.com\/discussion\/106078\/python-sdk-api-to-add-rows-with-multi-columns-to-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106078\/python-sdk-api-to-add-rows-with-multi-columns-to-smartsheet","format":"Rich","tagIDs":[227],"lastPost":{"discussionID":106078,"commentID":379322,"name":"Re: Python SDK API to add rows with Multi Columns to Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379322#Comment_379322","dateInserted":"2023-06-07T16:05:05+00:00","insertUserID":148855,"insertUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2023-06-07T21:50:58+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-06-07T16:26:26+00:00","dateAnswered":"2023-06-07T12:52:19+00:00","acceptedAnswers":[{"commentID":379249,"body":"
Hi @cabbsman<\/a> <\/p>
I see you've received a response in the StackOverflow Community on this thread:<\/p>
\n \n https:\/\/stackoverflow.com\/questions\/76417418\/python-sdk-api-to-add-rows-with-multiple-columns-to-update-to-smartsheet\n <\/a>\n<\/div>
I would suggest following-up on that thread as it looks like there are some good tips\/tricks!<\/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":227,"urlcode":"api-and-developers","name":"API and Developers"}]},{"discussionID":105822,"type":"question","name":"Smartsheet IP Addresses for Network Restrictions","excerpt":"Hi! I am using Smartsheet webhooks to stream events of updates on items Along with hmac authorization, I also want to restrict network access so that requests coming from Smartsheet server will be catered, and all other go unauthorized can I get the set of IPs of Smartsheet?","categoryID":320,"dateInserted":"2023-05-31T04:25:53+00:00","dateUpdated":null,"dateLastComment":"2023-06-01T12:28:16+00:00","insertUserID":161903,"insertUser":{"userID":161903,"name":"Shravan A","url":"https:\/\/community.smartsheet.com\/profile\/Shravan%20A","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T18:35:00+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-19T18:13:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":87,"score":null,"hot":3371130249,"url":"https:\/\/community.smartsheet.com\/discussion\/105822\/smartsheet-ip-addresses-for-network-restrictions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105822\/smartsheet-ip-addresses-for-network-restrictions","format":"Rich","lastPost":{"discussionID":105822,"commentID":378281,"name":"Re: Smartsheet IP Addresses for Network Restrictions","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378281#Comment_378281","dateInserted":"2023-06-01T12:28:16+00:00","insertUserID":91566,"insertUser":{"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-19T18:13:12+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-06-06T18:36:38+00:00","dateAnswered":"2023-06-01T12:28:16+00:00","acceptedAnswers":[{"commentID":378281,"body":"
Hi @Shravan A<\/a> <\/p>
Smartsheet publishes a DNS A record at aws.relay.smartsheet.com which can be added to the Allowlist in your firewall. We recommend using the DNS record and not<\/strong> IP addresses because our IP addresses may change in the future. <\/p>
Here's the link to Authenticating Webhooks<\/a> in the API documentation. <\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=320&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":199,"limit":3},"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">