How do i Download Soap attachment (payload) as XML

gt0731 — Sat, 16 Nov 2024 02:17:16 GMT

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.

Re: How do i Download Soap attachment (payload) as XML

Anonymous — Wed, 03 Jun 2020 10:08:24 GMT

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

Re: How do i Download Soap attachment (payload) as XML

ITDataAnalytics — Tue, 30 Nov 2021 17:20:42 GMT

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*

topic Re: How do i Download Soap attachment (payload) as XML in Talend Studio

How do i Download Soap attachment (payload) as XML

Re: How do i Download Soap attachment (payload) as XML

Re: How do i Download Soap attachment (payload) as XML