JiwaAPI

<back to all web services

QO_HistoryQuery

Requires Authentication
QO_HistoryQuery Parameters:
NameParameterData TypeRequiredDescription
InvoiceHistoryIDquerystringNo
InvoiceHistoryIDStartsWithquerystringNo
InvoiceHistoryIDEndsWithquerystringNo
InvoiceHistoryIDContainsquerystringNo
InvoiceHistoryIDLikequerystringNo
InvoiceHistoryIDBetweenquerystring[]No
InvoiceHistoryIDInquerystring[]No
InvoiceIDquerystringNo
InvoiceIDStartsWithquerystringNo
InvoiceIDEndsWithquerystringNo
InvoiceIDContainsquerystringNo
InvoiceIDLikequerystringNo
InvoiceIDBetweenquerystring[]No
InvoiceIDInquerystring[]No
LastModifiedByquerystringNo
LastModifiedByStartsWithquerystringNo
LastModifiedByEndsWithquerystringNo
LastModifiedByContainsquerystringNo
LastModifiedByLikequerystringNo
LastModifiedByBetweenquerystring[]No
LastModifiedByInquerystring[]No
RecordDatequeryDateTime?No
RecordDateGreaterThanOrEqualToqueryDateTime?No
RecordDateGreaterThanqueryDateTime?No
RecordDateLessThanqueryDateTime?No
RecordDateLessThanOrEqualToqueryDateTime?No
RecordDateNotEqualToqueryDateTime?No
RecordDateBetweenqueryDateTime[]No
RecordDateInqueryDateTime[]No
RefquerystringNo
RefStartsWithquerystringNo
RefEndsWithquerystringNo
RefContainsquerystringNo
RefLikequerystringNo
RefBetweenquerystring[]No
RefInquerystring[]No
HistoryNoqueryshort?No
HistoryNoGreaterThanOrEqualToqueryshort?No
HistoryNoGreaterThanqueryshort?No
HistoryNoLessThanqueryshort?No
HistoryNoLessThanOrEqualToqueryshort?No
HistoryNoNotEqualToqueryshort?No
HistoryNoBetweenqueryNullable<Int16>[]No
HistoryNoInqueryNullable<Int16>[]No
HistoryTotalquerydecimal?No
HistoryTotalGreaterThanOrEqualToquerydecimal?No
HistoryTotalGreaterThanquerydecimal?No
HistoryTotalLessThanquerydecimal?No
HistoryTotalLessThanOrEqualToquerydecimal?No
HistoryTotalNotEqualToquerydecimal?No
HistoryTotalBetweenqueryNullable<Decimal>[]No
HistoryTotalInqueryNullable<Decimal>[]No
DocketPrintedquerybool?No
DelAddress1querystringNo
DelAddress1StartsWithquerystringNo
DelAddress1EndsWithquerystringNo
DelAddress1ContainsquerystringNo
DelAddress1LikequerystringNo
DelAddress1Betweenquerystring[]No
DelAddress1Inquerystring[]No
DelAddress2querystringNo
DelAddress2StartsWithquerystringNo
DelAddress2EndsWithquerystringNo
DelAddress2ContainsquerystringNo
DelAddress2LikequerystringNo
DelAddress2Betweenquerystring[]No
DelAddress2Inquerystring[]No
DelAddress3querystringNo
DelAddress3StartsWithquerystringNo
DelAddress3EndsWithquerystringNo
DelAddress3ContainsquerystringNo
DelAddress3LikequerystringNo
DelAddress3Betweenquerystring[]No
DelAddress3Inquerystring[]No
DelAddress4querystringNo
DelAddress4StartsWithquerystringNo
DelAddress4EndsWithquerystringNo
DelAddress4ContainsquerystringNo
DelAddress4LikequerystringNo
DelAddress4Betweenquerystring[]No
DelAddress4Inquerystring[]No
PostCodequerystringNo
PostCodeStartsWithquerystringNo
PostCodeEndsWithquerystringNo
PostCodeContainsquerystringNo
PostCodeLikequerystringNo
PostCodeBetweenquerystring[]No
PostCodeInquerystring[]No
NotesquerystringNo
NotesStartsWithquerystringNo
NotesEndsWithquerystringNo
NotesContainsquerystringNo
NotesLikequerystringNo
NotesBetweenquerystring[]No
NotesInquerystring[]No
CourierDetailsquerystringNo
CourierDetailsStartsWithquerystringNo
CourierDetailsEndsWithquerystringNo
CourierDetailsContainsquerystringNo
CourierDetailsLikequerystringNo
CourierDetailsBetweenquerystring[]No
CourierDetailsInquerystring[]No
InvoicePrintedquerybool?No
CartageCharge1querydecimal?No
CartageCharge1GreaterThanOrEqualToquerydecimal?No
CartageCharge1GreaterThanquerydecimal?No
CartageCharge1LessThanquerydecimal?No
CartageCharge1LessThanOrEqualToquerydecimal?No
CartageCharge1NotEqualToquerydecimal?No
CartageCharge1BetweenqueryNullable<Decimal>[]No
CartageCharge1InqueryNullable<Decimal>[]No
CartageCharge2querydecimal?No
CartageCharge2GreaterThanOrEqualToquerydecimal?No
CartageCharge2GreaterThanquerydecimal?No
CartageCharge2LessThanquerydecimal?No
CartageCharge2LessThanOrEqualToquerydecimal?No
CartageCharge2NotEqualToquerydecimal?No
CartageCharge2BetweenqueryNullable<Decimal>[]No
CartageCharge2InqueryNullable<Decimal>[]No
CartageCharge3querydecimal?No
CartageCharge3GreaterThanOrEqualToquerydecimal?No
CartageCharge3GreaterThanquerydecimal?No
CartageCharge3LessThanquerydecimal?No
CartageCharge3LessThanOrEqualToquerydecimal?No
CartageCharge3NotEqualToquerydecimal?No
CartageCharge3BetweenqueryNullable<Decimal>[]No
CartageCharge3InqueryNullable<Decimal>[]No
ExpiryDatequeryDateTime?No
ExpiryDateGreaterThanOrEqualToqueryDateTime?No
ExpiryDateGreaterThanqueryDateTime?No
ExpiryDateLessThanqueryDateTime?No
ExpiryDateLessThanOrEqualToqueryDateTime?No
ExpiryDateNotEqualToqueryDateTime?No
ExpiryDateBetweenqueryNullable<DateTime>[]No
ExpiryDateInqueryNullable<DateTime>[]No
Cartage1TaxRateIDquerystringNo
Cartage1TaxRateIDStartsWithquerystringNo
Cartage1TaxRateIDEndsWithquerystringNo
Cartage1TaxRateIDContainsquerystringNo
Cartage1TaxRateIDLikequerystringNo
Cartage1TaxRateIDBetweenquerystring[]No
Cartage1TaxRateIDInquerystring[]No
Cartage1TaxRatequerydecimal?No
Cartage1TaxRateGreaterThanOrEqualToquerydecimal?No
Cartage1TaxRateGreaterThanquerydecimal?No
Cartage1TaxRateLessThanquerydecimal?No
Cartage1TaxRateLessThanOrEqualToquerydecimal?No
Cartage1TaxRateNotEqualToquerydecimal?No
Cartage1TaxRateBetweenqueryNullable<Decimal>[]No
Cartage1TaxRateInqueryNullable<Decimal>[]No
Cartage1TaxAmountquerydecimal?No
Cartage1TaxAmountGreaterThanOrEqualToquerydecimal?No
Cartage1TaxAmountGreaterThanquerydecimal?No
Cartage1TaxAmountLessThanquerydecimal?No
Cartage1TaxAmountLessThanOrEqualToquerydecimal?No
Cartage1TaxAmountNotEqualToquerydecimal?No
Cartage1TaxAmountBetweenqueryNullable<Decimal>[]No
Cartage1TaxAmountInqueryNullable<Decimal>[]No
Cartage2TaxRateIDquerystringNo
Cartage2TaxRateIDStartsWithquerystringNo
Cartage2TaxRateIDEndsWithquerystringNo
Cartage2TaxRateIDContainsquerystringNo
Cartage2TaxRateIDLikequerystringNo
Cartage2TaxRateIDBetweenquerystring[]No
Cartage2TaxRateIDInquerystring[]No
Cartage2TaxRatequerydecimal?No
Cartage2TaxRateGreaterThanOrEqualToquerydecimal?No
Cartage2TaxRateGreaterThanquerydecimal?No
Cartage2TaxRateLessThanquerydecimal?No
Cartage2TaxRateLessThanOrEqualToquerydecimal?No
Cartage2TaxRateNotEqualToquerydecimal?No
Cartage2TaxRateBetweenqueryNullable<Decimal>[]No
Cartage2TaxRateInqueryNullable<Decimal>[]No
Cartage2TaxAmountquerydecimal?No
Cartage2TaxAmountGreaterThanOrEqualToquerydecimal?No
Cartage2TaxAmountGreaterThanquerydecimal?No
Cartage2TaxAmountLessThanquerydecimal?No
Cartage2TaxAmountLessThanOrEqualToquerydecimal?No
Cartage2TaxAmountNotEqualToquerydecimal?No
Cartage2TaxAmountBetweenqueryNullable<Decimal>[]No
Cartage2TaxAmountInqueryNullable<Decimal>[]No
Cartage3TaxRateIDquerystringNo
Cartage3TaxRateIDStartsWithquerystringNo
Cartage3TaxRateIDEndsWithquerystringNo
Cartage3TaxRateIDContainsquerystringNo
Cartage3TaxRateIDLikequerystringNo
Cartage3TaxRateIDBetweenquerystring[]No
Cartage3TaxRateIDInquerystring[]No
Cartage3TaxRatequerydecimal?No
Cartage3TaxRateGreaterThanOrEqualToquerydecimal?No
Cartage3TaxRateGreaterThanquerydecimal?No
Cartage3TaxRateLessThanquerydecimal?No
Cartage3TaxRateLessThanOrEqualToquerydecimal?No
Cartage3TaxRateNotEqualToquerydecimal?No
Cartage3TaxRateBetweenqueryNullable<Decimal>[]No
Cartage3TaxRateInqueryNullable<Decimal>[]No
Cartage3TaxAmountquerydecimal?No
Cartage3TaxAmountGreaterThanOrEqualToquerydecimal?No
Cartage3TaxAmountGreaterThanquerydecimal?No
Cartage3TaxAmountLessThanquerydecimal?No
Cartage3TaxAmountLessThanOrEqualToquerydecimal?No
Cartage3TaxAmountNotEqualToquerydecimal?No
Cartage3TaxAmountBetweenqueryNullable<Decimal>[]No
Cartage3TaxAmountInqueryNullable<Decimal>[]No
DelContactNamequerystringNo
DelContactNameStartsWithquerystringNo
DelContactNameEndsWithquerystringNo
DelContactNameContainsquerystringNo
DelContactNameLikequerystringNo
DelContactNameBetweenquerystring[]No
DelContactNameInquerystring[]No
FreightForwardAddress1querystringNo
FreightForwardAddress1StartsWithquerystringNo
FreightForwardAddress1EndsWithquerystringNo
FreightForwardAddress1ContainsquerystringNo
FreightForwardAddress1LikequerystringNo
FreightForwardAddress1Betweenquerystring[]No
FreightForwardAddress1Inquerystring[]No
FreightForwardAddress2querystringNo
FreightForwardAddress2StartsWithquerystringNo
FreightForwardAddress2EndsWithquerystringNo
FreightForwardAddress2ContainsquerystringNo
FreightForwardAddress2LikequerystringNo
FreightForwardAddress2Betweenquerystring[]No
FreightForwardAddress2Inquerystring[]No
FreightForwardAddress3querystringNo
FreightForwardAddress3StartsWithquerystringNo
FreightForwardAddress3EndsWithquerystringNo
FreightForwardAddress3ContainsquerystringNo
FreightForwardAddress3LikequerystringNo
FreightForwardAddress3Betweenquerystring[]No
FreightForwardAddress3Inquerystring[]No
FreightForwardAddress4querystringNo
FreightForwardAddress4StartsWithquerystringNo
FreightForwardAddress4EndsWithquerystringNo
FreightForwardAddress4ContainsquerystringNo
FreightForwardAddress4LikequerystringNo
FreightForwardAddress4Betweenquerystring[]No
FreightForwardAddress4Inquerystring[]No
FreightForwardNotesquerystringNo
FreightForwardNotesStartsWithquerystringNo
FreightForwardNotesEndsWithquerystringNo
FreightForwardNotesContainsquerystringNo
FreightForwardNotesLikequerystringNo
FreightForwardNotesBetweenquerystring[]No
FreightForwardNotesInquerystring[]No
ExpectedCloseDatequeryDateTime?No
ExpectedCloseDateGreaterThanOrEqualToqueryDateTime?No
ExpectedCloseDateGreaterThanqueryDateTime?No
ExpectedCloseDateLessThanqueryDateTime?No
ExpectedCloseDateLessThanOrEqualToqueryDateTime?No
ExpectedCloseDateNotEqualToqueryDateTime?No
ExpectedCloseDateBetweenqueryNullable<DateTime>[]No
ExpectedCloseDateInqueryNullable<DateTime>[]No
OpportunityStatusquerybyte?No
OpportunityStatusGreaterThanOrEqualToquerybyte?No
OpportunityStatusGreaterThanquerybyte?No
OpportunityStatusLessThanquerybyte?No
OpportunityStatusLessThanOrEqualToquerybyte?No
OpportunityStatusNotEqualToquerybyte?No
OpportunityStatusBetweenqueryNullable<Byte>[]No
OpportunityStatusInqueryNullable<Byte>[]No
SalesStageIDquerystringNo
SalesStageIDStartsWithquerystringNo
SalesStageIDEndsWithquerystringNo
SalesStageIDContainsquerystringNo
SalesStageIDLikequerystringNo
SalesStageIDBetweenquerystring[]No
SalesStageIDInquerystring[]No
OpportunityStatusReasonIDquerystringNo
OpportunityStatusReasonIDStartsWithquerystringNo
OpportunityStatusReasonIDEndsWithquerystringNo
OpportunityStatusReasonIDContainsquerystringNo
OpportunityStatusReasonIDLikequerystringNo
OpportunityStatusReasonIDBetweenquerystring[]No
OpportunityStatusReasonIDInquerystring[]No
OpportunityNotequerystringNo
OpportunityNoteStartsWithquerystringNo
OpportunityNoteEndsWithquerystringNo
OpportunityNoteContainsquerystringNo
OpportunityNoteLikequerystringNo
OpportunityNoteBetweenquerystring[]No
OpportunityNoteInquerystring[]No
InvoiceEmailedquerybool?No
DropShipmentquerybool?No
DeliveryAddresseequerystringNo
DeliveryAddresseeStartsWithquerystringNo
DeliveryAddresseeEndsWithquerystringNo
DeliveryAddresseeContainsquerystringNo
DeliveryAddresseeLikequerystringNo
DeliveryAddresseeBetweenquerystring[]No
DeliveryAddresseeInquerystring[]No
DeliveryAddressCountryquerystringNo
DeliveryAddressCountryStartsWithquerystringNo
DeliveryAddressCountryEndsWithquerystringNo
DeliveryAddressCountryContainsquerystringNo
DeliveryAddressCountryLikequerystringNo
DeliveryAddressCountryBetweenquerystring[]No
DeliveryAddressCountryInquerystring[]No
FreightForwardAddressCountryquerystringNo
FreightForwardAddressCountryStartsWithquerystringNo
FreightForwardAddressCountryEndsWithquerystringNo
FreightForwardAddressCountryContainsquerystringNo
FreightForwardAddressCountryLikequerystringNo
FreightForwardAddressCountryBetweenquerystring[]No
FreightForwardAddressCountryInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
QO_History Parameters:
NameParameterData TypeRequiredDescription
InvoiceHistoryIDformstringNo
InvoiceIDformstringNo
LastModifiedByformstringNo
RecordDateformDateTimeNo
RefformstringNo
HistoryNoformshort?No
HistoryTotalformdecimal?No
DocketPrintedformboolNo
DelAddress1formstringNo
DelAddress2formstringNo
DelAddress3formstringNo
DelAddress4formstringNo
PostCodeformstringNo
NotesformstringNo
CourierDetailsformstringNo
InvoicePrintedformboolNo
CartageCharge1formdecimal?No
CartageCharge2formdecimal?No
CartageCharge3formdecimal?No
ExpiryDateformDateTime?No
Cartage1TaxRateIDformstringNo
Cartage1TaxRateformdecimal?No
Cartage1TaxAmountformdecimal?No
Cartage2TaxRateIDformstringNo
Cartage2TaxRateformdecimal?No
Cartage2TaxAmountformdecimal?No
Cartage3TaxRateIDformstringNo
Cartage3TaxRateformdecimal?No
Cartage3TaxAmountformdecimal?No
DelContactNameformstringNo
FreightForwardAddress1formstringNo
FreightForwardAddress2formstringNo
FreightForwardAddress3formstringNo
FreightForwardAddress4formstringNo
FreightForwardNotesformstringNo
ExpectedCloseDateformDateTime?No
OpportunityStatusformbyte?No
SalesStageIDformstringNo
OpportunityStatusReasonIDformstringNo
OpportunityNoteformstringNo
InvoiceEmailedformbool?No
DropShipmentformboolNo
DeliveryAddresseeformstringNo
DeliveryAddressCountryformstringNo
FreightForwardAddressCountryformstringNo
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 .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.

