Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP PI/PO – Download Dowjones quotation rates - JavaMapping solution

rhviana
Active Contributor
‎2022 Oct 19 8:12 PM
806
Hello Folks on-premise,

Everything is good here or it’s time to fly (cloud) - SAP CPI !!!! ? 😀

I just would like to post one solution for a project that the requirement to download the list from DowJones in general used for quotation process and others related with financial aspects.

 

*IMPORTANT, you should require user and password to access the DowJones API with DowJones team.*

 



Agenda:







  1. Introduction




  2. Integration Diagram



  3. Integration Development Steps


    1. Process steps – Repository




      1. DJSPListResponse java - Outbound - First interface




      2. StreamToZipAttachment java - Inbound - Second interface






    2. Process steps – Directory






  4. SAP PI Testing first interface




  5. SAP PI Testing second interface




  6. Conclusion




 



Introduction





Basically the integration is using API Rest ( HTTPS ) to download the list of files that can be used for financial aspects.

There are two API's, one to download the list and another to download the ZIP file valid for that specific filename.



Integration Diagram:





I decide design the integration in SAP PI breaking in two times, first time download the list and add via java mapping inside one tag in the XML custom payload generated via java mapping and add those values as string.

 

The abaper should separate the values using the parameter " ; " for each file, stored and trigger the second time of integration, where a proxy generate will stimulate SAP PI with name of file that should download go for the second API to download the ZIP file.

The second interface is responsable to read the input stream and create the main documento payload as XML and the attachment of ZIP downloaded from the API and response to backend system.

The abap program should recive the data, extract the attachment from the second proxy and open zip file to be processed the details inside the file.



 






Clear for you? 


Let’s rock!





Integration Development Steps:





I will just high light with the picture and mention the steps of java mapping import.


  1. Repository:



    • Imported Archives – JavaMapping




  2. Directory:



    • ICO Receiver Interface

    • ICO Outbound Processing SFTP Channels







Process steps – Repository:







  • Repository: Imported Archives – JavaMapping





DJSPListResponse java - Outbound - First interface:





This first java mapping is responsable in the response of the first API, to push the list of files available, use the inputstream and add inside one XML tag <String>.

From this list the abap program will store, split and many table entry to call the second interface to download the zip files.
package com.sap.DJSPLListResponse;



import java.io.InputStream;

import java.io.OutputStream;



import com.sap.aii.mapping.api.AbstractTransformation;

import com.sap.aii.mapping.api.StreamTransformationException;

import com.sap.aii.mapping.api.TransformationInput;

import com.sap.aii.mapping.api.TransformationOutput;



public class DJSPLListResponse extends AbstractTransformation {

	

	public void transform(TransformationInput transformationInput, TransformationOutput transformationOutput) throws StreamTransformationException

	{

		try {

			//Info message is added to trace. 

			getTrace().addInfo("JAVA Mapping Called");

			

			InputStream inputstream = transformationInput.getInputPayload().getInputStream();

            OutputStream outputstream = transformationOutput.getOutputPayload().getOutputStream();

            

          //Getting input payload into strInContent.              

            byte[] b = new byte[inputstream.available()];

            inputstream.read(b);

            String strInContent = new String(b);

            

            String tagdiv = strInContent.substring(strInContent.indexOf("<div>") + 5, strInContent.indexOf("</div>")).trim();

            

            String prefix = "<?xml version=\"1.0\" encoding=\"UTF-8\"?><ns0:MT_Dowjones_SplListResponse xmlns:ns0=\"http://oerlikon.com/Dowjones/IF_0056_SplList\">";

            String suffix = "</ns0:MT_Dowjones_SplListResponse>";

            

            String xmlPayload= "";

            xmlPayload = prefix + "<SPL><String>" + tagdiv + "</String></SPL>" + suffix;



            

            outputstream.write(xmlPayload.getBytes());

		}

		

		catch(Exception exception)

		{

			//If exception occurs it is written to mapping trace.

			getTrace().addDebugMessage(exception.getMessage());

			//stopping the mapping by throwing exception.

			throw new StreamTransformationException(exception.getMessage());

		}

	}



}




StreamToZipAttachment java - Inbound - Second interface:





This java mapping also you can use the generate a local files in your machine, so a completly generic code that you should adapt for your case but you can test locally before upload in the SAP PI via SAP Netweaver developer studio.

