ADF REST API for Activity Runs not returning data

Question

I'm calling the Activity Runs Rest API from a parent pipeline to capture any errors in a child pipeline.

However, no data, of any kind, is being returned in the Value array.

Here are my settings.

Web activity

URL

https://management.azure.com/subscriptions/@{pipeline().globalParameters.SubscriptionId}/resourceGroups/@{pipeline().globalParameters.ResourceGrpName}/providers/Microsoft.DataFactory/factories/@{pipeline().DataFactory}/pipelineruns/@{pipeline().RunId}/queryActivityRuns?api-version=2018-06-01

Body

{   "lastUpdatedAfter": "2023-05-23T00:00:00.3345758Z",  
"lastUpdatedBefore": "2023-05-30T00:00:00.3686473Z" }

I've set an activity in the child pipeline to fail.

This is the response - nothing in the Value array

    {
        "value": [],
        "ADFWebActivityResponseHeaders": {
            "Pragma": "no-cache",
            "x-ms-correlation-request-id": "94cxxxx0-xxxx-xxxx-xxxx-b0842c922b3f",
...
        },
        "effectiveIntegrationRuntime": "AutoResolveIntegrationRuntime (West Europe)",
        "executionDuration": 0,
        "durationInQueue": {
            "integrationRuntimeQueue": 0
        },
        "billingReference": {
            "activityType": "ExternalActivity",
            "billableDuration": [
                {
                    "meterType": "AzureIR",
                    "duration": 0.016666666666666666,
                    "unit": "Hours"
                }
            ]
        }
    }

I've tried both the parent pipeline runid and the child pipeline runid in the URL and both return an empty Value array.

What am I missing?

score 1 · Accepted Answer · answered May 25 '23 at 11:22

1

You need to make sure that the pipeline whose execution details you want to capture is executed via 'Trigger' mode and not 'Debug' mode. So , you need to publish and trigger the pipeline, capture the pipeline runid and pass the same in the web activity.

answered May 25 '23 at 11:22

AnnuKumari

443
1
5

thanks, only a trigger run. Our environment is connected to Git and Publish can only be done with a PR merge. So I can't test this without merging a PR. It is what it is. – Geezer May 25 '23 at 18:55
1

Yes Correct you need to merge it ,.publish and then trigger it – AnnuKumari May 26 '23 at 05:16

score 1 · Answer 2 · answered May 25 '23 at 12:35

Agreed with @AnnuKumari to get activity run details the pipeline should be run with trigger does not debug mode faced same issue but when I triggered it I got an output. Also make sure that is right one and runs exist between the interval specified (UTC).

Also, as you want the activity run details of child pipeline activity. you need to provide its run id as @{activity('Execute Pipeline1').output.pipelineRunId}

Sample URL:

https://management.azure.com/subscriptions/@{pipeline().globalParameters.SubscriptionId}/resourceGroups/@{pipeline().globalParameters.ResourceGrpName}/providers/Microsoft.DataFactory/factories/@{pipeline().DataFactory}/pipelineruns/@{activity('Execute Pipeline1').output.pipelineRunId}/queryActivityRuns?api-version=2018-06-01

My execution:

enter image description here

Output:

enter image description here

thanks, only a trigger run. Our environment is connected to Git and Publish can only be done with a PR merge. So I can't test this without merging a PR. It is what it is. — Geezer, May 25 '23 at 18:55

ADF REST API for Activity Runs not returning data

2 Answers2

Linked