JiwaAPI

<back to all web services

RE_MainQuery

Requires Authentication
The following routes are available for this service:
GET/Queries/RE_MainRetrieves a list of goods receipt notes.
RE_MainQuery Parameters:
NameParameterData TypeRequiredDescription
PackSlipIDquerystringNo
PackSlipIDStartsWithquerystringNo
PackSlipIDEndsWithquerystringNo
PackSlipIDContainsquerystringNo
PackSlipIDLikequerystringNo
PackSlipIDBetweenquerystring[]No
PackSlipIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
SlipNoquerystringNo
SlipNoStartsWithquerystringNo
SlipNoEndsWithquerystringNo
SlipNoContainsquerystringNo
SlipNoLikequerystringNo
SlipNoBetweenquerystring[]No
SlipNoInquerystring[]No
CreditorIDquerystringNo
CreditorIDStartsWithquerystringNo
CreditorIDEndsWithquerystringNo
CreditorIDContainsquerystringNo
CreditorIDLikequerystringNo
CreditorIDBetweenquerystring[]No
CreditorIDInquerystring[]No
SlipDatequeryDateTime?No
SlipDateGreaterThanOrEqualToqueryDateTime?No
SlipDateGreaterThanqueryDateTime?No
SlipDateLessThanqueryDateTime?No
SlipDateLessThanOrEqualToqueryDateTime?No
SlipDateNotEqualToqueryDateTime?No
SlipDateBetweenqueryNullable<DateTime>[]No
SlipDateInqueryNullable<DateTime>[]No
Statusqueryshort?No
StatusGreaterThanOrEqualToqueryshort?No
StatusGreaterThanqueryshort?No
StatusLessThanqueryshort?No
StatusLessThanOrEqualToqueryshort?No
StatusNotEqualToqueryshort?No
StatusBetweenqueryshort[]No
StatusInqueryshort[]No
Freightquerydecimal?No
FreightGreaterThanOrEqualToquerydecimal?No
FreightGreaterThanquerydecimal?No
FreightLessThanquerydecimal?No
FreightLessThanOrEqualToquerydecimal?No
FreightNotEqualToquerydecimal?No
FreightBetweenqueryNullable<Decimal>[]No
FreightInqueryNullable<Decimal>[]No
Dutyquerydecimal?No
DutyGreaterThanOrEqualToquerydecimal?No
DutyGreaterThanquerydecimal?No
DutyLessThanquerydecimal?No
DutyLessThanOrEqualToquerydecimal?No
DutyNotEqualToquerydecimal?No
DutyBetweenqueryNullable<Decimal>[]No
DutyInqueryNullable<Decimal>[]No
Invoicedquerybool?No
PI_MainIDquerystringNo
PI_MainIDStartsWithquerystringNo
PI_MainIDEndsWithquerystringNo
PI_MainIDContainsquerystringNo
PI_MainIDLikequerystringNo
PI_MainIDBetweenquerystring[]No
PI_MainIDInquerystring[]No
Insurancequerydecimal?No
InsuranceGreaterThanOrEqualToquerydecimal?No
InsuranceGreaterThanquerydecimal?No
InsuranceLessThanquerydecimal?No
InsuranceLessThanOrEqualToquerydecimal?No
InsuranceNotEqualToquerydecimal?No
InsuranceBetweenqueryNullable<Decimal>[]No
InsuranceInqueryNullable<Decimal>[]No
IN_LogicalIDquerystringNo
IN_LogicalIDStartsWithquerystringNo
IN_LogicalIDEndsWithquerystringNo
IN_LogicalIDContainsquerystringNo
IN_LogicalIDLikequerystringNo
IN_LogicalIDBetweenquerystring[]No
IN_LogicalIDInquerystring[]No
TaxTotalquerydecimal?No
TaxTotalGreaterThanOrEqualToquerydecimal?No
TaxTotalGreaterThanquerydecimal?No
TaxTotalLessThanquerydecimal?No
TaxTotalLessThanOrEqualToquerydecimal?No
TaxTotalNotEqualToquerydecimal?No
TaxTotalBetweenqueryNullable<Decimal>[]No
TaxTotalInqueryNullable<Decimal>[]No
FreightTaxIDquerystringNo
FreightTaxIDStartsWithquerystringNo
FreightTaxIDEndsWithquerystringNo
FreightTaxIDContainsquerystringNo
FreightTaxIDLikequerystringNo
FreightTaxIDBetweenquerystring[]No
FreightTaxIDInquerystring[]No
FreightTaxRatequerydecimal?No
FreightTaxRateGreaterThanOrEqualToquerydecimal?No
FreightTaxRateGreaterThanquerydecimal?No
FreightTaxRateLessThanquerydecimal?No
FreightTaxRateLessThanOrEqualToquerydecimal?No
FreightTaxRateNotEqualToquerydecimal?No
FreightTaxRateBetweenqueryNullable<Decimal>[]No
FreightTaxRateInqueryNullable<Decimal>[]No
FreightTaxAmountquerydecimal?No
FreightTaxAmountGreaterThanOrEqualToquerydecimal?No
FreightTaxAmountGreaterThanquerydecimal?No
FreightTaxAmountLessThanquerydecimal?No
FreightTaxAmountLessThanOrEqualToquerydecimal?No
FreightTaxAmountNotEqualToquerydecimal?No
FreightTaxAmountBetweenqueryNullable<Decimal>[]No
FreightTaxAmountInqueryNullable<Decimal>[]No
DutyTaxIDquerystringNo
DutyTaxIDStartsWithquerystringNo
DutyTaxIDEndsWithquerystringNo
DutyTaxIDContainsquerystringNo
DutyTaxIDLikequerystringNo
DutyTaxIDBetweenquerystring[]No
DutyTaxIDInquerystring[]No
DutyTaxRatequerydecimal?No
DutyTaxRateGreaterThanOrEqualToquerydecimal?No
DutyTaxRateGreaterThanquerydecimal?No
DutyTaxRateLessThanquerydecimal?No
DutyTaxRateLessThanOrEqualToquerydecimal?No
DutyTaxRateNotEqualToquerydecimal?No
DutyTaxRateBetweenqueryNullable<Decimal>[]No
DutyTaxRateInqueryNullable<Decimal>[]No
DutyTaxAmountquerydecimal?No
DutyTaxAmountGreaterThanOrEqualToquerydecimal?No
DutyTaxAmountGreaterThanquerydecimal?No
DutyTaxAmountLessThanquerydecimal?No
DutyTaxAmountLessThanOrEqualToquerydecimal?No
DutyTaxAmountNotEqualToquerydecimal?No
DutyTaxAmountBetweenqueryNullable<Decimal>[]No
DutyTaxAmountInqueryNullable<Decimal>[]No
InsuranceTaxIDquerystringNo
InsuranceTaxIDStartsWithquerystringNo
InsuranceTaxIDEndsWithquerystringNo
InsuranceTaxIDContainsquerystringNo
InsuranceTaxIDLikequerystringNo
InsuranceTaxIDBetweenquerystring[]No
InsuranceTaxIDInquerystring[]No
InsuranceTaxRatequerydecimal?No
InsuranceTaxRateGreaterThanOrEqualToquerydecimal?No
InsuranceTaxRateGreaterThanquerydecimal?No
InsuranceTaxRateLessThanquerydecimal?No
InsuranceTaxRateLessThanOrEqualToquerydecimal?No
InsuranceTaxRateNotEqualToquerydecimal?No
InsuranceTaxRateBetweenqueryNullable<Decimal>[]No
InsuranceTaxRateInqueryNullable<Decimal>[]No
InsuranceTaxAmountquerydecimal?No
InsuranceTaxAmountGreaterThanOrEqualToquerydecimal?No
InsuranceTaxAmountGreaterThanquerydecimal?No
InsuranceTaxAmountLessThanquerydecimal?No
InsuranceTaxAmountLessThanOrEqualToquerydecimal?No
InsuranceTaxAmountNotEqualToquerydecimal?No
InsuranceTaxAmountBetweenqueryNullable<Decimal>[]No
InsuranceTaxAmountInqueryNullable<Decimal>[]No
ReferencequerystringNo
ReferenceStartsWithquerystringNo
ReferenceEndsWithquerystringNo
ReferenceContainsquerystringNo
ReferenceLikequerystringNo
ReferenceBetweenquerystring[]No
ReferenceInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
RE_Main Parameters:
NameParameterData TypeRequiredDescription
PackSlipIDformstringNo
LastSavedDateTimeformDateTime?No
SlipNoformstringNo
CreditorIDformstringNo
SlipDateformDateTime?No
StatusformshortNo
Freightformdecimal?No
Dutyformdecimal?No
InvoicedformboolNo
PI_MainIDformstringNo
Insuranceformdecimal?No
IN_LogicalIDformstringNo
TaxTotalformdecimal?No
FreightTaxIDformstringNo
FreightTaxRateformdecimal?No
FreightTaxAmountformdecimal?No
DutyTaxIDformstringNo
DutyTaxRateformdecimal?No
DutyTaxAmountformdecimal?No
InsuranceTaxIDformstringNo
InsuranceTaxRateformdecimal?No
InsuranceTaxAmountformdecimal?No
ReferenceformstringNo
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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /Queries/RE_Main HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"PackSlipID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","SlipNo":"String","CreditorID":"String","SlipDate":"0001-01-01T00:00:00.0000000","Freight":0,"Duty":0,"PI_MainID":"String","Insurance":0,"IN_LogicalID":"String","TaxTotal":0,"FreightTaxID":"String","FreightTaxRate":0,"FreightTaxAmount":0,"DutyTaxID":"String","DutyTaxRate":0,"DutyTaxAmount":0,"InsuranceTaxID":"String","InsuranceTaxRate":0,"InsuranceTaxAmount":0,"Reference":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}