EMUN1 ASP.NET

<back to all web services

QueryInvoiceLines

The following routes are available for this service:
All Verbs/service/QueryInvoiceLines
QueryInvoiceLines Parameters:
NameParameterData TypeRequiredDescription
SearchquerystringNo
InvoiceNumberquerystringNo
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
InvoiceLineBase Parameters:
NameParameterData TypeRequiredDescription
InvoiceNumberformstringNo
PositionformintNo
ProductIdformstringNo
ProductformProductNo
DescriptionformstringNo
QtyOrderedformintNo
QtyShippedformintNo
QtyBackorderedformintNo
PriceformdecimalNo
ListPriceformdecimalNo
NotesformstringNo
UOMformstringNo
VendorIdformstringNo
LineTotalformdecimalNo
ExtendedTotalformdecimalNo
MetaformDictionary<string, string>No
Product Parameters:
NameParameterData TypeRequiredDescription
IdformstringNo
ProductLineIdformstringNo
ManufacturerNumberformstringNo
ShortDescriptionformstringNo
LongDescriptionformstringNo
AltDescriptionformstringNo
UpcCodeformstringNo
StatusformstringNo
PricingformIDictionary<int, double>No
ListPriceformdecimalNo
WholesalePriceformdecimalNo
RetailPriceformdecimal?No
RetailListPriceformdecimalNo
UnitsInStockformintNo
CategoryIdformstringNo
MinimumOrderQtyformdoubleNo
AvailableQtyformdoubleNo
AvailableOnformDateTime?No
IncomingQtyformdoubleNo
PurchaseIncrementformdoubleNo
OptionGroupformstringNo
OptionGroupListformstringNo
VendorIdformstringNo
ItemTypeformstringNo
ImageUrlformstringNo
OnDemandProductEuidformstringNo
KeywordsformstringNo
SuperCategoryformstringNo
IsNewformboolNo
IsRestrictedformboolNo
CreatedOnformDateTimeNo
WeightformdoubleNo
HeightformdecimalNo
LengthformdecimalNo
CubicVolumeformdoubleNo
CostformdecimalNo
UOMformstringNo
SubCategoryformstringNo
ShipOnformDateTime?No
FeaturedformintNo
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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/QueryInvoiceLines HTTP/1.1 
Host: www.bernhardthospitality.com 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"search":"String","invoiceNumber":"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":[{"invoiceNumber":"String","position":0,"productId":"String","product":{"id":"String","productLineId":"String","manufacturerNumber":"String","shortDescription":"String","longDescription":"String","altDescription":"String","upcCode":"String","status":"String","listPrice":0,"wholesalePrice":0,"retailPrice":0,"retailListPrice":0,"unitsInStock":0,"categoryId":"String","minimumOrderQty":0,"availableQty":0,"availableOn":"0001-01-01T00:00:00.0000000Z","incomingQty":0,"purchaseIncrement":0,"optionGroup":"String","optionGroupList":"String","vendorId":"String","itemType":"String","imageUrl":"String","onDemandProductEuid":"String","keywords":"String","superCategory":"String","isNew":false,"isRestricted":false,"createdOn":"0001-01-01T00:00:00.0000000Z","weight":0,"height":0,"length":0,"cubicVolume":0,"cost":0,"uom":"String","subCategory":"String","shipOn":"0001-01-01T00:00:00.0000000Z","featured":0},"description":"String","qtyOrdered":0,"qtyShipped":0,"qtyBackordered":0,"price":0,"listPrice":0,"notes":"String","uom":"String","vendorId":"String","lineTotal":0,"extendedTotal":0,"meta":{"String":"String"}}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}