JiwaAPI

PO_MainQuery

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

**PO_MainQuery** Parameters:
Name	Parameter	Data Type	Required
OrderID	query	string	No
OrderIDStartsWith	query	string	No
OrderIDEndsWith	query	string	No
OrderIDContains	query	string	No
OrderIDLike	query	string	No
OrderIDBetween	query	string[]	No
OrderIDIn	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	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<DateTime>[]	No
CreditorID	query	string	No
CreditorIDStartsWith	query	string	No
CreditorIDEndsWith	query	string	No
CreditorIDContains	query	string	No
CreditorIDLike	query	string	No
CreditorIDBetween	query	string[]	No
CreditorIDIn	query	string[]	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
OrderedDate	query	DateTime?	No
OrderedDateGreaterThanOrEqualTo	query	DateTime?	No
OrderedDateGreaterThan	query	DateTime?	No
OrderedDateLessThan	query	DateTime?	No
OrderedDateLessThanOrEqualTo	query	DateTime?	No
OrderedDateNotEqualTo	query	DateTime?	No
OrderedDateBetween	query	DateTime[]	No
OrderedDateIn	query	DateTime[]	No
Header1	query	string	No
Header1StartsWith	query	string	No
Header1EndsWith	query	string	No
Header1Contains	query	string	No
Header1Like	query	string	No
Header1Between	query	string[]	No
Header1In	query	string[]	No
Header2	query	string	No
Header2StartsWith	query	string	No
Header2EndsWith	query	string	No
Header2Contains	query	string	No
Header2Like	query	string	No
Header2Between	query	string[]	No
Header2In	query	string[]	No
Header5	query	string	No
Header5StartsWith	query	string	No
Header5EndsWith	query	string	No
Header5Contains	query	string	No
Header5Like	query	string	No
Header5Between	query	string[]	No
Header5In	query	string[]	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	short[]	No
StatusIn	query	short[]	No
OrderType	query	short?	No
OrderTypeGreaterThanOrEqualTo	query	short?	No
OrderTypeGreaterThan	query	short?	No
OrderTypeLessThan	query	short?	No
OrderTypeLessThanOrEqualTo	query	short?	No
OrderTypeNotEqualTo	query	short?	No
OrderTypeBetween	query	Nullable<Int16>[]	No
OrderTypeIn	query	Nullable<Int16>[]	No
OrderTypeInvID	query	string	No
OrderTypeInvIDStartsWith	query	string	No
OrderTypeInvIDEndsWith	query	string	No
OrderTypeInvIDContains	query	string	No
OrderTypeInvIDLike	query	string	No
OrderTypeInvIDBetween	query	string[]	No
OrderTypeInvIDIn	query	string[]	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
OrderSupplierType	query	short?	No
OrderSupplierTypeGreaterThanOrEqualTo	query	short?	No
OrderSupplierTypeGreaterThan	query	short?	No
OrderSupplierTypeLessThan	query	short?	No
OrderSupplierTypeLessThanOrEqualTo	query	short?	No
OrderSupplierTypeNotEqualTo	query	short?	No
OrderSupplierTypeBetween	query	short[]	No
OrderSupplierTypeIn	query	short[]	No
CentralWarehouseID	query	string	No
CentralWarehouseIDStartsWith	query	string	No
CentralWarehouseIDEndsWith	query	string	No
CentralWarehouseIDContains	query	string	No
CentralWarehouseIDLike	query	string	No
CentralWarehouseIDBetween	query	string[]	No
CentralWarehouseIDIn	query	string[]	No
TaxTotal	query	decimal?	No
TaxTotalGreaterThanOrEqualTo	query	decimal?	No
TaxTotalGreaterThan	query	decimal?	No
TaxTotalLessThan	query	decimal?	No
TaxTotalLessThanOrEqualTo	query	decimal?	No
TaxTotalNotEqualTo	query	decimal?	No
TaxTotalBetween	query	Nullable<Decimal>[]	No
TaxTotalIn	query	Nullable<Decimal>[]	No
CurrencyID	query	string	No
CurrencyIDStartsWith	query	string	No
CurrencyIDEndsWith	query	string	No
CurrencyIDContains	query	string	No
CurrencyIDLike	query	string	No
CurrencyIDBetween	query	string[]	No
CurrencyIDIn	query	string[]	No
InTransitWarehouseID	query	string	No
InTransitWarehouseIDStartsWith	query	string	No
InTransitWarehouseIDEndsWith	query	string	No
InTransitWarehouseIDContains	query	string	No
InTransitWarehouseIDLike	query	string	No
InTransitWarehouseIDBetween	query	string[]	No
InTransitWarehouseIDIn	query	string[]	No
Reference	query	string	No
ReferenceStartsWith	query	string	No
ReferenceEndsWith	query	string	No
ReferenceContains	query	string	No
ReferenceLike	query	string	No
ReferenceBetween	query	string[]	No
ReferenceIn	query	string[]	No
PO_Workflows_RecID	query	string	No
PO_Workflows_RecIDStartsWith	query	string	No
PO_Workflows_RecIDEndsWith	query	string	No
PO_Workflows_RecIDContains	query	string	No
PO_Workflows_RecIDLike	query	string	No
PO_Workflows_RecIDBetween	query	string[]	No
PO_Workflows_RecIDIn	query	string[]	No
HR_Staff_RecID	query	string	No
HR_Staff_RecIDStartsWith	query	string	No
HR_Staff_RecIDEndsWith	query	string	No
HR_Staff_RecIDContains	query	string	No
HR_Staff_RecIDLike	query	string	No
HR_Staff_RecIDBetween	query	string[]	No
HR_Staff_RecIDIn	query	string[]	No
CR_Warehouse_WarehouseID	query	string	No
CR_Warehouse_WarehouseIDStartsWith	query	string	No
CR_Warehouse_WarehouseIDEndsWith	query	string	No
CR_Warehouse_WarehouseIDContains	query	string	No
CR_Warehouse_WarehouseIDLike	query	string	No
CR_Warehouse_WarehouseIDBetween	query	string[]	No
CR_Warehouse_WarehouseIDIn	query	string[]	No
Freight	query	decimal?	No
FreightGreaterThanOrEqualTo	query	decimal?	No
FreightGreaterThan	query	decimal?	No
FreightLessThan	query	decimal?	No
FreightLessThanOrEqualTo	query	decimal?	No
FreightNotEqualTo	query	decimal?	No
FreightBetween	query	decimal[]	No
FreightIn	query	decimal[]	No
Duty	query	decimal?	No
DutyGreaterThanOrEqualTo	query	decimal?	No
DutyGreaterThan	query	decimal?	No
DutyLessThan	query	decimal?	No
DutyLessThanOrEqualTo	query	decimal?	No
DutyNotEqualTo	query	decimal?	No
DutyBetween	query	decimal[]	No
DutyIn	query	decimal[]	No
Insurance	query	decimal?	No
InsuranceGreaterThanOrEqualTo	query	decimal?	No
InsuranceGreaterThan	query	decimal?	No
InsuranceLessThan	query	decimal?	No
InsuranceLessThanOrEqualTo	query	decimal?	No
InsuranceNotEqualTo	query	decimal?	No
InsuranceBetween	query	decimal[]	No
InsuranceIn	query	decimal[]	No
FreightTaxID	query	string	No
FreightTaxIDStartsWith	query	string	No
FreightTaxIDEndsWith	query	string	No
FreightTaxIDContains	query	string	No
FreightTaxIDLike	query	string	No
FreightTaxIDBetween	query	string[]	No
FreightTaxIDIn	query	string[]	No
FreightTaxRate	query	decimal?	No
FreightTaxRateGreaterThanOrEqualTo	query	decimal?	No
FreightTaxRateGreaterThan	query	decimal?	No
FreightTaxRateLessThan	query	decimal?	No
FreightTaxRateLessThanOrEqualTo	query	decimal?	No
FreightTaxRateNotEqualTo	query	decimal?	No
FreightTaxRateBetween	query	decimal[]	No
FreightTaxRateIn	query	decimal[]	No
FreightTaxAmount	query	decimal?	No
FreightTaxAmountGreaterThanOrEqualTo	query	decimal?	No
FreightTaxAmountGreaterThan	query	decimal?	No
FreightTaxAmountLessThan	query	decimal?	No
FreightTaxAmountLessThanOrEqualTo	query	decimal?	No
FreightTaxAmountNotEqualTo	query	decimal?	No
FreightTaxAmountBetween	query	decimal[]	No
FreightTaxAmountIn	query	decimal[]	No
DutyTaxID	query	string	No
DutyTaxIDStartsWith	query	string	No
DutyTaxIDEndsWith	query	string	No
DutyTaxIDContains	query	string	No
DutyTaxIDLike	query	string	No
DutyTaxIDBetween	query	string[]	No
DutyTaxIDIn	query	string[]	No
DutyTaxRate	query	decimal?	No
DutyTaxRateGreaterThanOrEqualTo	query	decimal?	No
DutyTaxRateGreaterThan	query	decimal?	No
DutyTaxRateLessThan	query	decimal?	No
DutyTaxRateLessThanOrEqualTo	query	decimal?	No
DutyTaxRateNotEqualTo	query	decimal?	No
DutyTaxRateBetween	query	decimal[]	No
DutyTaxRateIn	query	decimal[]	No
DutyTaxAmount	query	decimal?	No
DutyTaxAmountGreaterThanOrEqualTo	query	decimal?	No
DutyTaxAmountGreaterThan	query	decimal?	No
DutyTaxAmountLessThan	query	decimal?	No
DutyTaxAmountLessThanOrEqualTo	query	decimal?	No
DutyTaxAmountNotEqualTo	query	decimal?	No
DutyTaxAmountBetween	query	decimal[]	No
DutyTaxAmountIn	query	decimal[]	No
InsuranceTaxID	query	string	No
InsuranceTaxIDStartsWith	query	string	No
InsuranceTaxIDEndsWith	query	string	No
InsuranceTaxIDContains	query	string	No
InsuranceTaxIDLike	query	string	No
InsuranceTaxIDBetween	query	string[]	No
InsuranceTaxIDIn	query	string[]	No
InsuranceTaxRate	query	decimal?	No
InsuranceTaxRateGreaterThanOrEqualTo	query	decimal?	No
InsuranceTaxRateGreaterThan	query	decimal?	No
InsuranceTaxRateLessThan	query	decimal?	No
InsuranceTaxRateLessThanOrEqualTo	query	decimal?	No
InsuranceTaxRateNotEqualTo	query	decimal?	No
InsuranceTaxRateBetween	query	decimal[]	No
InsuranceTaxRateIn	query	decimal[]	No
InsuranceTaxAmount	query	decimal?	No
InsuranceTaxAmountGreaterThanOrEqualTo	query	decimal?	No
InsuranceTaxAmountGreaterThan	query	decimal?	No
InsuranceTaxAmountLessThan	query	decimal?	No
InsuranceTaxAmountLessThanOrEqualTo	query	decimal?	No
InsuranceTaxAmountNotEqualTo	query	decimal?	No
InsuranceTaxAmountBetween	query	decimal[]	No
InsuranceTaxAmountIn	query	decimal[]	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

