Skip to Content
0
Former Member
Sep 11, 2014 at 11:50 AM

Variable Substitution in Receiver File Channel

894 Views

Hi All,

Could you kindly help me with this?

Mine is File to File Scenario. ECC drops a XML file in AL11 directory and i send that file using FTP to a third party system. There is no mapping involved and i use ICO. I need to get a value from the payload dynamically for using it in my file name.

When i tried to use Variable Substitution Method i get this error : VariableDataSourceException: Caught SAXException while parsing XML payload: Content is not allowed in prolog.

This is the reference i have given in my variable substitution : payload:customerelement,1,customer,1,sender,1,dealercode,1

and my XML structure is as below and i am trying to access the dealercode field in the XML.

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

-<ns0:CustomerElement xmlns:ns0="http://www.xxxxxx.com/customer">

<recordCount>34</recordCount>

<Customer>

<Sender>

<transmitDate>ddmmyy</transmitDate>

<dealerCode>N050</dealerCode>

<DMSSystem>ABC</DMSSystem>

<DMSReleaseNumber>1.0</DMSReleaseNumber>

</Sender>