JiwaAPI

PI_MainQuery

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

**PI_MainQuery** Parameters:
Name	Parameter	Data Type	Required
PI_MainID	query	string	No
PI_MainIDStartsWith	query	string	No
PI_MainIDEndsWith	query	string	No
PI_MainIDContains	query	string	No
PI_MainIDLike	query	string	No
PI_MainIDBetween	query	string[]	No
PI_MainIDIn	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
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
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
InvoiceDate	query	DateTime?	No
InvoiceDateGreaterThanOrEqualTo	query	DateTime?	No
InvoiceDateGreaterThan	query	DateTime?	No
InvoiceDateLessThan	query	DateTime?	No
InvoiceDateLessThanOrEqualTo	query	DateTime?	No
InvoiceDateNotEqualTo	query	DateTime?	No
InvoiceDateBetween	query	Nullable<DateTime>[]	No
InvoiceDateIn	query	Nullable<DateTime>[]	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
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	Nullable<Decimal>[]	No
FreightIn	query	Nullable<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	Nullable<Decimal>[]	No
DutyIn	query	Nullable<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	Nullable<Decimal>[]	No
InsuranceIn	query	Nullable<Decimal>[]	No
DueDate	query	DateTime?	No
DueDateGreaterThanOrEqualTo	query	DateTime?	No
DueDateGreaterThan	query	DateTime?	No
DueDateLessThan	query	DateTime?	No
DueDateLessThanOrEqualTo	query	DateTime?	No
DueDateNotEqualTo	query	DateTime?	No
DueDateBetween	query	Nullable<DateTime>[]	No
DueDateIn	query	Nullable<DateTime>[]	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
TotalLineTax	query	decimal?	No
TotalLineTaxGreaterThanOrEqualTo	query	decimal?	No
TotalLineTaxGreaterThan	query	decimal?	No
TotalLineTaxLessThan	query	decimal?	No
TotalLineTaxLessThanOrEqualTo	query	decimal?	No
TotalLineTaxNotEqualTo	query	decimal?	No
TotalLineTaxBetween	query	decimal[]	No
TotalLineTaxIn	query	decimal[]	No
AdjTax	query	decimal?	No
AdjTaxGreaterThanOrEqualTo	query	decimal?	No
AdjTaxGreaterThan	query	decimal?	No
AdjTaxLessThan	query	decimal?	No
AdjTaxLessThanOrEqualTo	query	decimal?	No
AdjTaxNotEqualTo	query	decimal?	No
AdjTaxBetween	query	decimal[]	No
AdjTaxIn	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	Nullable<Decimal>[]	No
FreightTaxRateIn	query	Nullable<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	Nullable<Decimal>[]	No
FreightTaxAmountIn	query	Nullable<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	Nullable<Decimal>[]	No
DutyTaxRateIn	query	Nullable<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	Nullable<Decimal>[]	No
DutyTaxAmountIn	query	Nullable<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	Nullable<Decimal>[]	No
InsuranceTaxRateIn	query	Nullable<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	Nullable<Decimal>[]	No
InsuranceTaxAmountIn	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
DecimalPlaces	query	short?	No
DecimalPlacesGreaterThanOrEqualTo	query	short?	No
DecimalPlacesGreaterThan	query	short?	No
DecimalPlacesLessThan	query	short?	No
DecimalPlacesLessThanOrEqualTo	query	short?	No
DecimalPlacesNotEqualTo	query	short?	No
DecimalPlacesBetween	query	Nullable<Int16>[]	No
DecimalPlacesIn	query	Nullable<Int16>[]	No
FXDecimalPlaces	query	short?	No
FXDecimalPlacesGreaterThanOrEqualTo	query	short?	No
FXDecimalPlacesGreaterThan	query	short?	No
FXDecimalPlacesLessThan	query	short?	No
FXDecimalPlacesLessThanOrEqualTo	query	short?	No
FXDecimalPlacesNotEqualTo	query	short?	No
FXDecimalPlacesBetween	query	Nullable<Int16>[]	No
FXDecimalPlacesIn	query	Nullable<Int16>[]	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

**PI_Main** Parameters:
Name	Parameter	Data Type	Required
PI_MainID	form	string	No
LastSavedDateTime	form	DateTime?	No
InvoiceNo	form	string	No
CreditorID	form	string	No
InvoiceDate	form	DateTime?	No
Status	form	short	No
Freight	form	decimal?	No
Duty	form	decimal?	No
Insurance	form	decimal?	No
DueDate	form	DateTime?	No
IN_LogicalID	form	string	No
TotalLineTax	form	decimal	No
AdjTax	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
CurrencyID	form	string	No
DecimalPlaces	form	short?	No
FXDecimalPlaces	form	short?	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/PI_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":[{"PI_MainID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","InvoiceNo":"String","CreditorID":"String","InvoiceDate":"0001-01-01T00:00:00.0000000","Freight":0,"Duty":0,"Insurance":0,"DueDate":"0001-01-01T00:00:00.0000000","IN_LogicalID":"String","FreightTaxID":"String","FreightTaxRate":0,"FreightTaxAmount":0,"DutyTaxID":"String","DutyTaxRate":0,"DutyTaxAmount":0,"InsuranceTaxID":"String","InsuranceTaxRate":0,"InsuranceTaxAmount":0,"CurrencyID":"String","DecimalPlaces":0,"FXDecimalPlaces":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}