登录提交新的想法和投票
开始

从公式调用api

彼得Spung
彼得Spung ✭✭
编辑02/07/23 在智能表产品反馈和想法ob欧宝娱乐app手机下载

备选标题:将请求最多的API调用(理想情况下是每个API)作为公式提供。

在社区中，经常有人会问如何用公式来做某件事。通常，回应是，“你可以在API中做到这一点”，或者“就使用API”。这是许多例子中的一个:“我如何查找一个单元格上周的值?”https://community.smartsheet.com/discussion/75191/last-weeks-value

我回答了这个问题，并做了如下解释。我意识到这是一个产品功能要求的新想法……ob欧宝娱乐app手机下载“如何使用公式中的API ?”

或者用另一种方式问……API对我们大多数人来说是一个沉重的负担。我们必须获得批准才能使用组织支持的语言编码平台，获得访问表格的API权限，然后有测试工具进行调试，然后学习一门额外的语言(我们已经学习了公式语言)，等等。我们已经在Smartsheet中获得了使用公式的授权，并且知道如何使用它们。而且，我们希望API调用的结果最终回到Smartsheet单元格中，而不是在编码语言环境的变量/内存空间中。就像这个社区的问题一样——“我想在这个或另一个工作表中查找某个单元格在这个日期(或公式)的先验值，并在公式所在的这个单元格中返回结果”. ...为什么不让每个API函数都在公式中可用呢?一旦决定，这对Smartsheet的开发团队来说确实是一项艰巨的任务。这可以分阶段完成——从请求最多的功能或使用最多的API开始(Smartsheet的API开发或产品管理团队无疑会在其网站日志中跟踪API的使用情况)。ob欧宝娱乐app手机下载如果没有，请开始。

无意冒犯——我在社区中经常看到这样的回答——“只使用API”。这样做应该变得更简单，更容易上手。

感谢您提供这个想法论坛，并倾听。彼得·斯潘|(电子邮件保护)

标签:
在Facebook上分享 在Twitter上分享
1
向上
1票

想法提交·最后一次更新

    类别

    2023-05-19T11:28:11.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106520,"type":"idea","name":"Automations: Sending Attachments individually, selectably","excerpt":"Currently, automations containing attachments can be sent listing multiple attachments to a given row. It would be very useful to filter or select individual attachments (based on a conditional factor such as if the title of the attachment contained a certain string of text, numbering convention, or even file type) to…","categoryID":349,"dateInserted":"2023-06-15T19:15:56+00:00","dateUpdated":null,"dateLastComment":"2023-06-18T13:12:31+00:00","insertUserID":138637,"insertUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-18T13:09:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":138637,"lastUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-18T13:09:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":30,"score":3,"hot":3373952007,"url":"https:\/\/community.smartsheet.com\/discussion\/106520\/automations-sending-attachments-individually-selectably","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106520\/automations-sending-attachments-individually-selectably","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106520,"commentID":381101,"name":"Re: Automations: Sending Attachments individually, selectably","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381101#Comment_381101","dateInserted":"2023-06-18T13:12:31+00:00","insertUserID":138637,"insertUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-18T13:09:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106553,"type":"idea","name":"Critical chain method","excerpt":"Good morning, Currently Smartsheet only uses the critical path method, are there any plans to include the option to use critical chain method as well? and to include the fever chart as part of the graphics? These are two ways of managing projects, and adding the critical chain will allow a project manager to choose what…","categoryID":349,"dateInserted":"2023-06-16T15:21:43+00:00","dateUpdated":"2023-06-16T15:24:04+00:00","dateLastComment":"2023-06-16T15:21:43+00:00","insertUserID":158572,"insertUser":{"userID":158572,"name":"noviceuser","url":"https:\/\/community.smartsheet.com\/profile\/noviceuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T19:34:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":158572,"lastUser":{"userID":158572,"name":"noviceuser","url":"https:\/\/community.smartsheet.com\/profile\/noviceuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T19:34:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":1,"hot":3373858247,"url":"https:\/\/community.smartsheet.com\/discussion\/106553\/critical-chain-method","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106553\/critical-chain-method","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106553,"name":"Critical chain method","url":"https:\/\/community.smartsheet.com\/discussion\/106553\/critical-chain-method","dateInserted":"2023-06-16T15:21:43+00:00","insertUserID":158572,"insertUser":{"userID":158572,"name":"noviceuser","url":"https:\/\/community.smartsheet.com\/profile\/noviceuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T19:34:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106451,"type":"idea","name":"Add or Sync Billing Schedules into SmartSheets Resource Management","excerpt":"Currently there isn't a way to add or sync billing schedules into SmartSheets for revenue projections. The revenue is only projected by the system using hours and bill rates. For projects that are not time & materials, this is not useful.","categoryID":349,"dateInserted":"2023-06-14T18:45:14+00:00","dateUpdated":"2023-06-14T18:45:48+00:00","dateLastComment":"2023-06-14T18:45:14+00:00","insertUserID":162377,"insertUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162377,"lastUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":18,"score":2,"hot":3373537262,"url":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","format":"Rich","tagIDs":[363,468],"lastPost":{"discussionID":106451,"name":"Add or Sync Billing Schedules into SmartSheets Resource Management","url":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","dateInserted":"2023-06-14T18:45:14+00:00","insertUserID":162377,"insertUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-19T11%3A28%3A11%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":132,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">