Forum Discussion

ThomasPyndt's avatar
ThomasPyndt
Frequent Visitor
2 years ago
Solved

How to handle empty response from REST API

Hi   I am setting up a delta load from a REST API, where I start by using a lookup to get the timestamp of the latest record in the destination and then use this value as a parameter a copy activit...
pipelines
  • gramc's avatar
    gramc
    2 years ago

    You can configure the lookup to perform an alternative action upon a failed connection, such as exiting the flow or bypassing the copy action. This will mark the overall flow run as successful, although the details will still indicate the failed lookup.

     

NandanHegde's avatar
NandanHegde
Icon for Super User rankSuper User
2 years ago

you can add an activity on failure, this way even the copy activity fails pipeline will run successfully.

Example:

I have added an activity to store the error code on failure.

@string(activity('Copy data1').Error.errorCode)
 

 

 

The below blog explains this concept in detail :

https://datasharkx.wordpress.com/2021/08/19/error-logging-and-the-art-of-avoiding-redundant-activities-in-azure-data-factory/

 

Note : ADF and data pipelines in fabric are similar concepts