ApexERPHost

<back to all web services

QueryProdViewAnd

Requires Authentication
The following routes are available for this service:
GET/Common/Dictionary/Goods/QueryAnd
QueryProdViewAnd Parameters:
NameParameterData TypeRequiredDescription
BCodeContainsquerystringNo
ProductsNuContainsquerystringNo
ProducerIdEqualsquerystringNo
CategoryIdEqualsquerystringNo
PCatIdEqualsqueryint?No
PPCatIdEqualsquerystringNo
Spendquerybool?No
groupidqueryintNo
SuplierAccquerystringNo
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
ProductQuery Parameters:
NameParameterData TypeRequiredDescription
ProdPPIdformstringNo
BCodeformstringNo
BBCodeformstringNo
InCodeformstringNo
CategoryCodeformstringNo
ProducerIdformstringNo
CategoryIdformstringNo
ProductsNuformstringNo
ProductsNeformstringNo
DestNumberformstringNo
PPCatIdformstringNo
PCatIdformint?No
ProducerNuformstringNo
CategoryNuformstringNo
VatformdecimalNo
ByWeightformintNo
PackCountformshortNo
PackBCountformdecimal?No
UnitformstringNo
MDTradeformdecimalNo
MDRetailformdecimalNo
Importedformbool?No
PrCountryNuformstringNo
NettoformdecimalNo
CapacityformdecimalNo
PriceGRformdecimalNo
PriceGTformdecimalNo
PDoseformstringNo
PriceURformdecimalNo
PriceUTformdecimalNo
LifeDateformint?No
MinCountTradeformint?No
MinCountRetailformint?No
Spendformbool?No
LNotInPriceformbool?No
Lownformbool?No
Products_idformstringNo
PackCCountformintNo
BruttoformdecimalNo
IsLinkedformboolNo
ReCalcformbool?No
SupDaysformintNo
VatTypeformintNo
ExciseIDformintNo
ExciseformdecimalNo
ProdPPPIdformstringNo
IntCodeIdformstringNo
PPCatNuformstringNo
SpecificformboolNo
PackTypeIDformint?No
ExciseCformdecimal?No
UnitIdformint?No
CBCodeformstringNo
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 .x-protobuf suffix or ?format=x-protobuf

HTTP + X-PROTOBUF

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

GET /Common/Dictionary/Goods/QueryAnd HTTP/1.1 
Host: apex.nikoratrade.ge 
Accept: application/x-protobuf
HTTP/1.1 200 OK
Content-Type: application/x-protobuf
Content-Length: length

{"Offset":0,"Total":0,"Results":[{"ProdPPId":"String","BCode":"String","BBCode":"String","InCode":"String","CategoryCode":"String","ProducerId":"String","CategoryId":"String","ProductsNu":"String","ProductsNe":"String","DestNumber":"String","PPCatId":"String","PCatId":0,"ProducerNu":"String","CategoryNu":"String","Vat":0,"ByWeight":0,"PackCount":0,"PackBCount":0,"Unit":"String","MDTrade":0,"MDRetail":0,"Imported":false,"PrCountryNu":"String","Netto":0,"Capacity":0,"PriceGR":0,"PriceGT":0,"PDose":"String","PriceUR":0,"PriceUT":0,"LifeDate":0,"MinCountTrade":0,"MinCountRetail":0,"Spend":false,"LNotInPrice":false,"Lown":false,"Products_id":"String","PackCCount":0,"Brutto":0,"IsLinked":false,"ReCalc":false,"SupDays":0,"VatType":0,"ExciseID":0,"Excise":0,"ProdPPPId":"String","IntCodeId":"String","PPCatNu":"String","Specific":false,"PackTypeID":0,"ExciseC":0,"UnitId":0,"CBCode":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}