XMII Web Service response

[Former Member]

I'm confused on the differences I see when I call a transaction via a URL vs calling it as a web service. The client is having trouble interpreting what is coming back from the WS, due to the namespaces being returned.

Example of data returned via browser:

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

- <Rowsets DateCreated="2011-06-08T13:01:49" EndDate="2011-06-08T12:48:45" StartDate="2011-06-08T12:48:45" Version="12.1.5 Build(77)">

- <Rowset>

- <Columns>

<Column Description="" MaxRange="1" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime" />

<Column Description="" MaxRange="1" MinRange="0" Name="Line1Speed" SQLDataType="8" SourceColumn="Line1Speed" />

<Column Description="" MaxRange="1" MinRange="0" Name="Line2Speed" SQLDataType="8" SourceColumn="Line2Speed" />

<Column Description="" MaxRange="1" MinRange="0" Name="Line3Speed" SQLDataType="8" SourceColumn="Line3Speed" />

<Column Description="" MaxRange="1" MinRange="0" Name="Line4Speed" SQLDataType="8" SourceColumn="Line4Speed" />

</Columns>

- <Row>

<DateTime>2011-06-08T12:01:49</DateTime>

<Line1Speed>93.39574182475</Line1Speed>

<Line2Speed>85.023773778079</Line2Speed>

<Line3Speed>94.096715415732</Line3Speed>

<Line4Speed>81.366097323801</Line4Speed>

</Row>

Example of data returned via web service:

<?xml version="1.0" encoding="utf-16" ?>

- <Rowset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

- <Row xmlns="http://www.sap.com/xMII">

<DateTime>2011-06-08T11:42:36</DateTime>

<Line1Speed>89.835546913406</Line1Speed>

<Line2Speed>89.107159866658</Line2Speed>

<Line3Speed>90.071118406832</Line3Speed>

<Line4Speed>85.787907202837</Line4Speed>

</Row>

I don't understand why this output has the namespace in the <Rowset> and <Row> nodes.

Such as

<Row xmlns="http://www.sap.com/xMII">

Thanks in advance for any help.

John

[Former Member]

Hi John,

View the link below for more details about this first output XML. Is XML default SAP XMII for any query.

http://help.sap.com/saphelp_xmii115/helpdata/en/Business_Logic_Services/illuminator_xml_format.htm

when you calling via WSDL a trx your output is different, but you can configure the output.

Hope this help.

Danilo Santos