API和开发人员

使用Smartsheet API与世界各地的其他开发人员联系，并在想法上进行合作。

讨论表

= 1, [Total Man hours]7 <= 16), 1, IF(AND([Total Man hours]7 >= 17, [Total Man hours]7 <= 39), 2, IF(AND([Total Man hours]7 >= 40, [Total Man hours]7 <= 120), 3,…","categoryID":320,"dateInserted":"2018-10-22T19:03:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-23T08:29:47+00:00","insertUserID":66206,"insertUser":{"userID":66206,"name":"Mohammed Sulaiman","url":"https:\/\/community.smartsheet.com\/profile\/Mohammed%20Sulaiman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-01T20:42:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-09-01T20:14:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":17,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/34316\/screen-blurs-for-lengthy-formulas-or-multiple-parentheses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34316\/screen-blurs-for-lengthy-formulas-or-multiple-parentheses","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"API Developers","name":"API and Developers"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":302,"urlcode":"Community Platform","name":"Community Platform"}],"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":33896,"type":"discussion","name":"Unrecognized or Invalid Emails??","excerpt":"When sharing sheets between My account and Others(business partners\/clients), I often run into unrecognized email accounts warnings\/alerts... (and I have to drop what I'm doing and setup a contact in \"My Smartsheet Contacts\"). Wondering how common of a need this might be. I might invest a bit of time to come up with a…","categoryID":320,"dateInserted":"2018-10-16T09:44:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-22T22:50:37+00:00","insertUserID":65291,"insertUser":{"userID":65291,"name":"Sheetboy James","url":"https:\/\/community.smartsheet.com\/profile\/Sheetboy%20James","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-16T09:58:12+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":38316,"lastUser":{"userID":38316,"name":"Isaac Jose","url":"https:\/\/community.smartsheet.com\/profile\/Isaac%20Jose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-06\/5d\/c5\/n5dc5978318e80d19a8d0e31e1c0fdf67.PNG","dateLastActive":"2022-05-11T20:07:32+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":344,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/33896\/unrecognized-or-invalid-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/33896\/unrecognized-or-invalid-emails","format":"Html","groupID":null,"statusID":0,"attributes":{},"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 Developers","name":"API and Developers"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"}],"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":34271,"type":"discussion","name":"Build cashflow from multiple projects","excerpt":"I would like some help (happy to pay) to enable our company to map task and revenue budgeted for each task and then have the data feed into a cashflow sheet somehow. Could someone help me","categoryID":320,"dateInserted":"2018-10-21T23:02:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-22T00:55:16+00:00","insertUserID":66091,"insertUser":{"userID":66091,"name":"marc withnall","url":"https:\/\/community.smartsheet.com\/profile\/marc%20withnall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-21T22:59:05+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-04T23:51:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":57,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/34271\/build-cashflow-from-multiple-projects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34271\/build-cashflow-from-multiple-projects","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":227,"urlcode":"API 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":34036,"type":"discussion","name":"Transfer automatic data from SmartSheet to ERP","excerpt":"Hi, We would like to test SmartSheet for as a order follow up system. Whenever we are entering new orders, we need to transfer the informations to our own ERP system automatic via an API solution. Is that possible with SmartSheet?","categoryID":320,"dateInserted":"2018-10-18T05:18:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-19T04:45:29+00:00","insertUserID":65581,"insertUser":{"userID":65581,"name":"Nali","url":"https:\/\/community.smartsheet.com\/profile\/Nali","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-11-20T05:03:28+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-04T23:51:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":44,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/34036\/transfer-automatic-data-from-smartsheet-to-erp","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34036\/transfer-automatic-data-from-smartsheet-to-erp","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"API Developers","name":"API and Developers"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"}],"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}">

类别

受欢迎的标签