POST /csv/reply/QO_HistoryQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["String"],"InvoiceID":"String","InvoiceIDStartsWith":"String","InvoiceIDEndsWith":"String","InvoiceIDContains":"String","InvoiceIDLike":"String","InvoiceIDBetween":["String"],"InvoiceIDIn":["String"],"LastModifiedBy":"String","LastModifiedByStartsWith":"String","LastModifiedByEndsWith":"String","LastModifiedByContains":"String","LastModifiedByLike":"String","LastModifiedByBetween":["String"],"LastModifiedByIn":["String"],"RecordDate":"0001-01-01T00:00:00.0000000","RecordDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","RecordDateGreaterThan":"0001-01-01T00:00:00.0000000","RecordDateLessThan":"0001-01-01T00:00:00.0000000","RecordDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","RecordDateNotEqualTo":"0001-01-01T00:00:00.0000000","RecordDateBetween":["0001-01-01T00:00:00.0000000"],"RecordDateIn":["0001-01-01T00:00:00.0000000"],"Ref":"String","RefStartsWith":"String","RefEndsWith":"String","RefContains":"String","RefLike":"String","RefBetween":["String"],"RefIn":["String"],"HistoryNo":0,"HistoryNoGreaterThanOrEqualTo":0,"HistoryNoGreaterThan":0,"HistoryNoLessThan":0,"HistoryNoLessThanOrEqualTo":0,"HistoryNoNotEqualTo":0,"HistoryNoBetween":[0],"HistoryNoIn":[0],"HistoryTotal":0,"HistoryTotalGreaterThanOrEqualTo":0,"HistoryTotalGreaterThan":0,"HistoryTotalLessThan":0,"HistoryTotalLessThanOrEqualTo":0,"HistoryTotalNotEqualTo":0,"HistoryTotalBetween":[0],"HistoryTotalIn":[0],"DocketPrinted":false,"DelAddress1":"String","DelAddress1StartsWith":"String","DelAddress1EndsWith":"String","DelAddress1Contains":"String","DelAddress1Like":"String","DelAddress1Between":["String"],"DelAddress1In":["String"],"DelAddress2":"String","DelAddress2StartsWith":"String","DelAddress2EndsWith":"String","DelAddress2Contains":"String","DelAddress2Like":"String","DelAddress2Between":["String"],"DelAddress2In":["String"],"DelAddress3":"String","DelAddress3StartsWith":"String","DelAddress3EndsWith":"String","DelAddress3Contains":"String","DelAddress3Like":"String","DelAddress3Between":["String"],"DelAddress3In":["String"],"DelAddress4":"String","DelAddress4StartsWith":"String","DelAddress4EndsWith":"String","DelAddress4Contains":"String","DelAddress4Like":"String","DelAddress4Between":["String"],"DelAddress4In":["String"],"PostCode":"String","PostCodeStartsWith":"String","PostCodeEndsWith":"String","PostCodeContains":"String","PostCodeLike":"String","PostCodeBetween":["String"],"PostCodeIn":["String"],"Notes":"String","NotesStartsWith":"String","NotesEndsWith":"String","NotesContains":"String","NotesLike":"String","NotesBetween":["String"],"NotesIn":["String"],"CourierDetails":"String","CourierDetailsStartsWith":"String","CourierDetailsEndsWith":"String","CourierDetailsContains":"String","CourierDetailsLike":"String","CourierDetailsBetween":["String"],"CourierDetailsIn":["String"],"InvoicePrinted":false,"CartageCharge1":0,"CartageCharge1GreaterThanOrEqualTo":0,"CartageCharge1GreaterThan":0,"CartageCharge1LessThan":0,"CartageCharge1LessThanOrEqualTo":0,"CartageCharge1NotEqualTo":0,"CartageCharge1Between":[0],"CartageCharge1In":[0],"CartageCharge2":0,"CartageCharge2GreaterThanOrEqualTo":0,"CartageCharge2GreaterThan":0,"CartageCharge2LessThan":0,"CartageCharge2LessThanOrEqualTo":0,"CartageCharge2NotEqualTo":0,"CartageCharge2Between":[0],"CartageCharge2In":[0],"CartageCharge3":0,"CartageCharge3GreaterThanOrEqualTo":0,"CartageCharge3GreaterThan":0,"CartageCharge3LessThan":0,"CartageCharge3LessThanOrEqualTo":0,"CartageCharge3NotEqualTo":0,"CartageCharge3Between":[0],"CartageCharge3In":[0],"ExpiryDate":"0001-01-01T00:00:00.0000000","ExpiryDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateGreaterThan":"0001-01-01T00:00:00.0000000","ExpiryDateLessThan":"0001-01-01T00:00:00.0000000","ExpiryDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateNotEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateBetween":["0001-01-01T00:00:00.0000000"],"ExpiryDateIn":["0001-01-01T00:00:00.0000000"],"Cartage1TaxRateID":"String","Cartage1TaxRateIDStartsWith":"String","Cartage1TaxRateIDEndsWith":"String","Cartage1TaxRateIDContains":"String","Cartage1TaxRateIDLike":"String","Cartage1TaxRateIDBetween":["String"],"Cartage1TaxRateIDIn":["String"],"Cartage1TaxRate":0,"Cartage1TaxRateGreaterThanOrEqualTo":0,"Cartage1TaxRateGreaterThan":0,"Cartage1TaxRateLessThan":0,"Cartage1TaxRateLessThanOrEqualTo":0,"Cartage1TaxRateNotEqualTo":0,"Cartage1TaxRateBetween":[0],"Cartage1TaxRateIn":[0],"Cartage1TaxAmount":0,"Cartage1TaxAmountGreaterThanOrEqualTo":0,"Cartage1TaxAmountGreaterThan":0,"Cartage1TaxAmountLessThan":0,"Cartage1TaxAmountLessThanOrEqualTo":0,"Cartage1TaxAmountNotEqualTo":0,"Cartage1TaxAmountBetween":[0],"Cartage1TaxAmountIn":[0],"Cartage2TaxRateID":"String","Cartage2TaxRateIDStartsWith":"String","Cartage2TaxRateIDEndsWith":"String","Cartage2TaxRateIDContains":"String","Cartage2TaxRateIDLike":"String","Cartage2TaxRateIDBetween":["String"],"Cartage2TaxRateIDIn":["String"],"Cartage2TaxRate":0,"Cartage2TaxRateGreaterThanOrEqualTo":0,"Cartage2TaxRateGreaterThan":0,"Cartage2TaxRateLessThan":0,"Cartage2TaxRateLessThanOrEqualTo":0,"Cartage2TaxRateNotEqualTo":0,"Cartage2TaxRateBetween":[0],"Cartage2TaxRateIn":[0],"Cartage2TaxAmount":0,"Cartage2TaxAmountGreaterThanOrEqualTo":0,"Cartage2TaxAmountGreaterThan":0,"Cartage2TaxAmountLessThan":0,"Cartage2TaxAmountLessThanOrEqualTo":0,"Cartage2TaxAmountNotEqualTo":0,"Cartage2TaxAmountBetween":[0],"Cartage2TaxAmountIn":[0],"Cartage3TaxRateID":"String","Cartage3TaxRateIDStartsWith":"String","Cartage3TaxRateIDEndsWith":"String","Cartage3TaxRateIDContains":"String","Cartage3TaxRateIDLike":"String","Cartage3TaxRateIDBetween":["String"],"Cartage3TaxRateIDIn":["String"],"Cartage3TaxRate":0,"Cartage3TaxRateGreaterThanOrEqualTo":0,"Cartage3TaxRateGreaterThan":0,"Cartage3TaxRateLessThan":0,"Cartage3TaxRateLessThanOrEqualTo":0,"Cartage3TaxRateNotEqualTo":0,"Cartage3TaxRateBetween":[0],"Cartage3TaxRateIn":[0],"Cartage3TaxAmount":0,"Cartage3TaxAmountGreaterThanOrEqualTo":0,"Cartage3TaxAmountGreaterThan":0,"Cartage3TaxAmountLessThan":0,"Cartage3TaxAmountLessThanOrEqualTo":0,"Cartage3TaxAmountNotEqualTo":0,"Cartage3TaxAmountBetween":[0],"Cartage3TaxAmountIn":[0],"DelContactName":"String","DelContactNameStartsWith":"String","DelContactNameEndsWith":"String","DelContactNameContains":"String","DelContactNameLike":"String","DelContactNameBetween":["String"],"DelContactNameIn":["String"],"FreightForwardAddress1":"String","FreightForwardAddress1StartsWith":"String","FreightForwardAddress1EndsWith":"String","FreightForwardAddress1Contains":"String","FreightForwardAddress1Like":"String","FreightForwardAddress1Between":["String"],"FreightForwardAddress1In":["String"],"FreightForwardAddress2":"String","FreightForwardAddress2StartsWith":"String","FreightForwardAddress2EndsWith":"String","FreightForwardAddress2Contains":"String","FreightForwardAddress2Like":"String","FreightForwardAddress2Between":["String"],"FreightForwardAddress2In":["String"],"FreightForwardAddress3":"String","FreightForwardAddress3StartsWith":"String","FreightForwardAddress3EndsWith":"String","FreightForwardAddress3Contains":"String","FreightForwardAddress3Like":"String","FreightForwardAddress3Between":["String"],"FreightForwardAddress3In":["String"],"FreightForwardAddress4":"String","FreightForwardAddress4StartsWith":"String","FreightForwardAddress4EndsWith":"String","FreightForwardAddress4Contains":"String","FreightForwardAddress4Like":"String","FreightForwardAddress4Between":["String"],"FreightForwardAddress4In":["String"],"FreightForwardNotes":"String","FreightForwardNotesStartsWith":"String","FreightForwardNotesEndsWith":"String","FreightForwardNotesContains":"String","FreightForwardNotesLike":"String","FreightForwardNotesBetween":["String"],"FreightForwardNotesIn":["String"],"ExpectedCloseDate":"0001-01-01T00:00:00.0000000","ExpectedCloseDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpectedCloseDateGreaterThan":"0001-01-01T00:00:00.0000000","ExpectedCloseDateLessThan":"0001-01-01T00:00:00.0000000","ExpectedCloseDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpectedCloseDateNotEqualTo":"0001-01-01T00:00:00.0000000","ExpectedCloseDateBetween":["0001-01-01T00:00:00.0000000"],"ExpectedCloseDateIn":["0001-01-01T00:00:00.0000000"],"OpportunityStatus":0,"OpportunityStatusGreaterThanOrEqualTo":0,"OpportunityStatusGreaterThan":0,"OpportunityStatusLessThan":0,"OpportunityStatusLessThanOrEqualTo":0,"OpportunityStatusNotEqualTo":0,"OpportunityStatusBetween":[0],"OpportunityStatusIn":[0],"SalesStageID":"String","SalesStageIDStartsWith":"String","SalesStageIDEndsWith":"String","SalesStageIDContains":"String","SalesStageIDLike":"String","SalesStageIDBetween":["String"],"SalesStageIDIn":["String"],"OpportunityStatusReasonID":"String","OpportunityStatusReasonIDStartsWith":"String","OpportunityStatusReasonIDEndsWith":"String","OpportunityStatusReasonIDContains":"String","OpportunityStatusReasonIDLike":"String","OpportunityStatusReasonIDBetween":["String"],"OpportunityStatusReasonIDIn":["String"],"OpportunityNote":"String","OpportunityNoteStartsWith":"String","OpportunityNoteEndsWith":"String","OpportunityNoteContains":"String","OpportunityNoteLike":"String","OpportunityNoteBetween":["String"],"OpportunityNoteIn":["String"],"InvoiceEmailed":false,"DropShipment":false,"DeliveryAddressee":"String","DeliveryAddresseeStartsWith":"String","DeliveryAddresseeEndsWith":"String","DeliveryAddresseeContains":"String","DeliveryAddresseeLike":"String","DeliveryAddresseeBetween":["String"],"DeliveryAddresseeIn":["String"],"DeliveryAddressCountry":"String","DeliveryAddressCountryStartsWith":"String","DeliveryAddressCountryEndsWith":"String","DeliveryAddressCountryContains":"String","DeliveryAddressCountryLike":"String","DeliveryAddressCountryBetween":["String"],"DeliveryAddressCountryIn":["String"],"FreightForwardAddressCountry":"String","FreightForwardAddressCountryStartsWith":"String","FreightForwardAddressCountryEndsWith":"String","FreightForwardAddressCountryContains":"String","FreightForwardAddressCountryLike":"String","FreightForwardAddressCountryBetween":["String"],"FreightForwardAddressCountryIn":["String"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"InvoiceHistoryID":"String","InvoiceID":"String","LastModifiedBy":"String","Ref":"String","HistoryNo":0,"HistoryTotal":0,"DelAddress1":"String","DelAddress2":"String","DelAddress3":"String","DelAddress4":"String","PostCode":"String","Notes":"String","CourierDetails":"String","CartageCharge1":0,"CartageCharge2":0,"CartageCharge3":0,"ExpiryDate":"0001-01-01T00:00:00.0000000","Cartage1TaxRateID":"String","Cartage1TaxRate":0,"Cartage1TaxAmount":0,"Cartage2TaxRateID":"String","Cartage2TaxRate":0,"Cartage2TaxAmount":0,"Cartage3TaxRateID":"String","Cartage3TaxRate":0,"Cartage3TaxAmount":0,"DelContactName":"String","FreightForwardAddress1":"String","FreightForwardAddress2":"String","FreightForwardAddress3":"String","FreightForwardAddress4":"String","FreightForwardNotes":"String","ExpectedCloseDate":"0001-01-01T00:00:00.0000000","OpportunityStatus":0,"SalesStageID":"String","OpportunityStatusReasonID":"String","OpportunityNote":"String","InvoiceEmailed":false,"DeliveryAddressee":"String","DeliveryAddressCountry":"String","FreightForwardAddressCountry":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}