Another point, if you use local, there is no possibility to see the attachment but only the output Main Document payload.

 
package <your_package>;



import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

import java.io.StringReader;

import java.io.StringWriter;







import javax.xml.parsers.DocumentBuilder;

import javax.xml.parsers.DocumentBuilderFactory;

import javax.xml.parsers.ParserConfigurationException;

import javax.xml.transform.Transformer;

import javax.xml.transform.TransformerException;

import javax.xml.transform.TransformerFactory;

import javax.xml.transform.dom.DOMSource;

import javax.xml.transform.stream.StreamResult;



import org.w3c.dom.Document;

import org.w3c.dom.Node;

import org.xml.sax.InputSource;

import org.xml.sax.SAXException;



import com.sap.aii.mapping.api.AbstractTransformation;

import com.sap.aii.mapping.api.Attachment;

import com.sap.aii.mapping.api.DynamicConfiguration;

import com.sap.aii.mapping.api.DynamicConfigurationKey;

import com.sap.aii.mapping.api.InputAttachments;

import com.sap.aii.mapping.api.OutputAttachments;

import com.sap.aii.mapping.api.StreamTransformation;

import com.sap.aii.mapping.api.StreamTransformationConstants;

import com.sap.aii.mapping.api.StreamTransformationException;

import com.sap.aii.mapping.api.TransformationInput;

import com.sap.aii.mapping.api.TransformationOutput;

import com.sap.engine.interfaces.messaging.api.auditlog.AuditLogStatus;



public class StreamToZipAttachment extends AbstractTransformation {



	

	  /*public static void main(String[] args) throws Exception {

	  

	  FileInputStream inFile = new FileInputStream(

	  "C:\\Users\\ricardo.viana\\Desktop\\MainDocument.txt"); FileOutputStream

	  outFile = new FileOutputStream(

	  "C:\\Users\\ricardo.viana\\Desktop\\Payload2.xml"); new

	  StreamToZipAttachment().local(inFile, outFile); }

	  

	  private void local(FileInputStream inFile, FileOutputStream outFile)

	 throws Exception {

	  

	  String xmlPayload = "";

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

	  xmlPayload.concat(

	  "<ns1:MT_ECC_SplFileResponse xmlns:ns1=\"http://oerlikon.com/sap/ecc/IF_0056_SplList_Zip\">"

	  ); xmlPayload = xmlPayload.concat("<SPL_FILE>"); xmlPayload =

	  xmlPayload.concat("<Value>"); xmlPayload = xmlPayload.concat("asdsadada");

	  xmlPayload = xmlPayload.concat("</Value>"); xmlPayload =

	  xmlPayload.concat("</SPL_FILE>"); xmlPayload =

	  xmlPayload.concat("</ns1:MT_ECC_SplFileResponse>");

	  System.out.println(xmlPayload);

	  Document doc = toXmlDocument(xmlPayload);

	  

	  String str = toXmlString(doc);

	  outFile.write(str.getBytes("UTF-8"));

	  

	  }*/

	 



	public void transform(TransformationInput in, TransformationOutput out)

