Azure Data Factory - Capture error details of a dataflow activity

user_19667619 0
Viewed 102

I have a data flow and my requirement is to capture the error details into a variable when it fails and assign this variable to a parameter in the next data flow. I tried to achieve this until the second stage(With help) as below, but I'm unable to get this variable assigned to a parameter in the next data flow. The error I get is - Expression cannot be parsed

Pipeline Flow

First Dataflow Error

Variable output

Dataflow 2 parameters

Failure message

azure-data-factory azure
1 Answers

To retrieve the dataflow error message, connect the dataflow activity upon failure to the set variable activity to store the error message using the expression:

@string(json(activity('Data flow1').error.message).Message)

enter image description here

Error Message:

Ref2

Output:

enter image description here

user_182299800
Related