Dynamic View update via Smartsheet API

tkaczoro
tkaczoro ✭
edited 02/24/23 inAPI & Developers

Hello,

Does anyone know if it's possible to update Dynamic Views programmatically via Smartsheet API?

It's really frustrating that even such basic operation such as change of DV's source sheet requires creating a new DV from scratch.

Thanks for any help!

Tags:
· Share on Facebook Share on Twitter

Answers

Categories

If the column names are similar<\/em> but not exactly the same as the ones on the sheet, it is possible that some rows have been moved from another sheet with a similar purpose. <\/p>

You should be able to see this in the Activity Log (if you have access), but the other giveaway will be that will data in the similarly named columns but not the original ones.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":107283,"type":"question","name":"Determine all of the workflows a user is assigned to\/included in","excerpt":"Prior to deactivating a Smartsheet user, is there a way to see what workflows they were assigned to across all Smartsheet items? Oftentimes, the employee replacing that user will need to replace them in the workflows. Is there an easy way to do this? Even just knowing what workflows someone is involved in would be VERY…","snippet":"Prior to deactivating a Smartsheet user, is there a way to see what workflows they were assigned to across all Smartsheet items? Oftentimes, the employee replacing that user will…","categoryID":320,"dateInserted":"2023-07-06T15:31:33+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T12:57:30+00:00","insertUserID":163180,"insertUser":{"userID":163180,"name":"mgainey","url":"https:\/\/community.smartsheet.com\/profile\/mgainey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T12:46:30+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":"2023-07-13T20:48:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":41,"score":null,"hot":3377393943,"url":"https:\/\/community.smartsheet.com\/discussion\/107283\/determine-all-of-the-workflows-a-user-is-assigned-to-included-in","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107283\/determine-all-of-the-workflows-a-user-is-assigned-to-included-in","format":"Rich","lastPost":{"discussionID":107283,"commentID":384139,"name":"Re: Determine all of the workflows a user is assigned to\/included in","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384139#Comment_384139","dateInserted":"2023-07-07T12:57:30+00:00","insertUserID":45516,"insertUser":{"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":"2023-07-13T20:48:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-06T21:09:46+00:00","dateAnswered":"2023-07-06T17:23:30+00:00","acceptedAnswers":[{"commentID":383983,"body":"

Unfortunately there is no way to pull\/generate a report for this. It is a very manual process.<\/p>


<\/p>

Feel free to browse through the Product Ideas tab at the top of this page to see if someone has submitted the enhancement request. If they have, you can add your vote. If they have not, then you can submit it yourself and allow others to add their votes.<\/p>


<\/p>

Either way, it would be great if you could post a link to the enhancement request here so that others searching for the same thing can easily add their votes.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":107096,"type":"question","name":"Get a sheet URL with the Sheet ID [API]","excerpt":"I'm using Python and I want to get the URL of a sheet if I know its sheet ID. I try to create a list of hyperlink thru the API. I already have access to the sheet and I could copy the url by hand, but that is not the point.","snippet":"I'm using Python and I want to get the URL of a sheet if I know its sheet ID. I try to create a list of hyperlink thru the API. I already have access to the sheet and I could copy…","categoryID":320,"dateInserted":"2023-06-29T17:31:17+00:00","dateUpdated":null,"dateLastComment":"2023-07-03T12:14:17+00:00","insertUserID":152316,"insertUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/8ZFKAYNV3BAL\/n8XVTBY1DO7FK.png","dateLastActive":"2023-07-12T18:15:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":152316,"lastUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/8ZFKAYNV3BAL\/n8XVTBY1DO7FK.png","dateLastActive":"2023-07-12T18:15:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":66,"score":null,"hot":3376447534,"url":"https:\/\/community.smartsheet.com\/discussion\/107096\/get-a-sheet-url-with-the-sheet-id-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107096\/get-a-sheet-url-with-the-sheet-id-api","format":"Rich","tagIDs":[563],"lastPost":{"discussionID":107096,"commentID":383485,"name":"Re: Get a sheet URL with the Sheet ID [API]","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383485#Comment_383485","dateInserted":"2023-07-03T12:14:17+00:00","insertUserID":152316,"insertUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/8ZFKAYNV3BAL\/n8XVTBY1DO7FK.png","dateLastActive":"2023-07-12T18:15:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-03T12:14:33+00:00","dateAnswered":"2023-06-29T23:14:11+00:00","acceptedAnswers":[{"commentID":383235,"body":"

Try this: <\/p>

import smartsheet<\/p>

# Set your Smartsheet API access token<\/p>

access_token = 'YOUR_ACCESS_TOKEN'<\/p>

# Set the sheet ID for which you want to retrieve the URL<\/p>

sheet_id = 'YOUR_SHEET_ID'<\/p>

# Initialize the Smartsheet client<\/p>

client = smartsheet.Smartsheet(access_token)<\/p>

# Get the sheet details using the sheet ID<\/p>

sheet = client.Sheets.get_sheet(sheet_id)<\/p>

# Retrieve the URL from the sheet details<\/p>

sheet_url = sheet.permalink<\/p>

print(f'The URL of the sheet is: {sheet_url}')<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":563,"urlcode":"api","name":"API"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=320&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":204,"limit":3},"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in API & Developers

  • How could we know who add/create new column?

    hello all, My smart sheet just showed 3 new columns, I checked with my teammates and none of them add those columns so is there any record we can track for add/create column? In addition, new columns content is quite similar with one of the column, not 100% match , but partial of it, column name is more or less the same as…

  • Determine all of the workflows a user is assigned to/included in

    Prior to deactivating a Smartsheet user, is there a way to see what workflows they were assigned to across all Smartsheet items? Oftentimes, the employee replacing that user will need to replace them in the workflows. Is there an easy way to do this? Even just knowing what workflows someone is involved in would be VERY…

  • Get a sheet URL with the Sheet ID [API]

    I'm using Python and I want to get the URL of a sheet if I know its sheet ID. I try to create a list of hyperlink thru the API. I already have access to the sheet and I could copy the url by hand, but that is not the point.