API和开发人员

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

讨论表

with contents from another external site? \/\/ Leif","categoryID":320,"dateInserted":"2018-11-02T12:51:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-11-02T18:43:52+00:00","insertUserID":49531,"insertUser":{"userID":49531,"name":"Pejl","url":"https:\/\/community.smartsheet.com\/profile\/Pejl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-05\/69\/a7\/n69a7bb865b53771f6da8d0041efc02e4.png","dateLastActive":"2018-11-02T12:47:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":49531,"lastUser":{"userID":49531,"name":"Pejl","url":"https:\/\/community.smartsheet.com\/profile\/Pejl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-05\/69\/a7\/n69a7bb865b53771f6da8d0041efc02e4.png","dateLastActive":"2018-11-02T12:47:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":20,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/35041\/dashboard-widget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/35041\/dashboard-widget","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":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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":34941,"type":"discussion","name":"ODBC Connections and Outside Apps","excerpt":"Hi all, Hoping i can find some recommendations that can assist with an app development. I am creating a simple VS2010 Visual Basic app and report that will create purchase orders using smartsheet as the database back end. I have unlocked the smartsheet potential in ODBC connection but I am wondering if anyone has…","categoryID":320,"dateInserted":"2018-11-01T04:38:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-11-01T19:28:00+00:00","insertUserID":67726,"insertUser":{"userID":67726,"name":"Aviva","url":"https:\/\/community.smartsheet.com\/profile\/Aviva","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-11-01T04:32:46+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":67726,"lastUser":{"userID":67726,"name":"Aviva","url":"https:\/\/community.smartsheet.com\/profile\/Aviva","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-11-01T04:32:46+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":87,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/34941\/odbc-connections-and-outside-apps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34941\/odbc-connections-and-outside-apps","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"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"}],"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":[]}">