ApexERPHost

<back to all web services

CrmProductListQuery

Requires Authentication
The following routes are available for this service:
GET/Crm/Orders/Avaliable/Products/Query
CrmProductListQuery Parameters:
NameParameterData TypeRequiredDescription
BranchIdqueryint?No
OrderIdqueryint?No
CatIdqueryint?No
SupplierBranchIdqueryint?No
ContractIdqueryint?No
OrderTypequeryint?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
CrmProductList Parameters:
NameParameterData TypeRequiredDescription
prodpp_idformstringNo
prodppp_idformstringNo
bcodeformstringNo
bbcodeformstringNo
incodeformstringNo
category_idformstringNo
category_codeformstringNo
category_nuformstringNo
producer_idformstringNo
producer_nuformstringNo
prcountry_nuformstringNo
products_nuformstringNo
products_neformstringNo
vattypeformintNo
packcountformshortNo
packbcountformdecimal?No
unitformstringNo
mdtradeformdecimalNo
mdretailformdecimalNo
importedformbool?No
nettoformdecimalNo
vatformdecimalNo
spec_priceformdecimal?No
priceformdecimalNo
rcountformdecimalNo
sys_rcountformdecimalNo
rezervedformdecimalNo
costgformdecimal?No
buy_costgformdecimal?No
xformdouble?No
yformdouble?No
zformdouble?No
destnumberformstringNo
min_priceformdecimal?No
packccountformint?No
need_prepareformint?No
base_priceformdecimal?No
byweightformbyte?No
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.

GET /Crm/Orders/Avaliable/Products/Query HTTP/1.1 
Host: apex.nikoratrade.ge 
Accept: text/csv
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Offset":0,"Total":0,"Results":[{"prodpp_id":"String","prodppp_id":"String","bcode":"String","bbcode":"String","incode":"String","category_id":"String","category_code":"String","category_nu":"String","producer_id":"String","producer_nu":"String","prcountry_nu":"String","products_nu":"String","products_ne":"String","vattype":0,"packcount":0,"packbcount":0,"unit":"String","mdtrade":0,"mdretail":0,"imported":false,"netto":0,"vat":0,"spec_price":0,"price":0,"rcount":0,"sys_rcount":0,"rezerved":0,"costg":0,"buy_costg":0,"x":0,"y":0,"z":0,"destnumber":"String","min_price":0,"packccount":0,"need_prepare":0,"base_price":0,"byweight":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}