JiwaAPI

SO_MainQuery

The following routes are available for this service:
GET	/Queries/SO_Main	Retrieves a list of sales orders.

**SO_MainQuery** Parameters:
Name	Parameter	Data Type	Required
InvoiceID	query	string	No
InvoiceIDStartsWith	query	string	No
InvoiceIDEndsWith	query	string	No
InvoiceIDContains	query	string	No
InvoiceIDLike	query	string	No
InvoiceIDBetween	query	string[]	No
InvoiceIDIn	query	string[]	No
LastSavedDateTime	query	DateTime?	No
LastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeGreaterThan	query	DateTime?	No
LastSavedDateTimeLessThan	query	DateTime?	No
LastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeNotEqualTo	query	DateTime?	No
LastSavedDateTimeBetween	query	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	No
DebtorID	query	string	No
DebtorIDStartsWith	query	string	No
DebtorIDEndsWith	query	string	No
DebtorIDContains	query	string	No
DebtorIDLike	query	string	No
DebtorIDBetween	query	string[]	No
DebtorIDIn	query	string[]	No
StaffID	query	string	No
StaffIDStartsWith	query	string	No
StaffIDEndsWith	query	string	No
StaffIDContains	query	string	No
StaffIDLike	query	string	No
StaffIDBetween	query	string[]	No
StaffIDIn	query	string[]	No
InvoiceNo	query	string	No
InvoiceNoStartsWith	query	string	No
InvoiceNoEndsWith	query	string	No
InvoiceNoContains	query	string	No
InvoiceNoLike	query	string	No
InvoiceNoBetween	query	string[]	No
InvoiceNoIn	query	string[]	No
InvoiceInitDate	query	DateTime?	No
InvoiceInitDateGreaterThanOrEqualTo	query	DateTime?	No
InvoiceInitDateGreaterThan	query	DateTime?	No
InvoiceInitDateLessThan	query	DateTime?	No
InvoiceInitDateLessThanOrEqualTo	query	DateTime?	No
InvoiceInitDateNotEqualTo	query	DateTime?	No
InvoiceInitDateBetween	query	DateTime[]	No
InvoiceInitDateIn	query	DateTime[]	No
InvoiceLastDate	query	DateTime?	No
InvoiceLastDateGreaterThanOrEqualTo	query	DateTime?	No
InvoiceLastDateGreaterThan	query	DateTime?	No
InvoiceLastDateLessThan	query	DateTime?	No
InvoiceLastDateLessThanOrEqualTo	query	DateTime?	No
InvoiceLastDateNotEqualTo	query	DateTime?	No
InvoiceLastDateBetween	query	DateTime[]	No
InvoiceLastDateIn	query	DateTime[]	No
OrderNo	query	string	No
OrderNoStartsWith	query	string	No
OrderNoEndsWith	query	string	No
OrderNoContains	query	string	No
OrderNoLike	query	string	No
OrderNoBetween	query	string[]	No
OrderNoIn	query	string[]	No
TaxExemptNo	query	string	No
TaxExemptNoStartsWith	query	string	No
TaxExemptNoEndsWith	query	string	No
TaxExemptNoContains	query	string	No
TaxExemptNoLike	query	string	No
TaxExemptNoBetween	query	string[]	No
TaxExemptNoIn	query	string[]	No
WholeSaleInvoice	query	bool?	No
InvoiceTotal	query	decimal?	No
InvoiceTotalGreaterThanOrEqualTo	query	decimal?	No
InvoiceTotalGreaterThan	query	decimal?	No
InvoiceTotalLessThan	query	decimal?	No
InvoiceTotalLessThanOrEqualTo	query	decimal?	No
InvoiceTotalNotEqualTo	query	decimal?	No
InvoiceTotalBetween	query	Nullable<Decimal>[]	No
InvoiceTotalIn	query	Nullable<Decimal>[]	No
CurrentHistoryNo	query	short?	No
CurrentHistoryNoGreaterThanOrEqualTo	query	short?	No
CurrentHistoryNoGreaterThan	query	short?	No
CurrentHistoryNoLessThan	query	short?	No
CurrentHistoryNoLessThanOrEqualTo	query	short?	No
CurrentHistoryNoNotEqualTo	query	short?	No
CurrentHistoryNoBetween	query	Nullable<Int16>[]	No
CurrentHistoryNoIn	query	Nullable<Int16>[]	No
Status	query	short?	No
StatusGreaterThanOrEqualTo	query	short?	No
StatusGreaterThan	query	short?	No
StatusLessThan	query	short?	No
StatusLessThanOrEqualTo	query	short?	No
StatusNotEqualTo	query	short?	No
StatusBetween	query	Nullable<Int16>[]	No
StatusIn	query	Nullable<Int16>[]	No
BillWhenComplete	query	short?	No
BillWhenCompleteGreaterThanOrEqualTo	query	short?	No
BillWhenCompleteGreaterThan	query	short?	No
BillWhenCompleteLessThan	query	short?	No
BillWhenCompleteLessThanOrEqualTo	query	short?	No
BillWhenCompleteNotEqualTo	query	short?	No
BillWhenCompleteBetween	query	short[]	No
BillWhenCompleteIn	query	short[]	No
CreditNote	query	bool?	No
InvoiceType	query	short?	No
InvoiceTypeGreaterThanOrEqualTo	query	short?	No
InvoiceTypeGreaterThan	query	short?	No
InvoiceTypeLessThan	query	short?	No
InvoiceTypeLessThanOrEqualTo	query	short?	No
InvoiceTypeNotEqualTo	query	short?	No
InvoiceTypeBetween	query	Nullable<Int16>[]	No
InvoiceTypeIn	query	Nullable<Int16>[]	No
GroupSupplierID	query	string	No
GroupSupplierIDStartsWith	query	string	No
GroupSupplierIDEndsWith	query	string	No
GroupSupplierIDContains	query	string	No
GroupSupplierIDLike	query	string	No
GroupSupplierIDBetween	query	string[]	No
GroupSupplierIDIn	query	string[]	No
GroupOrdered	query	bool?	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	query	string[]	No
BranchID	query	string	No
BranchIDStartsWith	query	string	No
BranchIDEndsWith	query	string	No
BranchIDContains	query	string	No
BranchIDLike	query	string	No
BranchIDBetween	query	string[]	No
BranchIDIn	query	string[]	No
SOReference	query	string	No
SOReferenceStartsWith	query	string	No
SOReferenceEndsWith	query	string	No
SOReferenceContains	query	string	No
SOReferenceLike	query	string	No
SOReferenceBetween	query	string[]	No
SOReferenceIn	query	string[]	No
JobCostID	query	string	No
JobCostIDStartsWith	query	string	No
JobCostIDEndsWith	query	string	No
JobCostIDContains	query	string	No
JobCostIDLike	query	string	No
JobCostIDBetween	query	string[]	No
JobCostIDIn	query	string[]	No
ParentDebtorID	query	string	No
ParentDebtorIDStartsWith	query	string	No
ParentDebtorIDEndsWith	query	string	No
ParentDebtorIDContains	query	string	No
ParentDebtorIDLike	query	string	No
ParentDebtorIDBetween	query	string[]	No
ParentDebtorIDIn	query	string[]	No
BackOrderMode	query	short?	No
BackOrderModeGreaterThanOrEqualTo	query	short?	No
BackOrderModeGreaterThan	query	short?	No
BackOrderModeLessThan	query	short?	No
BackOrderModeLessThanOrEqualTo	query	short?	No
BackOrderModeNotEqualTo	query	short?	No
BackOrderModeBetween	query	short[]	No
BackOrderModeIn	query	short[]	No
DebtorContactName	query	string	No
DebtorContactNameStartsWith	query	string	No
DebtorContactNameEndsWith	query	string	No
DebtorContactNameContains	query	string	No
DebtorContactNameLike	query	string	No
DebtorContactNameBetween	query	string[]	No
DebtorContactNameIn	query	string[]	No
DocType	query	int?	No
DocTypeGreaterThanOrEqualTo	query	int?	No
DocTypeGreaterThan	query	int?	No
DocTypeLessThan	query	int?	No
DocTypeLessThanOrEqualTo	query	int?	No
DocTypeNotEqualTo	query	int?	No
DocTypeBetween	query	Nullable<Int32>[]	No
DocTypeIn	query	Nullable<Int32>[]	No
GSTInvoice	query	bool?	No
ExpectedDeliveryDate	query	DateTime?	No
ExpectedDeliveryDateGreaterThanOrEqualTo	query	DateTime?	No
ExpectedDeliveryDateGreaterThan	query	DateTime?	No
ExpectedDeliveryDateLessThan	query	DateTime?	No
ExpectedDeliveryDateLessThanOrEqualTo	query	DateTime?	No
ExpectedDeliveryDateNotEqualTo	query	DateTime?	No
ExpectedDeliveryDateBetween	query	Nullable<DateTime>[]	No
ExpectedDeliveryDateIn	query	Nullable<DateTime>[]	No
SourceQuoteHistoryID	query	string	No
SourceQuoteHistoryIDStartsWith	query	string	No
SourceQuoteHistoryIDEndsWith	query	string	No
SourceQuoteHistoryIDContains	query	string	No
SourceQuoteHistoryIDLike	query	string	No
SourceQuoteHistoryIDBetween	query	string[]	No
SourceQuoteHistoryIDIn	query	string[]	No
PriceSchemeID	query	string	No
PriceSchemeIDStartsWith	query	string	No
PriceSchemeIDEndsWith	query	string	No
PriceSchemeIDContains	query	string	No
PriceSchemeIDLike	query	string	No
PriceSchemeIDBetween	query	string[]	No
PriceSchemeIDIn	query	string[]	No
CreditReasonID	query	string	No
CreditReasonIDStartsWith	query	string	No
CreditReasonIDEndsWith	query	string	No
CreditReasonIDContains	query	string	No
CreditReasonIDLike	query	string	No
CreditReasonIDBetween	query	string[]	No
CreditReasonIDIn	query	string[]	No
CreditIntoStock	query	bool?	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