			throws StreamTransformationException {

		try {



			// AuditLogHelper logger =

			// AuditLogHelper.getInstance(in.getInputHeader().getMessageId());

			// logger.log("**** Java Mapping Starting ******",AuditLogStatus.SUCCESS);

			InputStream inputstream = in.getInputPayload().getInputStream();

			OutputStream outputstream = out.getOutputPayload()

					.getOutputStream();

			// logger.log("Static name of ZIP Attachment: " +

			// fileName,AuditLogStatus.SUCCESS);

			String xmlPayload = "";

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

			xmlPayload = xmlPayload

					.concat("<ns1:MT_ECC_SplFileResponse xmlns:ns1=\"http://oerlikon.com/sap/ecc/IF_0056_SplList_Zip\">");

			xmlPayload = xmlPayload.concat("<SPL_FILE>");

			xmlPayload = xmlPayload.concat("<Value>");

		    xmlPayload = xmlPayload.concat("ZipAttachment.zip");

			xmlPayload = xmlPayload.concat("</Value>");

			xmlPayload = xmlPayload.concat("</SPL_FILE>");

			xmlPayload = xmlPayload.concat("</ns1:MT_ECC_SplFileResponse>");

			// Writing the output XML Payload from the concatenation above to

			// string xmlPayload

			Document doc = toXmlDocument(xmlPayload);

			  

			String str = toXmlString(doc);

			outputstream.write(str.getBytes("UTF-8"));

			// Instance of create attachment in the outputPayload

			OutputAttachments outputAttachments = out.getOutputAttachments();

			// Check the bytes of inputstream message

			byte[] b = new byte[inputstream.available()];

			// Instance a new attachment

			// Instance of variable type Byte B if there is inputstream

			// available

			try {

				// Check the lenght of inputstream if is bigger than zero (0)

				if (b.length != 0) {

					// Read the inputstream bytes.

					inputstream.read(b);

					// Creating a new attachment in the Main Document Payload as

					// a Content-Type application/zip with fix value name

					// Attachment.zip

					Attachment newAttachment = outputAttachments.create(

							"ZipAttachment.zip", "application/zip", b);

					// Set the new attachment in the Main Document Payload

					outputAttachments.setAttachment(newAttachment);

				}

			} catch (Exception e) {

				// logger.log("**** Exception ******" +

				// e.getMessage(),AuditLogStatus.SUCCESS);

				e.getMessage();

			}



		}



		catch (Exception e) {

			throw new StreamTransformationException("Error: " + e.getMessage());

		}



	}



	private static Document toXmlDocument(String str)

			throws ParserConfigurationException, SAXException, IOException {



		DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory

				.newInstance();

		DocumentBuilder docBuilder = docBuilderFactory.newDocumentBuilder();

		Document document = (Document) docBuilder.parse(new InputSource(

				new StringReader(str)));



		return document;

	}



	private static String toXmlString(Document document)

			throws TransformerException {

		TransformerFactory transformerFactory = TransformerFactory

				.newInstance();

		Transformer transformer = transformerFactory.newTransformer();

		DOMSource source = new DOMSource((Node) document);

		StringWriter strWriter = new StringWriter();

		StreamResult result = new StreamResult(strWriter);



		transformer.transform(source, result);



		return strWriter.getBuffer().toString();



	}



}




Process steps – Directory:





I will not present the step by step the developer should know, but nothing special, just in the receiver REST adapter there is a custom setup to extract the name of file to complete the end url address extract as custom parameter in the adapter setup

  • ICO First Interface and ICO Second Interface



First download list and second file.



First Adapter receiver REST:







Second adapter receiver setup:



 

As you can see in the picture above, the end address:

https://djrcfeed.dowjones.com/DPL/SAP/xml/{Input}

The value of {input}  will be replace from the value that comes in the Main Document Payload into tag <value>

 



SAP PI Testing first interface:





This part of code above is responsible to extract all the value from the tag <div>  html version from the replay call API list of files available:







String tagdiv = strInContent.substring(strInContent.indexOf("<div>") + 5, strInContent.indexOf("</div>")).trim();



Request dummy XML:







Response:








<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">



<html xmlns="http://www.w3.org/1999/xhtml">

<head><title>



</title></head>

<body>

    <form method="post" action="" id="form1">

<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="no-longer-used" />



