Skip to Content
0
Former Member
Sep 09, 2014 at 03:19 PM

Can you associate an XML Schema with a DataWindow?

115 Views

Greetings all,

We have a client that has asked for datathat has master/detail information in XML format. They are also asking for the XML to be associated with an XML Schema that they have provided to ensure that the data is validated using the Schema.

I am pretty sure I can make the XML look most like the way they want it, but not sure about how to make it exactly the way they want it.

<Invoice xsi:noNamespaceSchemaLocation="AlexFeed.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Vendor><VendorId>9</VendorId><TotalRides>4</TotalRides><TotalAmount>1038.54</TotalAmount><BillingCurrency>USD</BillingCurrency>


Ride><BookerEmployeeID>21416</BookerEmployeeID><BookerTieExtension>8054305</BookerTieExtension><BookerFirstName>PAUL</BookerFirstName><BookerLastName>GOYENECHE</BookerLastName><RiderFirstName>AINHOA</RiderFirstName><RiderLastName>MURRAY</RiderLastName><ReferenceId>1401745691</ReferenceId><CarId>999</CarId><RideTypeId>B</RideTypeId><AirportCode>IAD</AirportCode><RideDate>2014-08-04</RideDate><RideTime>15:35:00.0Z</RideTime><FromAddress>IAD</FromAddress><FromZone>IAD</FromZone><ToAddress>DC, WASHINGTON</ToAddress><ToZone>IAD </ToZone><NoShow>false</NoShow><BaseAmount>108.58</BaseAmount><ServiceAmount>19.20</ServiceAmount><WaitAmount>71.78</WaitAmount><MeetAndGreetAmount>10.00</MeetAndGreetAmount><ParkingAmount>10.00</ParkingAmount><FuelSurchargeAmount>2.00</FuelSurchargeAmount><MiscAmount>36.07</MiscAmount><MiscAmountDesc>Tips,Package and Miscellaneous charge</MiscAmountDesc><NetAmount>257.63</NetAmount><TotalAmount>257.63</TotalAmount></Ride>

Thanks everyone in advance for any pointers!!

Best,

Paul