{"@odata.context":"https://demodata.mescius.io/northwind/odata/v1/$metadata#Customers(Orders(OrderDetails(),Shipper()))","value":[{"CustomerId":"ALFKI","CompanyName":"Alfreds Futterkiste","ContactName":"Maria Anders","ContactTitle":"Sales Representative","Address":"Obere Str. 57","City":"Berlin","Region":null,"PostalCode":"12209","Country":"Germany","Phone":"030-0074321","Fax":"030-0076545","Orders":[{"OrderId":10643,"CustomerId":"ALFKI","EmployeeId":6,"OrderDate":"1997-08-25","RequiredDate":"1997-09-22","ShippedDate":"1997-09-02","ShipVia":1,"Freight":29.4600,"ShipName":"Alfreds Futterkiste","ShipAddress":"Obere Str. 57","ShipCity":"Berlin","ShipRegion":null,"ShipPostalCode":"12209","ShipCountry":"Germany","OrderDetails":[{"OrderId":10643,"ProductId":28,"UnitPrice":45.6000,"Quantity":15,"Discount":0.25},{"OrderId":10643,"ProductId":39,"UnitPrice":18.0000,"Quantity":21,"Discount":0.25},{"OrderId":10643,"ProductId":46,"UnitPrice":12.0000,"Quantity":2,"Discount":0.25}],"Shipper":{"ShipperId":1,"CompanyName":"Speedy Express","Phone":"(503) 555-9831"}},{"OrderId":10692,"CustomerId":"ALFKI","EmployeeId":4,"OrderDate":"1997-10-03","RequiredDate":"1997-10-31","ShippedDate":"1997-10-13","ShipVia":2,"Freight":61.0200,"ShipName":"Alfred's Futterkiste","ShipAddress":"Obere Str. 57","ShipCity":"Berlin","ShipRegion":null,"ShipPostalCode":"12209","ShipCountry":"Germany","OrderDetails":[{"OrderId":10692,"ProductId":63,"UnitPrice":43.9000,"Quantity":20,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"United Package","Phone":"(503) 555-3199"}},{"OrderId":10702,"CustomerId":"ALFKI","EmployeeId":4,"OrderDate":"1997-10-13","RequiredDate":"1997-11-24","ShippedDate":"1997-10-21","ShipVia":1,"Freight":23.9400,"ShipName":"Alfred's Futterkiste","ShipAddress":"Obere Str. 57","ShipCity":"Berlin","ShipRegion":null,"ShipPostalCode":"12209","ShipCountry":"Germany","OrderDetails":[{"OrderId":10702,"ProductId":3,"UnitPrice":10.0000,"Quantity":6,"Discount":0},{"OrderId":10702,"ProductId":76,"UnitPrice":18.0000,"Quantity":15,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"Speedy Express","Phone":"(503) 555-9831"}},{"OrderId":10835,"CustomerId":"ALFKI","EmployeeId":1,"OrderDate":"1998-01-15","RequiredDate":"1998-02-12","ShippedDate":"1998-01-21","ShipVia":3,"Freight":69.5300,"ShipName":"Alfred's Futterkiste","ShipAddress":"Obere Str. 57","ShipCity":"Berlin","ShipRegion":null,"ShipPostalCode":"12209","ShipCountry":"Germany","OrderDetails":[{"OrderId":10835,"ProductId":59,"UnitPrice":55.0000,"Quantity":15,"Discount":0},{"OrderId":10835,"ProductId":77,"UnitPrice":13.0000,"Quantity":2,"Discount":0.2}],"Shipper":{"ShipperId":3,"CompanyName":"Federal Shipping","Phone":"(503) 555-9931"}},{"OrderId":10952,"CustomerId":"ALFKI","EmployeeId":1,"OrderDate":"1998-03-16","RequiredDate":"1998-04-27","ShippedDate":"1998-03-24","ShipVia":1,"Freight":40.4200,"ShipName":"Alfred's Futterkiste","ShipAddress":"Obere Str. 57","ShipCity":"Berlin","ShipRegion":null,"ShipPostalCode":"12209","ShipCountry":"Germany","OrderDetails":[{"OrderId":10952,"ProductId":6,"UnitPrice":25.0000,"Quantity":16,"Discount":0.05},{"OrderId":10952,"ProductId":28,"UnitPrice":45.6000,"Quantity":2,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"Speedy Express","Phone":"(503) 555-9831"}},{"OrderId":11011,"CustomerId":"ALFKI","EmployeeId":3,"OrderDate":"1998-04-09","RequiredDate":"1998-05-07","ShippedDate":"1998-04-13","ShipVia":1,"Freight":1.2100,"ShipName":"Alfred's Futterkiste","ShipAddress":"Obere Str. 57","ShipCity":"Berlin","ShipRegion":null,"ShipPostalCode":"12209","ShipCountry":"Germany","OrderDetails":[{"OrderId":11011,"ProductId":58,"UnitPrice":13.2500,"Quantity":40,"Discount":0.05},{"OrderId":11011,"ProductId":71,"UnitPrice":21.5000,"Quantity":20,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"Speedy Express","Phone":"(503) 555-9831"}}]},{"CustomerId":"ANATR","CompanyName":"Ana Trujillo Emparedados y helados","ContactName":"Ana Trujillo","ContactTitle":"Owner","Address":"Avda. de la Constituci\u00f3n 2222","City":"M\u00e9xico D.F.","Region":null,"PostalCode":"05021","Country":"Mexico","Phone":"(5) 555-4729","Fax":"(5) 555-3745","Orders":[{"OrderId":10308,"CustomerId":"ANATR","EmployeeId":7,"OrderDate":"1996-09-18","RequiredDate":"1996-10-16","ShippedDate":"1996-09-24","ShipVia":3,"Freight":1.6100,"ShipName":"Ana Trujillo Emparedados y helados","ShipAddress":"Avda. de la Constituci\u00f3n 2222","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05021","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10308,"ProductId":69,"UnitPrice":28.8000,"Quantity":1,"Discount":0},{"OrderId":10308,"ProductId":70,"UnitPrice":12.0000,"Quantity":5,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"Federal Shipping","Phone":"(503) 555-9931"}},{"OrderId":10625,"CustomerId":"ANATR","EmployeeId":3,"OrderDate":"1997-08-08","RequiredDate":"1997-09-05","ShippedDate":"1997-08-14","ShipVia":1,"Freight":43.9000,"ShipName":"Ana Trujillo Emparedados y helados","ShipAddress":"Avda. de la Constituci\u00f3n 2222","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05021","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10625,"ProductId":14,"UnitPrice":23.2500,"Quantity":3,"Discount":0},{"OrderId":10625,"ProductId":42,"UnitPrice":14.0000,"Quantity":5,"Discount":0},{"OrderId":10625,"ProductId":60,"UnitPrice":34.0000,"Quantity":10,"Discount":0}],"Shipper":{"ShipperId":1,"CompanyName":"Speedy Express","Phone":"(503) 555-9831"}},{"OrderId":10759,"CustomerId":"ANATR","EmployeeId":3,"OrderDate":"1997-11-28","RequiredDate":"1997-12-26","ShippedDate":"1997-12-12","ShipVia":3,"Freight":11.9900,"ShipName":"Ana Trujillo Emparedados y helados","ShipAddress":"Avda. de la Constituci\u00f3n 2222","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05021","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10759,"ProductId":32,"UnitPrice":32.0000,"Quantity":10,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"Federal Shipping","Phone":"(503) 555-9931"}},{"OrderId":10926,"CustomerId":"ANATR","EmployeeId":4,"OrderDate":"1998-03-04","RequiredDate":"1998-04-01","ShippedDate":"1998-03-11","ShipVia":3,"Freight":39.9200,"ShipName":"Ana Trujillo Emparedados y helados","ShipAddress":"Avda. de la Constituci\u00f3n 2222","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05021","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10926,"ProductId":11,"UnitPrice":21.0000,"Quantity":2,"Discount":0},{"OrderId":10926,"ProductId":13,"UnitPrice":6.0000,"Quantity":10,"Discount":0},{"OrderId":10926,"ProductId":19,"UnitPrice":9.2000,"Quantity":7,"Discount":0},{"OrderId":10926,"ProductId":72,"UnitPrice":34.8000,"Quantity":10,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"Federal Shipping","Phone":"(503) 555-9931"}}]},{"CustomerId":"ANTON","CompanyName":"Antonio Moreno Taquer\u00eda","ContactName":"Antonio Moreno","ContactTitle":"Owner","Address":"Mataderos  2312","City":"M\u00e9xico D.F.","Region":null,"PostalCode":"05023","Country":"Mexico","Phone":"(5) 555-3932","Fax":null,"Orders":[{"OrderId":10365,"CustomerId":"ANTON","EmployeeId":3,"OrderDate":"1996-11-27","RequiredDate":"1996-12-25","ShippedDate":"1996-12-02","ShipVia":2,"Freight":22.0000,"ShipName":"Antonio Moreno Taquer\u00eda","ShipAddress":"Mataderos  2312","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05023","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10365,"ProductId":11,"UnitPrice":16.8000,"Quantity":24,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"United Package","Phone":"(503) 555-3199"}},{"OrderId":10507,"CustomerId":"ANTON","EmployeeId":7,"OrderDate":"1997-04-15","RequiredDate":"1997-05-13","ShippedDate":"1997-04-22","ShipVia":1,"Freight":47.4500,"ShipName":"Antonio Moreno Taquer\u00eda","ShipAddress":"Mataderos  2312","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05023","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10507,"ProductId":43,"UnitPrice":46.0000,"Quantity":15,"Discount":0.15},{"OrderId":10507,"ProductId":48,"UnitPrice":12.7500,"Quantity":15,"Discount":0.15}],"Shipper":{"ShipperId":1,"CompanyName":"Speedy Express","Phone":"(503) 555-9831"}},{"OrderId":10535,"CustomerId":"ANTON","EmployeeId":4,"OrderDate":"1997-05-13","RequiredDate":"1997-06-10","ShippedDate":"1997-05-21","ShipVia":1,"Freight":15.6400,"ShipName":"Antonio Moreno Taquer\u00eda","ShipAddress":"Mataderos  2312","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05023","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10535,"ProductId":11,"UnitPrice":21.0000,"Quantity":50,"Discount":0.1},{"OrderId":10535,"ProductId":40,"UnitPrice":18.4000,"Quantity":10,"Discount":0.1},{"OrderId":10535,"ProductId":57,"UnitPrice":19.5000,"Quantity":5,"Discount":0.1},{"OrderId":10535,"ProductId":59,"UnitPrice":55.0000,"Quantity":15,"Discount":0.1}],"Shipper":{"ShipperId":1,"CompanyName":"Speedy Express","Phone":"(503) 555-9831"}},{"OrderId":10573,"CustomerId":"ANTON","EmployeeId":7,"OrderDate":"1997-06-19","RequiredDate":"1997-07-17","ShippedDate":"1997-06-20","ShipVia":3,"Freight":84.8400,"ShipName":"Antonio Moreno Taquer\u00eda","ShipAddress":"Mataderos  2312","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05023","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10573,"ProductId":17,"UnitPrice":39.0000,"Quantity":18,"Discount":0},{"OrderId":10573,"ProductId":34,"UnitPrice":14.0000,"Quantity":40,"Discount":0},{"OrderId":10573,"ProductId":53,"UnitPrice":32.8000,"Quantity":25,"Discount":0}],"Shipper":{"ShipperId":3,"CompanyName":"Federal Shipping","Phone":"(503) 555-9931"}},{"OrderId":10677,"CustomerId":"ANTON","EmployeeId":1,"OrderDate":"1997-09-22","RequiredDate":"1997-10-20","ShippedDate":"1997-09-26","ShipVia":3,"Freight":4.0300,"ShipName":"Antonio Moreno Taquer\u00eda","ShipAddress":"Mataderos  2312","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05023","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10677,"ProductId":26,"UnitPrice":31.2300,"Quantity":30,"Discount":0.15},{"OrderId":10677,"ProductId":33,"UnitPrice":2.5000,"Quantity":8,"Discount":0.15}],"Shipper":{"ShipperId":3,"CompanyName":"Federal Shipping","Phone":"(503) 555-9931"}},{"OrderId":10682,"CustomerId":"ANTON","EmployeeId":3,"OrderDate":"1997-09-25","RequiredDate":"1997-10-23","ShippedDate":"1997-10-01","ShipVia":2,"Freight":36.1300,"ShipName":"Antonio Moreno Taquer\u00eda","ShipAddress":"Mataderos  2312","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05023","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10682,"ProductId":33,"UnitPrice":2.5000,"Quantity":30,"Discount":0},{"OrderId":10682,"ProductId":66,"UnitPrice":17.0000,"Quantity":4,"Discount":0},{"OrderId":10682,"ProductId":75,"UnitPrice":7.7500,"Quantity":30,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"United Package","Phone":"(503) 555-3199"}},{"OrderId":10856,"CustomerId":"ANTON","EmployeeId":3,"OrderDate":"1998-01-28","RequiredDate":"1998-02-25","ShippedDate":"1998-02-10","ShipVia":2,"Freight":58.4300,"ShipName":"Antonio Moreno Taquer\u00eda","ShipAddress":"Mataderos  2312","ShipCity":"M\u00e9xico D.F.","ShipRegion":null,"ShipPostalCode":"05023","ShipCountry":"Mexico","OrderDetails":[{"OrderId":10856,"ProductId":2,"UnitPrice":19.0000,"Quantity":20,"Discount":0},{"OrderId":10856,"ProductId":42,"UnitPrice":14.0000,"Quantity":20,"Discount":0}],"Shipper":{"ShipperId":2,"CompanyName":"United Package","Phone":"(503) 555-3199"}}]}]}