Skip to main content

workflow_trigger_histories

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

Overview

Nameworkflow_trigger_histories
TypeResource
Idazure.web.workflow_trigger_histories

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
codestringGets the code.
correlationobjectThe run correlation.
endTimestring (date-time)Gets the end time.
errorobjectGets the error.
firedbooleanThe value indicating whether trigger was fired.
inputsLinkobjectGets the link to input parameters.
outputsLinkobjectGets the link to output parameters.
runobjectGets the reference to workflow run.
scheduledTimestring (date-time)The scheduled time.
startTimestring (date-time)Gets the start time.
statusstringGets the status. Known values are: "NotSpecified", "Paused", "Running", "Waiting", "Succeeded", "Skipped", "Suspended", "Cancelled", "Failed", "Faulted", "TimedOut", "Aborted", and "Ignored". (NotSpecified, Paused, Running, Waiting, Succeeded, Skipped, Suspended, Cancelled, Failed, Faulted, TimedOut, Aborted, Ignored)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
trackingIdstringGets the tracking id.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, name, workflow_name, trigger_name, history_name, subscription_idGets a workflow trigger history.
listselectresource_group_name, name, workflow_name, trigger_name, subscription_id$top, $filterGets a list of workflow trigger histories.
resubmitexecresource_group_name, name, workflow_name, trigger_name, history_name, subscription_idResubmits a workflow run based on the trigger history.

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.

NameDatatypeDescription
history_namestringThe workflow trigger history name. Corresponds to the run name for triggers that resulted in a run. Required.
namestringSite name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
trigger_namestringThe workflow trigger name. Required.
workflow_namestringThe workflow name. Required.
$filterstringThe filter to apply on the operation. Options for filters include: Status, StartTime, and ClientTrackingId. Default value is None.
$topintegerThe number of items to be included in the result. Default value is None.

SELECT examples

Gets a workflow trigger history.

SELECT
id,
name,
code,
correlation,
endTime,
error,
fired,
inputsLink,
outputsLink,
run,
scheduledTime,
startTime,
status,
systemData,
trackingId,
type
FROM azure.web.workflow_trigger_histories
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND name = '{{ name }}' -- required
AND workflow_name = '{{ workflow_name }}' -- required
AND trigger_name = '{{ trigger_name }}' -- required
AND history_name = '{{ history_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

Lifecycle Methods

Resubmits a workflow run based on the trigger history.

EXEC azure.web.workflow_trigger_histories.resubmit 
@resource_group_name='{{ resource_group_name }}' --required,
@name='{{ name }}' --required,
@workflow_name='{{ workflow_name }}' --required,
@trigger_name='{{ trigger_name }}' --required,
@history_name='{{ history_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;