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