Scenario: Validating data flows against an XSD file

This scenario describes a Job that validates an XML column in the input file ShipOrder.csv against the XSD reference file ShipOrder.xsd and then outputs valid rows into the delimited
file ShipOrder_Valid.csv and invalid rows and error
messages into the delimited file ShipOrder_Invalid.csv.
For a similar use case that validates an XML file, see Validating XML files.

The content of the input file ShipOrder.csv that
includes the XML column ShipOrder to be validated is as
follows:

ID;ShipOrder
000001;&lt;shiporder orderid="000001"&gt;&lt;orderperson&gt;George Bush&lt;/orderperson&gt;&lt;shipto&gt;&lt;name&gt;John Adams&lt;/name&gt;&lt;address&gt;Oxford Street&lt;/address&gt;&lt;/shipto&gt;&lt;item&gt;&lt;title&gt;Empire Burlesque&lt;/title&gt;&lt;note&gt;Special Edition&lt;/note&gt;&lt;quantity&gt;1&lt;/quantity&gt;&lt;price&gt;10.90&lt;/price&gt;&lt;/item&gt;&lt;/shiporder&gt;
000002;&lt;shiporder orderid="000002"&gt;&lt;orderperson&gt;Judy Liu&lt;/orderperson&gt;&lt;shipto&gt;&lt;name&gt;Jack Liu&lt;/name&gt;&lt;address&gt;Wangfujing Street&lt;/address&gt;&lt;/shipto&gt;&lt;item&gt;&lt;title&gt;Hide Your Heart&lt;/title&gt;&lt;quantity&gt;1&lt;/quantity&gt;&lt;price&gt;9.90&lt;/price&gt;&lt;/item&gt;&lt;/shiporder&gt;
000003;&lt;shiporder&gt;&lt;orderperson&gt;Peter Qian&lt;/orderperson&gt;&lt;shipto&gt;&lt;name&gt;Thomas Wang&lt;/name&gt;&lt;address&gt;Wangfujing Street&lt;/address&gt;&lt;/shipto&gt;&lt;item&gt;&lt;title&gt;The Power of Habit&lt;/title&gt;&lt;quantity&gt;1&lt;/quantity&gt;&lt;price&gt;8.99&lt;/price&gt;&lt;/item&gt;&lt;/shiporder&gt;

ID;ShipOrder

000001;<shiporder orderid="000001"><orderperson>George Bush</orderperson><shipto><name>John Adams</name><address>Oxford Street</address></shipto><item><title>Empire Burlesque</title><note>Special Edition</note><quantity>1</quantity><price>10.90</price></item></shiporder>

000002;<shiporder orderid="000002"><orderperson>Judy Liu</orderperson><shipto><name>Jack Liu</name><address>Wangfujing Street</address></shipto><item><title>Hide Your Heart</title><quantity>1</quantity><price>9.90</price></item></shiporder>

000003;<shiporder><orderperson>Peter Qian</orderperson><shipto><name>Thomas Wang</name><address>Wangfujing Street</address></shipto><item><title>The Power of Habit</title><quantity>1</quantity><price>8.99</price></item></shiporder>

The content of the XSD reference file ShipOrder.xsd is
as follows:

&lt;?xml version="1.0" encoding="ISO-8859-1" ?&gt;
&lt;xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"&gt;
 &lt;xs:element name="shiporder"&gt;
  &lt;xs:complexType&gt;
   &lt;xs:sequence&gt;
    &lt;xs:element name="orderperson" type="xs:string"/&gt;
    &lt;xs:element name="shipto"&gt;
     &lt;xs:complexType&gt;
      &lt;xs:sequence&gt;
       &lt;xs:element name="name" type="xs:string"/&gt;
       &lt;xs:element name="address" type="xs:string"/&gt;
      &lt;/xs:sequence&gt;
     &lt;/xs:complexType&gt;
    &lt;/xs:element&gt;
    &lt;xs:element name="item" maxOccurs="unbounded"&gt;
     &lt;xs:complexType&gt;
      &lt;xs:sequence&gt;
       &lt;xs:element name="title" type="xs:string"/&gt;
       &lt;xs:element name="note" type="xs:string" minOccurs="0"/&gt;
       &lt;xs:element name="quantity" type="xs:positiveInteger"/&gt;
       &lt;xs:element name="price" type="xs:decimal"/&gt;
      &lt;/xs:sequence&gt;
     &lt;/xs:complexType&gt;
    &lt;/xs:element&gt;
   &lt;/xs:sequence&gt;
   &lt;xs:attribute name="orderid" type="xs:string" use="required"/&gt;
  &lt;/xs:complexType&gt;
 &lt;/xs:element&gt;
&lt;/xs:schema&gt;

<?xml version="1.0" encoding="ISO-8859-1" ?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="shiporder">

<xs:complexType>

<xs:sequence>

<xs:element name="orderperson" type="xs:string"/>

<xs:element name="shipto">

<xs:complexType>

<xs:sequence>

<xs:element name="name" type="xs:string"/>

<xs:element name="address" type="xs:string"/>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="item" maxOccurs="unbounded">

<xs:complexType>

<xs:sequence>

<xs:element name="title" type="xs:string"/>

<xs:element name="note" type="xs:string" minOccurs="0"/>

<xs:element name="quantity" type="xs:positiveInteger"/>

<xs:element name="price" type="xs:decimal"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

<xs:attribute name="orderid" type="xs:string" use="required"/>

</xs:complexType>

</xs:element>

</xs:schema>

Document get from Talend https://help.talend.com

Thank you for watching.

Docs 6.x

0 Comments

Inline Feedbacks

View all comments

Scenario: Validating data flows against an XSD file – Docs for ESB 6.x

Scenario: Validating data flows against an XSD file

My Website Links

Tags