<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="10250408" />

    <div>

    dpl_sap_xml_202210182359_f.zip,dpl_sap_xml_202210182359_d.zip,dpl_sap_xml_202210172359_f.zip,dpl_sap_xml_202210172359_d.zip,dpl_sap_xml_202210162359_f.zip,dpl_sap_xml_202210162359_d.zip,dpl_sap_xml_202210152359_f.zip,dpl_sap_xml_202210152359_d.zip,dpl_sap_xml_202210142359_f.zip,dpl_sap_xml_202210142359_d.zip,dpl_sap_xml_202210132359_f.zip,dpl_sap_xml_202210132359_d.zip,dpl_sap_xml_202210122359_f.zip,dpl_sap_xml_202210122359_d.zip,dpl_sap_xml_202210112359_f.zip,dpl_sap_xml_202210112359_d.zip,dpl_sap_xml_202210102359_f.zip,dpl_sap_xml_202210102359_d.zip,dpl_sap_xml_202210092359_f.zip,dpl_sap_xml_202210092359_d.zip,dpl_sap_xml_202210082359_f.zip,dpl_sap_xml_202210082359_d.zip,dpl_sap_xml_202210072359_f.zip,dpl_sap_xml_202210072359_d.zip,dpl_sap_xml_202210062359_f.zip,dpl_sap_xml_202210062359_d.zip,dpl_sap_xml_202210052359_f.zip,dpl_sap_xml_202210052359_d.zip,dpl_sap_xml_202210042359_f.zip,dpl_sap_xml_202210042359_d.zip,dpl_sap_xml_202210032359_f.zip,dpl_sap_xml_202210032359_d.zip,dpl_sap_xml_202210022359_f.zip,dpl_sap_xml_202210022359_d.zip,dpl_sap_xml_202210012359_f.zip,dpl_sap_xml_202210012359_d.zip,dpl_sap_xml_202209302359_f.zip,dpl_sap_xml_202209302359_d.zip,dpl_sap_xml_202209292359_f.zip,dpl_sap_xml_202209292359_d.zip,dpl_sap_xml_202209282359_f.zip,dpl_sap_xml_202209282359_d.zip,dpl_sap_xml_202209272359_f.zip,dpl_sap_xml_202209272359_d.zip,dpl_sap_xml_202209262359_f.zip,dpl_sap_xml_202209262359_d.zip,dpl_sap_xml_202209252359_f.zip,dpl_sap_xml_202209252359_d.zip,dpl_sap_xml_202209242359_f.zip,dpl_sap_xml_202209242359_d.zip,dpl_sap_xml_202209232359_f.zip,dpl_sap_xml_202209232359_d.zip,dpl_sap_xml_202209222359_f.zip,dpl_sap_xml_202209222359_d.zip,dpl_sap_xml_202209212359_f.zip,dpl_sap_xml_202209212359_d.zip,dpl_sap_xml_202209202359_f.zip,dpl_sap_xml_202209202359_d.zip,dpl_sap_xml_202209192359_f.zip,dpl_sap_xml_202209192359_d.zip,dpl_sap_xml_202209182359_f.zip,dpl_sap_xml_202209182359_d.zip,dpl_sap_xml_202209172359_f.zip,dpl_sap_xml_202209172359_d.zip,dpl_sap_xml_202209162359_f.zip,dpl_sap_xml_202209162359_d.zip,dpl_sap_xml_202209152359_f.zip,dpl_sap_xml_202209152359_d.zip,dpl_sap_xml_202209142359_f.zip,dpl_sap_xml_202209142359_d.zip,dpl_sap_xml_202209132359_f.zip,dpl_sap_xml_202209132359_d.zip,dpl_sap_xml_202209122359_f.zip,dpl_sap_xml_202209122359_d.zip,dpl_sap_xml_202209112359_f.zip,dpl_sap_xml_202209112359_d.zip,dpl_sap_xml_202209102359_f.zip,dpl_sap_xml_202209102359_d.zip,dpl_sap_xml_202209092359_f.zip,dpl_sap_xml_202209092359_d.zip,dpl_sap_xml_202209082359_f.zip,dpl_sap_xml_202209082359_d.zip,dpl_sap_xml_202209072359_f.zip,dpl_sap_xml_202209072359_d.zip,dpl_sap_xml_202209062359_f.zip,dpl_sap_xml_202209062359_d.zip,dpl_sap_xml_202209052359_f.zip,dpl_sap_xml_202209052359_d.zip,dpl_sap_xml_202209042359_f.zip,dpl_sap_xml_202209042359_d.zip,dpl_sap_xml_202209032359_f.zip,dpl_sap_xml_202209032359_d.zip,dpl_sap_xml_202209022359_f.zip,dpl_sap_xml_202209022359_d.zip,dpl_sap_xml_202209012359_f.zip,dpl_sap_xml_202209012359_d.zip,dpl_sap_xml_202208312359_f.zip,dpl_sap_xml_202208312359_d.zip,dpl_sap_xml_202208302359_f.zip,dpl_sap_xml_202208302359_d.zip,dpl_sap_xml_202208292359_f.zip,dpl_sap_xml_202208292359_d.zip,dpl_sap_xml_202208282359_f.zip,dpl_sap_xml_202208282359_d.zip,dpl_sap_xml_202208272359_f.zip,dpl_sap_xml_202208272359_d.zip,dpl_sap_xml_202208262359_f.zip,dpl_sap_xml_202208262359_d.zip,dpl_sap_xml_202208252359_f.zip,dpl_sap_xml_202208252359_d.zip,dpl_sap_xml_202208242359_f.zip,dpl_sap_xml_202208242359_d.zip,dpl_sap_xml_202208232359_f.zip,dpl_sap_xml_202208232359_d.zip,dpl_sap_xml_202208222359_f.zip,dpl_sap_xml_202208222359_d.zip,dpl_sap_xml_202208212359_f.zip,dpl_sap_xml_202208212359_d.zip,dpl_sap_xml_202208202359_f.zip,dpl_sap_xml_202208202359_d.zip

    </div>

    </form>

