flat XML in the WSDL

[Former Member]

hello

I am recieving in RFC2WS a WSDL. in the respone the WSDL look like this:

<s:element name="GetZagmshDataResponse">

<s:complexType>

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="GetZagmshDataResult">

<s:complexType mixed="true">

<s:sequence>

<s:any/>

</s:sequence>

</s:complexType>

</s:element>

</s:sequence>

</s:complexType>

</s:element>

in the Tag <any> I will recieve a full structure. for example:

<Table>

<DateID>3044</DateID>

<DateValue>2008-05-01T00:00:00+03:00</DateValue>

<OriginalEmployeeId>10000416</OriginalEmployeeId>

<OriginalReportDate>2008-05-01T00:00:00+03:00</OriginalReportDate>

<OriginalImportTime>2008-05-02T04:12:08.687+03:00</OriginalImportTime>

<OriginalDayType>5</OriginalDayType>

</Table>

<Table1>

<employName>kfir</employName>

<employLastName>gold</employLastName>

</Table1>

my Q is how can I map the inner data in the XML that I will recieve for this kind of WSDL so I will be able to recieve all the tables (could be multiple tables)?

Thanks

Kfir

[Former Member · Accepted solution]

To do this in the most effiecient way you would have to go with a Java Mapping.

Alternatively if you wanted to utilize the Graphical mapping you could do it using UDF's.

Eitherway I do not know of anyway to take a structure as youdescribe and mapping it directly using just graphical mapping.

I would efenitely say what ever you do, some Java will be necessary...

[Former Member · Accepted solution]

when you mean java, is to write a code that map each attribute in the XML to the RFC?

do you have a simple example of such a code?

[Former Member · Accepted solution]

HI unfortunately I don't have any example code at this second in time, but generally you would write the Java src code, compile it and import it as an imported archive into the integration repository.

Then in your interface mapping you simply select the mapping type - Java Class and then select your imported archive.

[prateek]

Two options:

1. Java mapping as suggested earlier

2. XSL mapping, where complete field data can be captured and then some operations can be performed

Regards,

Prateek

[Former Member]

how do I use the XSLT?

I never used it before in the XI, help with an exampe will be appreiceated?

[prateek]

See if this helps

Regards,

Prateek

[Former Member]

Refer these links for XSLT mapping:

Regards,

Geetha.