ApexERPHost

<back to all web services

BooksTestQuery

Requires Authentication
The following routes are available for this service:
GET/Accounting/BooksTestQuery
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
BookTEST Parameters:
NameParameterData TypeRequiredDescription
Book_idformstringNo
DocsPr_idformstringNo
Docs_idformstringNo
OpDet_idformstringNo
Currency_IdformstringNo
dDateformDateTimeNo
dbformstringNo
crformstringNo
vgformdecimal?No
vuformdecimal?No
vcformdecimal?No
ContentsformstringNo
RateformdecimalNo
NumberInformstringNo
NumberOutformstringNo
BookNoteformstringNo
RecStatusformbyte?No
Blockingformbool?No
cUserformstringNo
PLDbformint?No
PLCrformint?No
CRTimeformDateTime?No
dtypeformint?No
cntIDformint?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 /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"}}}