</body>

</html>

The java mapping extract whole list from tag <div> and create a main document payload response as you can see below with the list inside tag <String>:







Response XML:



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

<ns1:MT_ECC_SplListResponse

	xmlns:ns1="http://oerlikon.com/sap/ecc/IF_0056_SplList">

	<SPL>

		<String>dpl_sap_xml_202210182359_f.zip,dpl_sap_xml_202210182359_d.zip,dpl_sap_xml_202210172359_f.zip,dpl_sap_xml_202210172359_d.zip,dpl_sap_xml_202210162359_f.zip,dpl_sap_xml_202210162359_d.zip,dpl_sap_xml_202210152359_f.zip,dpl_sap_xml_202210152359_d.zip,dpl_sap_xml_202210142359_f.zip,dpl_sap_xml_202210142359_d.zip,dpl_sap_xml_202210132359_f.zip,dpl_sap_xml_202210132359_d.zip,dpl_sap_xml_202210122359_f.zip,dpl_sap_xml_202210122359_d.zip,dpl_sap_xml_202210112359_f.zip,dpl_sap_xml_202210112359_d.zip,dpl_sap_xml_202210102359_f.zip,dpl_sap_xml_202210102359_d.zip,dpl_sap_xml_202210092359_f.zip,dpl_sap_xml_202210092359_d.zip,dpl_sap_xml_202210082359_f.zip,dpl_sap_xml_202210082359_d.zip,dpl_sap_xml_202210072359_f.zip,dpl_sap_xml_202210072359_d.zip,dpl_sap_xml_202210062359_f.zip,dpl_sap_xml_202210062359_d.zip,dpl_sap_xml_202210052359_f.zip,dpl_sap_xml_202210052359_d.zip,dpl_sap_xml_202210042359_f.zip,dpl_sap_xml_202210042359_d.zip,dpl_sap_xml_202210032359_f.zip,dpl_sap_xml_202210032359_d.zip,dpl_sap_xml_202210022359_f.zip,dpl_sap_xml_202210022359_d.zip,dpl_sap_xml_202210012359_f.zip,dpl_sap_xml_202210012359_d.zip,dpl_sap_xml_202209302359_f.zip,dpl_sap_xml_202209302359_d.zip,dpl_sap_xml_202209292359_f.zip,dpl_sap_xml_202209292359_d.zip,dpl_sap_xml_202209282359_f.zip,dpl_sap_xml_202209282359_d.zip,dpl_sap_xml_202209272359_f.zip,dpl_sap_xml_202209272359_d.zip,dpl_sap_xml_202209262359_f.zip,dpl_sap_xml_202209262359_d.zip,dpl_sap_xml_202209252359_f.zip,dpl_sap_xml_202209252359_d.zip,dpl_sap_xml_202209242359_f.zip,dpl_sap_xml_202209242359_d.zip,dpl_sap_xml_202209232359_f.zip,dpl_sap_xml_202209232359_d.zip,dpl_sap_xml_202209222359_f.zip,dpl_sap_xml_202209222359_d.zip,dpl_sap_xml_202209212359_f.zip,dpl_sap_xml_202209212359_d.zip,dpl_sap_xml_202209202359_f.zip,dpl_sap_xml_202209202359_d.zip,dpl_sap_xml_202209192359_f.zip,dpl_sap_xml_202209192359_d.zip,dpl_sap_xml_202209182359_f.zip,dpl_sap_xml_202209182359_d.zip,dpl_sap_xml_202209172359_f.zip,dpl_sap_xml_202209172359_d.zip,dpl_sap_xml_202209162359_f.zip,dpl_sap_xml_202209162359_d.zip,dpl_sap_xml_202209152359_f.zip,dpl_sap_xml_202209152359_d.zip,dpl_sap_xml_202209142359_f.zip,dpl_sap_xml_202209142359_d.zip,dpl_sap_xml_202209132359_f.zip,dpl_sap_xml_202209132359_d.zip,dpl_sap_xml_202209122359_f.zip,dpl_sap_xml_202209122359_d.zip,dpl_sap_xml_202209112359_f.zip,dpl_sap_xml_202209112359_d.zip,dpl_sap_xml_202209102359_f.zip,dpl_sap_xml_202209102359_d.zip,dpl_sap_xml_202209092359_f.zip,dpl_sap_xml_202209092359_d.zip,dpl_sap_xml_202209082359_f.zip,dpl_sap_xml_202209082359_d.zip,dpl_sap_xml_202209072359_f.zip,dpl_sap_xml_202209072359_d.zip,dpl_sap_xml_202209062359_f.zip,dpl_sap_xml_202209062359_d.zip,dpl_sap_xml_202209052359_f.zip,dpl_sap_xml_202209052359_d.zip,dpl_sap_xml_202209042359_f.zip,dpl_sap_xml_202209042359_d.zip,dpl_sap_xml_202209032359_f.zip,dpl_sap_xml_202209032359_d.zip,dpl_sap_xml_202209022359_f.zip,dpl_sap_xml_202209022359_d.zip,dpl_sap_xml_202209012359_f.zip,dpl_sap_xml_202209012359_d.zip,dpl_sap_xml_202208312359_f.zip,dpl_sap_xml_202208312359_d.zip,dpl_sap_xml_202208302359_f.zip,dpl_sap_xml_202208302359_d.zip,dpl_sap_xml_202208292359_f.zip,dpl_sap_xml_202208292359_d.zip,dpl_sap_xml_202208282359_f.zip,dpl_sap_xml_202208282359_d.zip,dpl_sap_xml_202208272359_f.zip,dpl_sap_xml_202208272359_d.zip,dpl_sap_xml_202208262359_f.zip,dpl_sap_xml_202208262359_d.zip,dpl_sap_xml_202208252359_f.zip,dpl_sap_xml_202208252359_d.zip,dpl_sap_xml_202208242359_f.zip,dpl_sap_xml_202208242359_d.zip,dpl_sap_xml_202208232359_f.zip,dpl_sap_xml_202208232359_d.zip,dpl_sap_xml_202208222359_f.zip,dpl_sap_xml_202208222359_d.zip,dpl_sap_xml_202208212359_f.zip,dpl_sap_xml_202208212359_d.zip,dpl_sap_xml_202208202359_f.zip,dpl_sap_xml_202208202359_d.zip</String>

	</SPL>

