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
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 .jsv suffix or ?format=jsv

HTTP + JSV

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/jsv
HTTP/1.1 200 OK
Content-Type: text/jsv
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,
			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
		}
	}
}