Thank you @Genevieve P.<\/a> for your response. I was looking for some automated way of completing this. I used the API documentation and Python code to create a script to extract the IDs from the response of the Get. I have this on my github. So this code automatically extracts the sheet ids from a report and puts them on a csv. This csv can be used as values for an update to the sheet, etc.<\/p>


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-02 12:24:26","updateUser":{"userID":141843,"name":"Emilio Wright","url":"https:\/\/community.smartsheet.com\/profile\/Emilio%20Wright","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!5glu-ZJ_dzs!wuDtd_oIOfs!l8yDMJ8cu5B","dateLastActive":"2022-09-02T12:24:28+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":94562,"type":"question","name":"Maps","excerpt":"Good day, What solutions do Smartsheet have to integrate maps ?","categoryID":320,"dateInserted":"2022-08-23T11:48:05+00:00","dateUpdated":null,"dateLastComment":"2022-08-23T13:05:47+00:00","insertUserID":151095,"insertUser":{"userID":151095,"name":"Nicole Martin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Nicole%20Martin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8NV8RNJXXw!jatWYxcQ1ro!ncYJipiOKr4","dateLastActive":"2022-08-23T13:03:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-04T23:51:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3322517032,"url":"https:\/\/community.smartsheet.com\/discussion\/94562\/maps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94562\/maps","format":"Rich","lastPost":{"discussionID":94562,"commentID":340740,"name":"Re: Maps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/340740#Comment_340740","dateInserted":"2022-08-23T13:05:47+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-04T23:51:15+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":"2022-08-23T13:15:13+00:00","dateAnswered":"2022-08-23T11:56:05+00:00","acceptedAnswers":[{"commentID":340718,"body":"

Hi @Nicole Martin<\/a> <\/p>

I hope you're well and safe!<\/p>

Have you explored Mapsly?<\/p>

\n \n \/\/www.santa-greenland.com\/marketplace\/apps\/mapsly-interactive-map-smartsheet\n <\/a>\n<\/div>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-23 13:15:13","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-02T16:07:33+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":94152,"type":"question","name":"How does giving query parameter \"FilterId\" filter the Get Sheet API response? I see no difference.","excerpt":"I am trying to give a particular filterId with a valid value of a manually created filter on a sheet, but the response however remains the same with and without this filter. On the UI of the sheet, filtration works exactly fine but I do not see the API response getting filtered out. Am I missing out on something? Do I need…","categoryID":320,"dateInserted":"2022-08-11T04:27:54+00:00","dateUpdated":"2022-08-11T04:29:48+00:00","dateLastComment":"2022-08-23T15:53:09+00:00","insertUserID":149582,"insertUser":{"userID":149582,"name":"Nishika Manira","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Nishika%20Manira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-29T06:13:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":149582,"lastUserID":149582,"lastUser":{"userID":149582,"name":"Nishika Manira","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Nishika%20Manira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-29T06:13:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":58,"score":null,"hot":3321463263,"url":"https:\/\/community.smartsheet.com\/discussion\/94152\/how-does-giving-query-parameter-filterid-filter-the-get-sheet-api-response-i-see-no-difference","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94152\/how-does-giving-query-parameter-filterid-filter-the-get-sheet-api-response-i-see-no-difference","format":"Rich","tagIDs":[438],"lastPost":{"discussionID":94152,"commentID":340785,"name":"Re: How does giving query parameter \"FilterId\" filter the Get Sheet API response? I see no difference.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/340785#Comment_340785","dateInserted":"2022-08-23T15:53:09+00:00","insertUserID":149582,"insertUser":{"userID":149582,"name":"Nishika Manira","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Nishika%20Manira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-29T06:13:57+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CLFX2BYSWC7N\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-24T04:59:13+00:00","dateAnswered":"2022-08-20T09:20:39+00:00","acceptedAnswers":[{"commentID":340514,"body":"

Hi @Nishika Manira<\/a> .<\/p>

Currently the use of filters via the API is limited to query params descriptors. When adding the \"filterID\" as a query param as you show in your screenshot, your API response should include the parameter \"filteredout<\/a>\" with boolean \"true\" or \"false\" values; provided that the filter is already applied in the sheet:<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

This goes in line with the documentation<\/a> since filters cannot be created or updated from the API. When you have a moment, please let our Product team know about your feedback by filling in this form, here.<\/a> Thank you!<\/p>

I hope that this can be of help. <\/p>

Cheers!<\/p>

Julio<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-24 04:59:13","updateUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/657\/nK3XO551IAZ8H.jpg","dateLastActive":"2022-09-03T09:39:08+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"}}},"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":438,"urlcode":"api-developers","name":"API Developers"}]}],"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">