Response size Limitation for TSoap in Talend Open Studio

Anonymous — Sun, 07 Apr 2019 09:40:27 GMT

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?

Re: Response size Limitation for TSoap in Talend Open Studio

Anonymous — Fri, 19 Apr 2019 10:41:03 GMT

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

topic Re: Response size Limitation for TSoap in Talend Open Studio in Talend Studio

Response size Limitation for TSoap in Talend Open Studio

Re: Response size Limitation for TSoap in Talend Open Studio