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 $\"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>

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

API和开发者

讨论表

类别

受欢迎的标签