</ns1:MT_ECC_SplListResponse>

In the abap side the program is responsable to slipt name of file based on comma ', ' store what is FULL file and DELTA FILE.

Difference of full and delta is the name of file, contains f or contains d.



    • dpl_sap_xml_202210182359_f.zip

    • dpl_sap_xml_202210182359_d.zip







SAP PI Testing second interface:





The second interface contains the XML with name of file that should be download:



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

<ns0:MT_ECC_SplFileRequest xmlns:ns0="http://oerlikon.com/sap/ecc/IF_0056_SplList_Zip">

   <SPL_FILE>

      <Value>dpl_sap_xml_202210172359_f.zip</Value>

   </SPL_FILE>

</ns0:MT_ECC_SplFileRequest>




Testing:







Response:



Main Payload response.

 

I didn't add dynamic configuration because the abap contains the control of each file that has been request so the name of <Value>  or the attachment doesn't matter.
<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<ns1:MT_ECC_SplFileResponse

	xmlns:ns1="http://oerlikon.com/sap/ecc/IF_0056_SplList_Zip">

	<SPL_FILE>

		<Value>ZipAttachment.zip</Value>

	</SPL_FILE>

</ns1:MT_ECC_SplFileResponse>








Attachment with fix value name ZipAttachment.zip in the main payload response above with content-type - Application/zip






 

Conclusion:





This is a interface architecture, designer and development to integrate with DowJones to download files for rates that can be used for finance stream and others.

I hope you learn a new approach or design of interface and hope to see you in the next blog.

Cya,

 

Viana.

 
Labels in this area
Popular Blog Posts