Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Response size Limitation for TSoap in Talend Open Studio

Hi,

Im using Talend Open Studio for Data Migration for get response from Soap service and insert into SQL database. Im facing size limitation issue when extracting data from Soap Service response. Large part of response is missing when output tSoap output. The response coming as encoded with base 64 from soap service and it will decode through from java code using tJavaRow.
The encoded response actual size length which get from Postman Client is 155467158. But when getting response size from tsoap from Talend Open studio is 16325,most of the data is missing. The below is the screen shot of the Talend job design. 

The below code is used inside of tJavaRow.

String encodeList = sss.encodeByte;
System.out.print(encodeList);

byte[] buf = new sun.misc.BASE64Decoder().decodeBuffer(encodeList);
String decodeList = new String(buf, java.nio.charset.StandardCharsets.UTF_8);
context.OutputXMLEM = decodeList;
System.out.print(decodeList);

 

Could you tell me is there any way to get whole response from tSoap?

Labels (5)
1 Reply
Anonymous
Not applicable
Author

Hello,

The return result of web service is a string with XML format, you can use tExtractXMLField component to extract the value after tSOAP.
tSOAP--main--tExtactXMLField--main--output.

Let us know if it is OK with you.

Best regards

Sabrina