**PO_Main** Parameters:
Name	Parameter	Data Type	Required
OrderID	form	string	No
LastSavedDateTime	form	DateTime?	No
CreditorID	form	string	No
OrderNo	form	string	No
OrderedDate	form	DateTime	No
Header1	form	string	No
Header2	form	string	No
Header5	form	string	No
Status	form	short	No
OrderType	form	short?	No
OrderTypeInvID	form	string	No
IN_LogicalID	form	string	No
OrderSupplierType	form	short	No
CentralWarehouseID	form	string	No
TaxTotal	form	decimal?	No
CurrencyID	form	string	No
InTransitWarehouseID	form	string	No
Reference	form	string	No
PO_Workflows_RecID	form	string	No
HR_Staff_RecID	form	string	No
CR_Warehouse_WarehouseID	form	string	No
Freight	form	decimal	No
Duty	form	decimal	No
Insurance	form	decimal	No
FreightTaxID	form	string	No
FreightTaxRate	form	decimal	No
FreightTaxAmount	form	decimal	No
DutyTaxID	form	string	No
DutyTaxRate	form	decimal	No
DutyTaxAmount	form	decimal	No
InsuranceTaxID	form	string	No
InsuranceTaxRate	form	decimal	No
InsuranceTaxAmount	form	decimal	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/PO_Main HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv

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

{"Results":[{"OrderID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","CreditorID":"String","OrderNo":"String","Header1":"String","Header2":"String","Header5":"String","OrderType":0,"OrderTypeInvID":"String","IN_LogicalID":"String","CentralWarehouseID":"String","TaxTotal":0,"CurrencyID":"String","InTransitWarehouseID":"String","Reference":"String","PO_Workflows_RecID":"String","HR_Staff_RecID":"String","CR_Warehouse_WarehouseID":"String","FreightTaxID":"String","DutyTaxID":"String","InsuranceTaxID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}