I am trying to use xmldatadocument to load an xml file.The xml has the data
as attributes, the datadocument is able to successfully parse the document
into the tables and shows the right column count but does not add any rows. I
tried validating the schema everything is fine but no data is returned . I
have attached the sample xml file and schema. Any help is appreciated .
Thanks!
<SiebelMessage CallingApp="COM" ErrorMsg="" ErrorCode=""
ServiceType="Business Service" ServiceCall="GetASEnrollments" BusSrvName="HSN
Autoship Customization BS" BypassErrBusSrv="Y" CustomerNum="100546344"
ClicOwnedFlg="Y" />
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<!--W3C Schema generated by XMLSpy v2005 U (http://www.xmlspy.com)-->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
elementFormDefault="qualified">
<xs:element name="SiebelMessage">
<xs:complexType>
<xs:attribute name="CallingApp" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="ErrorMsg" type="xs:string" use="required"/>
<xs:attribute name="ErrorCode" type="xs:string" use="required"/>
<xs:attribute name="ServiceType" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="ServiceCall" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="BusSrvName" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="BypassErrBusSrv" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="CustomerNum" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="ClicOwnedFlg" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
</xs:schema>