EMUN1 ASP.NET

QueryOrderTotals

The following routes are available for this service:
All Verbs	/service/QueryOrderTotals
All Verbs	/service/QueryOrderTotals/{Grouping}

**QueryOrderTotals** Parameters:
Name	Parameter	Data Type	Required
Grouping	path	string	No
GroupingLabel	query	string	No
Search	query	string	No
OrderNumber	query	string	No
DateRange	query	string	No
StartDate	query	string	No
EndDate	query	string	No
CustomerId	query	string	No
SalesRepId	query	string	No
ManagerId	query	string	No
Status	query	string	No
VendorId	query	string	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**OrderBase<TLine>** Parameters:
Name	Parameter	Data Type	Required	Description
Lines	form	List<TLine>	No

**OrderBase** Parameters:
Name	Parameter	Data Type	Required
Tags	form	Dictionary<string, HashSet<String>>	No
Id	form	string	No
OrderNumber	form	string	No
OriginalOrderNumber	form	string	No
RetailerId	form	string	No
ConsumerId	form	string	No
CustomerId	form	string	No
CompanyName	form	string	No
Status	form	string	No
ERPStatus	form	string	No
ManufacturerId	form	string	No
ReviewReason	form	string	No
TransactionType	form	string	No
SalesRepID	form	string	No
CurrentRepID	form	string	No
OrderDate	form	DateTime	No
ShipDate	form	DateTime	No
ExpectedToClear	form	DateTime	No
OpenItems	form	IEnumerable<OrderLine>	No
ShippedItems	form	IEnumerable<OrderLine>	No
OrderTotal	form	decimal	No
OpenTotal	form	decimal	No
ShippedTotal	form	decimal	No
Balance	form	decimal	No
ShippedAmount	form	decimal	No
Source	form	string	No
ClientVersion	form	string	No
IsEmunOrder	form	bool	No
ShippingMethdod	form	string	No
ShippingLocationAddress	form	string	No
ShippingLocationAddress2	form	string	No
ShippingLocationCity	form	string	No
ShippingLocationState	form	string	No
ShippingLocationZip	form	string	No
ShippingLocationCountry	form	string	No
ShippingLocationPhone	form	string	No
ShippingLocationName	form	string	No
BillAddress	form	string	No
BillAddress2	form	string	No
BillCity	form	string	No
BillState	form	string	No
BillZip	form	string	No
BillCountry	form	string	No
BillPhone	form	string	No
PaymentTerms	form	string	No
CreditCardType	form	string	No
CreditCardNumber	form	string	No
Custom11	form	string	No
Prefix	form	string	No
Parcels	form	List<Parcel>	No
ParcelCount	form	int	No
RetailerEmail	form	string	No
PONumber	form	string	No
Active	form	bool	No
Uploaded	form	bool	No
Exported	form	bool	No
NextFulfillment	form	string	No
Location	form	string	No
CustEmail	form	string	No
Meta	form	Dictionary<string, string>	No

**EntityBase<K>** Parameters:
Name	Parameter	Data Type	Required	Description
Id	form	K	No

**OrderLineBase** Parameters:
Name	Parameter	Data Type	Required
OrderNumber	form	string	No
Position	form	int	No
ProductId	form	string	No
Description	form	string	No
QtyPurchased	form	int	No
QtyOpen	form	int	No
Price	form	decimal	No
ExtendedTotal	form	decimal	No
PromoDiscount	form	decimal	No
Options	form	List<ILineOption>	No
Active	form	bool	No
XmlOptions	form	string	No
Cost	form	string	No
VendorId	form	string	No
CategoryId	form	string	No
ShipDate	form	DateTime?	No
Status	form	string	No

**ILineOption** Parameters:
Name	Parameter	Data Type	Required
FieldId	form	string	No
OrderNumber	form	string	No
Position	form	int	No
Upcharge	form	double	No
UpchargeType	form	string	No
ValueId	form	string	No

**Parcel** Parameters:
Name	Parameter	Data Type	Required
CartonNumber	form	string	No
OrderNumber	form	string	No
OrderStatus	form	string	No
OrderedOn	form	DateTime	No
InvoiceNumber	form	string	No
InvoicedOn	form	DateTime	No
ManufacturerId	form	string	No
ShippingMethod	form	string	No
TrackingNumber	form	string	No
TrackingUrl	form	string	No
Warehouse	form	string	No
PONumber	form	string	No
CartName	form	string	No
RetailerId	form	string	No
RetailerEmail	form	string	No
ShippingLocationId	form	string	No

**Result** Parameters:
Name	Parameter	Data Type	Required
Status	form	string	No
Reason	form	string	No
InputId	form	string	No
InputIndex	form	int	No
CityStates	form	CityEntry[]	No
ZipCodes	form	ZipCodeEntry[]	No

**CityEntry** Parameters:
Name	Parameter	Data Type	Required
City	form	string	No
MailableCity	form	bool	No
StateAbbreviation	form	string	No
State	form	string	No

**ZipCodeEntry** Parameters:
Name	Parameter	Data Type	Required
ZipCode	form	string	No
ZipCodeType	form	string	No
DefaultCity	form	string	No
CountyFips	form	string	No
CountyName	form	string	No
StateAbbreviation	form	string	No
State	form	string	No
Latitude	form	double	No
Longitude	form	double	No
Precision	form	string	No
AlternateCounties	form	AlternateCounty[]	No

**AlternateCounty** Parameters:
Name	Parameter	Data Type	Required
CountyFips	form	string	No
CountyName	form	string	No
StateAbbreviation	form	string	No
State	form	string	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /service/QueryOrderTotals HTTP/1.1 
Host: www.bernhardthospitality.com 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"grouping":"String","groupingLabel":"String","search":"String","orderNumber":"String","dateRange":"String","startDate":"String","endDate":"String","customerId":"String","salesRepId":"String","managerId":"String","status":"String","vendorId":"String","skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"offset":0,"total":0,"results":[{"label":"String","id":"String","count":0,"total":0}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}