ApexERPHost

BooksQuery

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

**BooksQuery** Parameters:
Name	Parameter	Data Type	Required
DateBetween	query	DateTime[]	No
OperIdIn	query	string[]	No
DBContains	query	string	No
CRContains	query	string	No
NumberInContains	query	string	No

**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

**BookView** Parameters:
Name	Parameter	Data Type	Required
Id	form	string	No
DocID	form	string	No
OpDetId	form	string	No
CurrencyId	form	string	No
Date	form	DateTime	No
DB	form	string	No
CR	form	string	No
Amount	form	decimal?	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
recstatus	form	byte?	No
blocking	form	bool?	No
cuser	form	string	No
crtime	form	DateTime?	No
OperId	form	string	No
cardd	form	string	No
cardc	form	string	No
booknote	form	string	No
unid	form	Guid	No
code	form	string	No
cntid	form	int?	No
dpay	form	DateTime?	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 .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 /Accounting/BooksQuery HTTP/1.1 
Host: 10.10.0.107 
Accept: text/jsv

HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	Offset: 0,
	Total: 0,
	Results: 
	[
		{
			Id: String,
			DocID: String,
			OpDetId: String,
			CurrencyId: String,
			Date: 0001-01-01,
			DB: String,
			CR: String,
			Amount: 0,
			vg: 0,
			vu: 0,
			vc: 0,
			contents: String,
			rate: 0,
			numberin: String,
			numberout: String,
			recstatus: 0,
			blocking: False,
			cuser: String,
			crtime: 0001-01-01,
			OperId: String,
			cardd: String,
			cardc: String,
			booknote: String,
			unid: 00000000000000000000000000000000,
			code: String,
			cntid: 0,
			dpay: 0001-01-01
		}
	],
	Meta: 
	{
		String: String
	},
	ResponseStatus: 
	{
		ErrorCode: String,
		Message: String,
		StackTrace: String,
		Errors: 
		[
			{
				ErrorCode: String,
				FieldName: String,
				Message: String,
				Meta: 
				{
					String: String
				}
			}
		],
		Meta: 
		{
			String: String
		}
	}
}