API和开发者

与来自世界各地的其他开发人员联系,并使用Smartsheet API就想法进行协作。

讨论表

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":[]}">