Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


REST WebService Consumer transformation failing to parse the data when the response is very large or contains special multi-byte characters
Problem Description
When REST WSC is configured to return JSON data and the response is huge (20,000,000 characters) or includes special multi-byte characters, transformation fails to parse the response to the output ports. 

From the mapping verbose data log, you can see the following message, which clearly states that the transformation is unable to convert the JSON to XML:

2017-10-13 16:10:50 <TASK_26388-TRANSF_1_1_1> FINER: [PMREST_EN_33039] HTTP Response Body: JSON
2017-10-13 16:10:53 <TASK_26388-TRANSF_1_1_1> FINER: [PMREST_EN_33039] HTTP Response Body: <Rest_Consumer_output>No xml String returned</Rest_Consumer_output>
This is a known issue in 10.1.x for which we already have a CR (PLAT-18714) submitted to address it in future releases.
To resolve this issue, apply the EBF patch available on 10.2.2, 10.2 HotFix 2 by contacting Informatica Global Customer Support.

OR use the following workaround:

Workaround steps:

  1. Use REST WebService Consumer transformation just to make the HTTP call to endpoint URL and get the response.
  2. Use Data Processor transformation to parse the above response.
More Information
Applies To
Product: Data Quality; PowerCenter; Data Engineering Integration(Big Data Management)
Problem Type: Product Feature
User Type: Business Analyst; Developer
Project Phase: Implement; Onboard
Product Version: Data Quality 10.0; Data Quality 10.1; Data Quality 10.1.1; Big Data Management 10.2.2 Service Pack 1
Operating System:
Other Software:

Last Modified Date:9/20/2019 6:01 AMID:520252
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)