topic Re: Using Web service with complex data types in Application Development and Automation Discussions

Using Web service with complex data types

Former Member — Tue, 31 Aug 2010 08:36:16 GMT

Hi All,

I have to access a SAP web service consuming a complex data type. Iu2019m using VBA in MS-Office.

Calling a web service with a simple type like String or long is not a problem. But I have to send a NodeList (MSXML2.IXMLDOMNodeList) to the service.

Here are the relevant parts out of the wsdl file:

<xsd:element name="SEARCH"><xsd:complexType><xsd:sequence>
<xsd:element name="CT_EQART_RANGE" type="tns:ZS_EQART_RANGE" minOccurs="0"></xsd:element>
</xsd:sequence>
...
<xsd:complexType name="ZS_EQART_RANGE">
	<xsd:sequence>
	  <xsd:element name="item" type="tns:ZS_EQART_RANGE_LINE" minOccurs="0" maxOccurs="unbounded"></xsd:element>
</xsd:sequence>
...
<xsd:complexType name="ZS_EQART_RANGE_LINE">
	<xsd:sequence>
		<xsd:element name="SIGN" type="tns:char1"></xsd:element>
		<xsd:element name="OPTION" type="tns:char2"></xsd:element>
</xsd:sequence>

Therefore I build a nodelist with one node containing following:

<CT_EQART_RANGE><item><SIGN>F</SIGN><OPTION>TT</OPTION></item></CT_EQART_RANGE>

When I call the service with this parameter I receive following error:

Client:Fehler bei der Typumwandlung für Element "CT_EQART_RANGE"

Translation: Type conversion error for element "CT_EQART_RANGE"

Please Help

Ron

Re: Using Web service with complex data types

mvoros — Tue, 31 Aug 2010 09:59:34 GMT

Hi,

it looks like type for SAP range but the fields LOW and HIGH are missing. For ranges you can have only I or E for sign and operators like EQ or BT for option. Have you tried with these values?

Cheers

Re: Using Web service with complex data types

Former Member — Tue, 31 Aug 2010 12:21:00 GMT

Yes, you right.

I removed this fields out of my question, because I didn't know that this is a SAP standard range.

But when this is a standard, do you have any code example on your side, to send such SAP range to a web service?

Thanks

Ron

Re: Using Web service with complex data types

Former Member — Mon, 06 Sep 2010 07:21:35 GMT

Please help me.

Can any body tell me how to send a SAP range to SAP using Web-Services?

Thanks

Ron

Re: Using Web service with complex data types

mvoros — Tue, 07 Sep 2010 00:24:15 GMT

Hi,

you can find how ranges work in ABAP [here|http://help.sap.com/saphelp_470/helpdata/en/9f/dba71f35c111d1829f0000e829fbfe/content.htm]. That tells you allowed values in each field. What's complete definition for type ZS_EQART_RANGE_LINE? You did not paste full definition.

Cheers

Re: Using Web service with complex data types

Former Member — Wed, 08 Sep 2010 06:32:07 GMT

Sorry,

I didn't know that this was necessary to find a solution.

Here are the definition out of the WSDL File:

<xsd:complexType name="ZS_EQART_RANGE_LINE">
	<xsd:sequence>
		<xsd:element name="SIGN" type="tns:char1"/>
		<xsd:element name="OPTION" type="tns:char2"/>
		<xsd:element name="LOW" type="tns:char10"/>
		<xsd:element name="HIGH" type="tns:char10"/>
	</xsd:sequence>
</xsd:complexType>

Thanks for Help

Ron

Re: Using Web service with complex data types

mvoros — Wed, 08 Sep 2010 06:41:41 GMT

Hi,

so I was right. It's a range. I already gave you a link which describes how ranges work in ABAP. What values do you want to pass to your web service?

Cheers

Re: Using Web service with complex data types

Former Member — Wed, 08 Sep 2010 12:42:54 GMT

I will send following values:

Sign="I"

Option="EQ"

Low="We100"

High=""

I'm still receiving the error message: Client:Fehler bei der Typumwandlung für Element "CT_EQART_RANGE"

Ron

Re: Using Web service with complex data types

mvoros — Wed, 08 Sep 2010 23:42:41 GMT

Hi,

it looks OK. Only one comment. The type EQART does not allow to have lower case characters. Have you tried with WE100?

Cheers