ApexERPHost

BooksTestQuery

The following routes are available for this service:
GET	/Accounting/BooksTestQuery

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**BookTEST** Parameters:
Name	Parameter	Data Type	Required
Book_id	form	string	No
DocsPr_id	form	string	No
Docs_id	form	string	No
OpDet_id	form	string	No
Currency_Id	form	string	No
dDate	form	DateTime	No
db	form	string	No
cr	form	string	No
vg	form	decimal?	No
vu	form	decimal?	No
vc	form	decimal?	No
Contents	form	string	No
Rate	form	decimal	No
NumberIn	form	string	No
NumberOut	form	string	No
BookNote	form	string	No
RecStatus	form	byte?	No
Blocking	form	bool?	No
cUser	form	string	No
PLDb	form	int?	No
PLCr	form	int?	No
CRTime	form	DateTime?	No
dtype	form	int?	No
cntID	form	int?	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

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 /Accounting/BooksTestQuery 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":[{"Book_id":"String","DocsPr_id":"String","Docs_id":"String","OpDet_id":"String","Currency_Id":"String","dDate":"\/Date(-62135596800000-0000)\/","db":"String","cr":"String","vg":0,"vu":0,"vc":0,"Contents":"String","Rate":0,"NumberIn":"String","NumberOut":"String","BookNote":"String","RecStatus":0,"Blocking":false,"cUser":"String","PLDb":0,"PLCr":0,"CRTime":"\/Date(-62135596800000-0000)\/","dtype":0,"cntID":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}