AVB LINQ Public API

<back to all web services

AvbSaleSearch

Avb Sales

This service allows you to search sales by a variety of parameters.

The following routes are available for this service:
GET, POST/avbsales/searchThe GET and POST methods of this service perform identically. Only one parameter is required though all may be used together.
AvbSaleSearch Parameters:
NameParameterData TypeRequiredDescription
IdsbodyList<long>No
StartDatebodyDateTime?No
EndDatebodyDateTime?No
SourcesbodyList<SaleSource>No
StartDateCreatedbodyDateTime?No
EndDateCreatedbodyDateTime?No
SaleSource Enum:
Undefined
LINQ
POS
Website
AvbSaleSearchResponse Parameters:
NameParameterData TypeRequiredDescription
ResponseStatusformResponseStatusNo
SalesformList<SaleModel>No
SaleModel Parameters:
NameParameterData TypeRequiredDescription
IdformlongNo
ExternalOrderNumberformstringNo
AvbIdformstringNo
SaleDateformDateTimeNo
CustomerNameformstringNo
CustomerPhoneformstringNo
CustomerEmailformstringNo
CustomerZipcodeformstringNo
SalesRepformstringNo
StoreLocationformstringNo
GrandTotalformdecimalNo
SubtotalformdecimalNo
DiscountformdecimalNo
MiscformdecimalNo
TaxformdecimalNo
ShippingformdecimalNo
SourceformSaleSourceNoSource is: 'LINQ','POS', or 'Website'
ShippingAddressLine1formstringNo
ShippingAddressLine2formstringNo
ShippingAddressCityformstringNo
ShippingAddressStateformstringNo
ShippingAddressZipformstringNo
ShippingMethodformstringNo
PaymentTypeformstringNo
CustomerIDformstringNo
DeliveredDateformDateTime?No
SaleItemsformList<SaleItemModel>No
CreatedDateformDateTimeNo
SaleItemModel Parameters:
NameParameterData TypeRequiredDescription
MfgSkuformstringYes
BrandformstringYes
SellerSkuformstringNo
NameformstringNo
ItemQtyformdecimalYes
ItemCostformdecimalNo

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

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

POST /avbsales/search HTTP/1.1 
Host: avb-pos.avbportal.com 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"ids":[0],"startDate":"0001-01-01T00:00:00.0000000","endDate":"0001-01-01T00:00:00.0000000","sources":["Undefined"],"startDateCreated":"0001-01-01T00:00:00.0000000","endDateCreated":"0001-01-01T00:00:00.0000000"}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}},"sales":[{"id":0,"externalOrderNumber":"String","avbId":"String","saleDate":"0001-01-01T00:00:00.0000000","customerName":"String","customerPhone":"String","customerEmail":"String","customerZipcode":"String","salesRep":"String","storeLocation":"String","grandTotal":0,"subtotal":0,"discount":0,"misc":0,"tax":0,"shipping":0,"source":"Undefined","shippingAddressLine1":"String","shippingAddressLine2":"String","shippingAddressCity":"String","shippingAddressState":"String","shippingAddressZip":"String","shippingMethod":"String","paymentType":"String","customerID":"String","deliveredDate":"0001-01-01T00:00:00.0000000","saleItems":[{"id":0,"sellerSku":"String","mfgSku":"String","name":"String","brand":"String","itemCost":0,"itemQty":0}],"createdDate":"0001-01-01T00:00:00.0000000"}]}