Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gt0731
Contributor III
Contributor III

How do i Download Soap attachment (payload) as XML

Hi  Everyone, 

I am stuck in soap call, when trying to download attachment(payload) as xml. 

After following this steps 

1. SOAP to xyz system:
a. SOAP Endpoint to call: https://A/SOAP/URL
b. Attached Request XML
c. Attached Response XML, and its Attachment XML
d.  when we call this SOAP call, we have to download the attachment(payload) XML and create a file out of it.

 

Created Input design flow

 

tFileInputXML >> tsoap >> tFileOutputXML >>extract payload >> extract  XML field  >> tFileOutputDelimited

Looking for design flow so that i am able to download the attachment(payload) XML just after soap component. 

 

Thanks in advance.

 

 

Labels (3)
2 Replies
Anonymous
Not applicable

Hi
What is the problem you meet now? Are you able to call the SOAP web service?
The response of tSOAP is a string or a Document, you can output the Document to a XML file directly with tFileOutputXML or extract data from the response.

Regards
Shong
ITDataAnalytics
Contributor
Contributor

Hello,

 

Here is an example of the problem. This particular response happens to be from an Oracle SOAP service. The response is a bit truncated when I pasted it so the full binary payload is not visible below.

 

When I use tSOAP to make the same call, the tSOAP component stops before the second ------=_Part_1166276_1680530213.1638284884616 tag.

 

This is the response from the SOAP call using SOAPUI. In the response you can see that there are two Content-ID tags., and two ------=_Part_1166276_1680530213.1638284884616 tags.

 

The problem then is how do we get access to the binary data. That is the attachment that we need to download from the response.

 

Any ideas?

Thank you

Wayne

 

HTTP/1.1 200 OK

Server: Oracle-HTTP-Server

X-XSS-Protection: 1; mode=block

X-ORACLE-DMS-ECID: 005oWBgYfBqA_M5_rPO5yY0002ek0000Ls

SOAPAction: ""

Content-Encoding: gzip

Content-Type: multipart/related;type="application/xop+xml";boundary="----=_Part_1166276_1680530213.1638284884616";start="<bc92b463-3bc0-4b93-8174-fce08fd644d9>";start-info="text/xml"

Content-Language: en

X-Content-Type-Options: nosniff

Strict-Transport-Security: max-age=31536000; includeSubDomains

Date: Tue, 30 Nov 2021 15:08:04 GMT

Transfer-Encoding: chunked

Connection: keep-alive

Vary: Accept-Encoding

Connection: Transfer-Encoding

Set-Cookie: JSESSIONID=cRhxY3eAWu3zqD65itKTsLiB-qKFmfOTxXiCu2UI2AmJiK9AYJCR!1749305436; path=/; HttpOnly;SameSite=None;Secure

Set-Cookie: _WL_AUTHCOOKIE_JSESSIONID=CaHKAQSeUlMIktM5oki7; path=/; secure; HttpOnly;SameSite=None;Secure

 

------=_Part_1166276_1680530213.1638284884616

Content-Type: application/xop+xml;charset=UTF-8;type="text/xml"

Content-Transfer-Encoding: 8bit

Content-ID: <bc92b463-3bc0-4b93-8174-fce08fd644d9>

 

<?xml version="1.0" encoding="UTF-8" ?>

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing"><env:Header><wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpIntegrationService/getDocumentForDocumentIdResponse</wsa:Action><wsa:MessageID>urn:uuid:0893c4b6-f895-4b90-ab6a-7487af9978b0</wsa:MessageID></env:Header><env:Body><ns0:getDocumentForDocumentIdResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"><ns2:result xmlns:ns2="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" xmlns:ns1="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns0:DocumentDetails"><ns0:Content><xop:Include xmlns:xop="http://www.w3.org/2004/08/xop/include" href="cid:b224a2f4-0e55-4eb1-996f-0753c5c7dd7f"/></ns0:Content><ns0:FileName xsi:nil="true"/><ns0:ContentType xsi:nil="true"/><ns0:DocumentTitle>196A26D39CE847DDA2153EC6E710D670_____196A26D39CE847DDA2153EC6E710D670</ns0:DocumentTitle><ns0:DocumentAuthor>FUSION_APPS_FIN_ADF_APPID</ns0:DocumentAuthor><ns0:DocumentSecurityGroup>IPMSYS_APP_1</ns0:DocumentSecurityGroup><ns0:DocumentAccount xsi:nil="true"/><ns0:DocumentName>196A26D39CE847DDA2153EC6E710D670_____196A26D39CE847DDA2153EC6E710D670.tif</ns0:DocumentName><ns0:DocumentId>2873453</ns0:DocumentId></ns2:result></ns0:getDocumentForDocumentIdResponse></env:Body></env:Envelope>

------=_Part_1166276_1680530213.1638284884616

Content-Transfer-Encoding: binary

Content-ID: <b224a2f4-0e55-4eb1-996f-0753c5c7dd7f>

 

II*