Azure Data Factory - Capture error details of a dataflow activity

Question

Hi,

I have a data flow and my requirement is to capture the error details into a variable when it fails. I tried to achieve this as below, but I'm unable to get only the error details instead it gives me additional information.

@activity('TVAViewersByMinute-Dataflow').error.Message

Answer 1

Adding onto this.
I've found the best way to capture a data flow error message is by this little maneuver.

@json(replace(activity('Data flow1').Error.message,'\','')).Message

Message (with a capital M) is an attribute within the Error.message object. It can be replaced with StatusCode or Details.

I save this in a string variable.

Hope this helps!

Answer 2

Hi @Vivek Komarla Bhaskar ,

Welcome to Microsoft Q&A platform and thanks for posting your question.
As I understand your requirement, you want to store the error message of the dataflow into a variable. However, you expect only the error message to be captured instead of other metadata. Please correct me if I am wrong.

The above output that you are getting is expected. In order to get only a error message , kindly use the following expression in 'set variable' activity. You can change the last value i.e. 1000 according to your requirement:

@substring(string(activity('dataflow10').Error.Message),indexof(string(activity('dataflow10').Error.Message),'message'),1000)  

Below are the images of set variable output before and after using substring function:

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators