{"id":456,"date":"2022-05-17T09:44:27","date_gmt":"2022-05-17T13:44:27","guid":{"rendered":"https:\/\/dbtricks.com\/?p=456"},"modified":"2022-05-17T09:44:27","modified_gmt":"2022-05-17T13:44:27","slug":"short-reminder-how-to-handle-informatica-http-transformation-failure-response","status":"publish","type":"post","link":"https:\/\/dbtricks.com\/?p=456","title":{"rendered":"Short reminder: how to handle Informatica http transformation failure response"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>A common way to invoke rest services is using informatica http transformation. This is an easy solution and it works great. You can get the response in the HTTPOUTPUT field you can write the response to the Database or &nbsp;parse it using Data Process Mappllet, &nbsp;or even simple string functions.<\/p>\n\n\n\n<p>While this works great when the service returns a successful response, by default, a failure response &nbsp;( 4xx and 5xx http errors for example) the HTTPOUT port is empty and an error is raised.<\/p>\n\n\n\n<p>So, what can you do if you want to write the failure response to the Data Base and continue to the next row? This way, the task can be completed and the failed records can be logged or retried.<\/p>\n\n\n\n<p>The simple solution is to Set the Custom property&nbsp;<em>IncludeErrorResponsesInHTTPTransformation=Yes<\/em><\/p>\n\n\n\n<p><em>This can be done in the session level but also in the integration server level.<\/em><\/p>\n\n\n\n<p>After setting the custom property <strong>Workflow Manager -> Edit Tasks -> Config Object -> Custom Properties -> Add attribute <em>IncludeErrorResponsesInHTTPTransformation<\/em> and write Yes in Value field<\/strong><\/p>\n\n\n\n<p>The error response will come out of the HTTP OUT port of the&nbsp;HTTP transformation just like a&nbsp; successful response.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/dbtricks.com\/wp-content\/uploads\/2022\/05\/IncludeErrorResponsesInHTTPTransformation.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"464\" src=\"https:\/\/dbtricks.com\/wp-content\/uploads\/2022\/05\/IncludeErrorResponsesInHTTPTransformation-1024x464.png\" alt=\"\" class=\"wp-image-460\" srcset=\"https:\/\/dbtricks.com\/wp-content\/uploads\/2022\/05\/IncludeErrorResponsesInHTTPTransformation-1024x464.png 1024w, https:\/\/dbtricks.com\/wp-content\/uploads\/2022\/05\/IncludeErrorResponsesInHTTPTransformation-300x136.png 300w, https:\/\/dbtricks.com\/wp-content\/uploads\/2022\/05\/IncludeErrorResponsesInHTTPTransformation-768x348.png 768w, https:\/\/dbtricks.com\/wp-content\/uploads\/2022\/05\/IncludeErrorResponsesInHTTPTransformation-624x283.png 624w, https:\/\/dbtricks.com\/wp-content\/uploads\/2022\/05\/IncludeErrorResponsesInHTTPTransformation.png 1035w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Custom Property IncludeErrorResponsesInHTTPTransformation<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>A common way to invoke rest services is using informatica http transformation. This is an easy solution and it works great. You can get the response in the HTTPOUTPUT field you can write the response to the Database or &nbsp;parse it using Data Process Mappllet, &nbsp;or even simple string functions. While this works great when [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[108],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-informatica"],"_links":{"self":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=456"}],"version-history":[{"count":4,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/456\/revisions"}],"predecessor-version":[{"id":462,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/456\/revisions\/462"}],"wp:attachment":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}