tSOAP response has base64Binary encoded data

[Dobby1]

I can make a successful call to a SOAP webservice with tSOAP component but the problem is that it returns an Excel document as a base64Binary data and I don't know how to either save the file or read the contents of the Excel file. Here's a sample of the response:

<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlnsOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="rollins-accommodate.symplicity.com/ws/report_api.php" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlnsOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<ns1:getReportExcelResponse>
<excel_link xsi:type="xsd:base64Binary">0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAOwADAP7/CQAGAAAAAAAAAAAAAAAkAAAAsREAAAAAAAAAEAAAAAAAAAEAAAD+////AAAAALIRAACzEQAAtBEAALURAAC2EQAAtxEAALgRAAC5EQAAuhEAALsRAAC8EQAAvREAAL4RAAC/EQAAwBEAAMERAADCEQAAwxEAAMQRAADFEQAAxhEAAMcRAADIEQAAyREAAMoRAADLEQAAzBEAAM0RAADOEQAAzxEAANARAADREQAA0hEAANMRAADUEQAA1REAAP////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////8JCBAAAAYFALsNzAdBAAAABgAAAEIAAgDkBD0AEgAAAAAAvCVyFTgAAAAAAAEAWAIiAAIAAAAxABUAyAAAAP9/kAEAAAAAAAAFAEFyaWFsMQAVAMgAAAD/f5ABAAAAAAAABQBBcmlhbDEAFQDIAAAA/3+QAQAAAAAAAAUAQXJpYWwxABUAyAAAAP9/kAEAAAAAAAAFAEFyaWFsMQAVAMgAAAD/f5ABAAAAAAAABQBBcmlhbDEAFQDIAAAADACQAQAAAQAAAAUAQXJpYWwxABUA3AAAAAwAvAIAAAAAAAAFAEFyaWFs4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAD1/yAAAAAAAAAAAAAAAMAg4AAUAAAAAAAAACAAAAAAAAAAAAAAAMAg4AAUAAYAAAAAACAAAAgAAAAAAAAAAMAg4AAUAAcAAAAAACAAACgAEAAAACAAAMAg4AAUAAAAAAAAAAAAAAAAAAAAAAAAAMAg4AAUAAAAAQAAAAAAAAQAAAAAAAAAAMAg4AAUAAAAAgAAAAAAAAQAAAAAAAAAAMAg4AAUAAAADgAAAAAAAAQAAAAAAAAAAMAg4AAUAAAAFgAAAAAAAAQAAAAAAAAAAMAg4AAUAAAAAAAAAAgAABAAAAAAAAAAAMAgkwIEAACAAP+SAOIAOAAAAAAA////AP8AAAAA/wAAAAD/AP//AAD/AP8AAP//AIAAAAAAgAAAAACAAICAAACAAIAAAICAAMDAwACAgIAAmZn/AJkzZgD//8wAzP//AGYAZgD/gIAAAGbMAMzM/wAAAIAA/wD/AP//AAAA//8AgACAAIAAAAAAgIAAAAD/AADM/wDM//8AzP/MAP//mQCZzP/v////7////9/////f////3////9/////f////3////9/////f////3////9/////f////3////9/////f////3////9/////f////3////9/////f////3////9/////f////3////9/////f////3////9/////f////3////9/////f////3////9/////f////3///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////8=</excel_link>
</ns1:getReportExcelResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

[Anonymous · Accepted solution]

Hi
Take a look at this thread, use tExtractXMLFiled to extract the body from response, and then decode base64Binary to byte array on a tJavaRow, and convert byte array to a file.
https://community.talend.com/t5/Design-and-Development/How-do-I-encode-a-csv-file-to-base64/m-p/4229...

Regards
Shong