**SO_Main** Parameters:
Name	Parameter	Data Type	Required
InvoiceID	form	string	No
LastSavedDateTime	form	DateTime	No
DebtorID	form	string	No
StaffID	form	string	No
InvoiceNo	form	string	No
InvoiceInitDate	form	DateTime	No
InvoiceLastDate	form	DateTime	No
OrderNo	form	string	No
TaxExemptNo	form	string	No
WholeSaleInvoice	form	bool	No
InvoiceTotal	form	decimal?	No
CurrentHistoryNo	form	short?	No
Status	form	short?	No
BillWhenComplete	form	short	No
CreditNote	form	bool	No
InvoiceType	form	short?	No
GroupSupplierID	form	string	No
GroupOrdered	form	bool	No
IN_LogicalID	form	string	No
BranchID	form	string	No
SOReference	form	string	No
JobCostID	form	string	No
ParentDebtorID	form	string	No
BackOrderMode	form	short	No
DebtorContactName	form	string	No
DocType	form	int?	No
GSTInvoice	form	bool	No
ExpectedDeliveryDate	form	DateTime?	No
SourceQuoteHistoryID	form	string	No
PriceSchemeID	form	string	No
CreditReasonID	form	string	No
CreditIntoStock	form	bool	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 /Queries/SO_Main HTTP/1.1 
Host: localhost 
Accept: text/csv

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

{"Results":[{"InvoiceID":"String","DebtorID":"String","StaffID":"String","InvoiceNo":"String","OrderNo":"String","TaxExemptNo":"String","InvoiceTotal":0,"CurrentHistoryNo":0,"Status":0,"InvoiceType":0,"GroupSupplierID":"String","IN_LogicalID":"String","BranchID":"String","SOReference":"String","JobCostID":"String","ParentDebtorID":"String","DebtorContactName":"String","DocType":0,"ExpectedDeliveryDate":"0001-01-01T00:00:00.0000000","SourceQuoteHistoryID":"String","PriceSchemeID":"String","CreditReasonID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}