How to capture URL / Error Message for SSIS Web API requests in Data Flow

Problem

I have a Data Flow which calls Web API using JSON Source or Web API Destination. Some times request fails and I like to know the error message along with a bad URL. Looks like JSON Source doesn't output URL / Error message. How can I achieve this?  

Solution

Here is a possible way to achieve this. Basically rather than using JSON Source you have to use Web API destination. This way you can connect Web API Destination Error Output to some destination and capture information regarding bad requests. In this example, we prepared a full URL with all parameters in Upstream only so it gives us an error flow. You can also use Derived Column Transform above Web API destination to add a URL column in the flow.

Contact Us

If you have more question(s) feel free to contact us viaLive chator email [e-mail]

https://zappysys.com/support/