Home > front end >  Azure Data Factory - Capture error details of a dataflow activity
Azure Data Factory - Capture error details of a dataflow activity

Time:08-20

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

CodePudding user response:

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

  • Related