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!!