workflow_runs

Creates, updates, deletes, gets or lists a workflow_runs resource.

Overview

Name	workflow_runs
Type	Resource
Id	azure.logic.workflow_runs

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	The resource id.
name	string	Gets the workflow run name.
code	string	Gets the code.
correlation	object	The run correlation.
correlationId	string	Gets the correlation id.
endTime	string (date-time)	Gets the end time.
error	object	Gets the error.
outputs	object	Gets the outputs.
response	object	Gets the response of the flow run.
startTime	string (date-time)	Gets the start time.
status	string	Gets the status. Known values are: "NotSpecified", "Paused", "Running", "Waiting", "Succeeded", "Skipped", "Suspended", "Cancelled", "Failed", "Faulted", "TimedOut", "Aborted", and "Ignored".
trigger	object	Gets the fired trigger.
type	string	Gets the workflow run type.
waitEndTime	string (date-time)	Gets the wait end time.
workflow	object	The resource reference. Variables are only populated by the server, and will be ignored when sending a request.

list

Name	Datatype	Description
id	string	The resource id.
name	string	Gets the workflow run name.
code	string	Gets the code.
correlation	object	The run correlation.
correlationId	string	Gets the correlation id.
endTime	string (date-time)	Gets the end time.
error	object	Gets the error.
outputs	object	Gets the outputs.
response	object	Gets the response of the flow run.
startTime	string (date-time)	Gets the start time.
status	string	Gets the status. Known values are: "NotSpecified", "Paused", "Running", "Waiting", "Succeeded", "Skipped", "Suspended", "Cancelled", "Failed", "Faulted", "TimedOut", "Aborted", and "Ignored".
trigger	object	Gets the fired trigger.
type	string	Gets the workflow run type.
waitEndTime	string (date-time)	Gets the wait end time.
workflow	object	The resource reference. Variables are only populated by the server, and will be ignored when sending a request.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, workflow_name, run_name, subscription_id		Gets a workflow run.
list	select	resource_group_name, workflow_name, subscription_id	$top, $filter	Gets a list of workflow runs.
cancel	exec	resource_group_name, workflow_name, run_name, subscription_id		Cancels a workflow run.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
resource_group_name	string	The resource group name. Required.
run_name	string	The workflow run name. Required.
subscription_id	string
workflow_name	string	The workflow name. Required.
$filter	string	The filter to apply on the operation. Options for filters include: Status, StartTime, and ClientTrackingId. Default value is None.
$top	integer	The number of items to be included in the result. Default value is None.

SELECT examples

get

Gets a workflow run.

SELECT
id,
name,
code,
correlation,
correlationId,
endTime,
error,
outputs,
response,
startTime,
status,
trigger,
type,
waitEndTime,
workflow
FROM azure.logic.workflow_runs
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workflow_name = '{{ workflow_name }}' -- required
AND run_name = '{{ run_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list

Gets a list of workflow runs.

SELECT
id,
name,
code,
correlation,
correlationId,
endTime,
error,
outputs,
response,
startTime,
status,
trigger,
type,
waitEndTime,
workflow
FROM azure.logic.workflow_runs
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workflow_name = '{{ workflow_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND $top = '{{ $top }}'
AND $filter = '{{ $filter }}'
;

Lifecycle Methods

cancel

Cancels a workflow run.

EXEC azure.logic.workflow_runs.cancel 
@resource_group_name='{{ resource_group_name }}' --required, 
@workflow_name='{{ workflow_name }}' --required, 
@run_name='{{ run_name }}' --required, 
@subscription_id='{{ subscription_id }}' --required
;