Identify Workflow from ID?

Samuel Mueller
Samuel Mueller Overachievers
inSmartsheet Basics

Good morning, got a random one. Is there any way to identify what sheet or workflow an automation ran from? I got a rogue automation this morning, and I don't know what sheet it lives in. However, I noticed at the bottom of the email, there is an ID number, similar to a sheet or row ID. Is there any way, maybe with the API, to identify this workflow and see where it came from?

image.png


Tags:
· Share on Facebook Share on Twitter

Best Answers

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    编辑的08/18/23

    There may be a way to do it through the API, but looking at the documentation it doesn't seem to be super straight forward.


    Basically you can get a list of sheets through the API, and you can also get a list of automations (including ID) through the API.


    I imagine that since that is the case, you should be able to generate a list of all automations with their sheets (maybe creating a list in SS somewhere).


    Edit To Update:

    You can also delete an automation through the API as long as you have the workflow ID as well as the sheet ID.

    10 xviz.com

    · Share on Facebook Share on Twitter
  • Samuel Mueller
    Samuel Mueller Overachievers

    @Paul Newcomeyeah that's what I was looking at too, but I don't know what sheet it came from and we have over 10000 sheets it would take a long time to loop through them.

    Was hoping I was missing something and there would be a call like Get Workflow and have it tell me what sheet it came from.

    · Share on Facebook Share on Twitter
  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Yeah. That does sound like it could take awhile. Haha. And if you knew the sheet I'd, you'd be able to just jump to it in SS instead of needing the api.


    Maybe a product enhancement request to expand the workflow portion of the api to include the sheet id is in order.

    10 xviz.com

    · Share on Facebook Share on Twitter
  • Hamza1
    Hamza1 Moderator
    Answer ✓

    Hi@Samuel Mueller,

    To add to Paul’s input, I believe contacting the Support team through thecustomer support portaland providing the workflow ID is the easiest way to get assistance with locating the sheet.

    Cheers,

    Hamza

    · Share on Facebook Share on Twitter

Categories

Hi @Laura G<\/a>,<\/p>

You can see when the last run occurred, but not a list of runs. <\/p>

Click Automation - Manage Workflows<\/p><\/div><\/div>

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

The \"Last ran\" date and time is displayed.<\/p>

BRgds,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":112019,"type":"question","name":"Change Dates w\/ CNT F","excerpt":"I can't seem to use the \"CTRL F\" function to change the years in the dates columns. For instance, I want to change Dec 25, 2023 to Dec 25, 2024. All I need to change is \"2023\" to \"2024\". Nothing seems to bring up the Dec 25, 2023 date no matter how I search. Can someone please let me know how to find such dates and then…","snippet":"I can't seem to use the \"CTRL F\" function to change the years in the dates columns. For instance, I want to change Dec 25, 2023 to Dec 25, 2024. All I need to change is \"2023\" to…","categoryID":321,"dateInserted":"2023-10-23T15:47:28+00:00","dateUpdated":null,"dateLastComment":"2023-10-24T15:45:06+00:00","insertUserID":140966,"insertUser":{"userID":140966,"name":"DieHard Jets","url":"https:\/\/community.smartsheet.com\/profile\/DieHard%20Jets","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqNr_7IPH7s!7YEoe-ZaUvs!GnmHpUESlnd","dateLastActive":"2023-10-24T15:03:54+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-10-25T13:58:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":34,"score":null,"hot":3396241354,"url":"https:\/\/community.smartsheet.com\/discussion\/112019\/change-dates-w-cnt-f","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112019\/change-dates-w-cnt-f","format":"Rich","lastPost":{"discussionID":112019,"commentID":401406,"name":"Re: Change Dates w\/ CNT F","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401406#Comment_401406","dateInserted":"2023-10-24T15:45:06+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-10-25T13:58:32+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-24T15:04:14+00:00","dateAnswered":"2023-10-24T13:03:33+00:00","acceptedAnswers":[{"commentID":401333,"body":"

You will need to enter the full date in the search and have it replace with a full date.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":112009,"type":"question","name":"Manufacturing Facility Relocation Template","excerpt":"Does anyone know of a template for managing a Manufacturing Site Relocation?","snippet":"Does anyone know of a template for managing a Manufacturing Site Relocation?","categoryID":321,"dateInserted":"2023-10-23T13:43:35+00:00","dateUpdated":null,"dateLastComment":"2023-10-24T13:24:35+00:00","insertUserID":43656,"insertUser":{"userID":43656,"name":"amcintyre","url":"https:\/\/community.smartsheet.com\/profile\/amcintyre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-25T14:52:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-10-25T18:07:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3396223090,"url":"https:\/\/community.smartsheet.com\/discussion\/112009\/manufacturing-facility-relocation-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112009\/manufacturing-facility-relocation-template","format":"Rich","tagIDs":[211,215],"lastPost":{"discussionID":112009,"commentID":401345,"name":"Re: Manufacturing Facility Relocation Template","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401345#Comment_401345","dateInserted":"2023-10-24T13:24:35+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-10-25T18:07:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-25T14:52:41+00:00","dateAnswered":"2023-10-24T13:24:35+00:00","acceptedAnswers":[{"commentID":401345,"body":"

Hey @amcintyre<\/a> <\/p>

I don't know if there's a template that specifically matches what you need, but you could try downloading some of the more generic templates or template sets and use them as a starting point. <\/p>

For example:<\/p>

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video