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;
byte buf = new sun.misc.BASE64Decoder().decodeBuffer(encodeList);
String decodeList = new String(buf, java.nio.charset.StandardCharsets.UTF_8);
context.OutputXMLEM = decodeList;
Could you tell me is there any way to get whole response from tSoap?
The return result of web service is a string with XML format, you can use tExtractXMLField component to extract the value after tSOAP.
Let us know if it is OK with you.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables