Happy Business Starts Here

Access to Run Number as a Workflow Data item

Access to Run Number as a Workflow Data item

We use Workflow to provision access to external systems.

 

Sometimes this access is not provisioned because the workflow had issues, or required fields were not properly entered etc.

 

When searching for a specifc run, to find out what went wrong, is only one option:

skim through looking at the date/time to see when the workflow should have been called, looking for any with errors

 

There is a search workflow option, but this only really works for looking up Workflow names, or Run Numers - any data within a run e.g. Acccount Number is not searchable

 

We want to be able to record the Workflow Run Number that managed that task and then save it against certain objects (e.g. Subscription, Invoice) - either as a custom field, or to have some logging that would allow this to be linked directly.

 

Example:

On Payment received, Workflow A runs to provision access

When Workflow A starts, the RunNumber will be recorded/linked on the Invoice/Payment object

If there are any issues preventing the workflow running, I can find the Invoice/Payment object - click on the Run Number, and go straight to the run history to see if there were any issues

4 Comments
gauri
Master

Any update on this idea? we have a similar need and looking for options are available.

 

dduff
Savvy Scholar

Here, too. Would like to send a custom notification when an approval is needed which includes the run number.

shakir-karim
Zuora Product Team
Status changed to: Accepted

There is a feature enabled in your sandbox environments today that will move to production in March 5th that I believe can help with these use cases. 

 

We now are exposing workflow definition and run details for extraction using Data query. Documentation specifically on this capability is being created in preparation for production / general availability, but in the meantime please do try it out and give us feedback. 

 

Steps

  • Navigate to Data Query (under Platform) within your sandbox
  • Use 'Describe Workflow' to return the description of fields available for a workflow run or setup
  • Use 'Describe Task' to return description of fields available for task runs and setups
  • Create your query (get approval tasks in pending, join workflows, select name, index join)
  • Test your query
  • Save your query
  • Create workflow (new also in sandbox is ability to pull up a "Saved Query" within Retrieve --> Data Query step) that takes your query, iterates and actions.

Use Community to post questions if help is needed:

shakir-karim
Zuora Product Team
Status changed to: Delivered

 

"Prefix the object names with workflow to allow easier search-ability, visibility and usability" 

 

Existing object / table name  New object / table name
workflow workflow (no change)
task workflow_task
linkage workflow_linkage
api_call workflow_api_call
task_usage workflow_task_usage