Skip to Content
avatar image
Former Member

Mapping XML to RFC - Complexe Mapping

Hello Gurus.

I have an XML file coming from a partner with this structure.

I want to make the mapping from the XML to the RFC Function like this :

  XML File receive

<?xml version="1.0" encoding="windows-1252"?>
<APLList gln="1234567890123">
<APL code="A" type="N">
<client gln="1"/>
<client gln="2"/>
<client gln="3"/>
<client gln="4"/>
<client gln="5"/>
</APL>
<APL code="B" type="T">
<client gln="6"/>
<client gln="7"/>
<client gln="8"/>
<client gln="9"/>
</APL>

Data to send to RFC

APL CLIEU    TYPAPL
A     1             N
A     2             N
A     3             N
A     4             N
A     5             N
B      6             T
B      7             T
B      8             T
B      9             T

Is someone can help me for this mapping ?

Thanks and regards.

JC

pi.jpg (42.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 22, 2012 at 03:15 PM

    Hi Jean,

    I could see that your input XML has code, type and gln as attributes, however your screenshot for input structure shows you are using elements of type xsd:string. you have to check on this.

    Then for mapping part, you can map target item node with source <APL>, then for target fields APL and TYPAPL you have to get values from source code and type then by using useOneAsMany function you should be able to achieve your RFC output. for target field CLIEU, you can directly map source client gln.

    Regards,

    Zameer

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Zameer,

      You are right, my XML definition was a little bit wrong 😔  I have change it and you can see it in the attachment.

      But I'm a little bit lost with the useOneAsMany.

      For the first parameter, I think it's @code for the APL, and @type for the TYPAPL

      For the third parameter, I think it's @gln

      But I don't know what I have to put to the second parameter.

      Could you help me ?

      Thanks and regards

      JC

      pi 2.jpg (48.3 kB)