| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| BatchLineID | query | string | No | |
| BatchLineIDStartsWith | query | string | No | |
| BatchLineIDEndsWith | query | string | No | |
| BatchLineIDContains | query | string | No | |
| BatchLineIDLike | query | string | No | |
| BatchLineIDBetween | query | string[] | No | |
| BatchLineIDIn | query | string[] | No | |
| BatchID | query | string | No | |
| BatchIDStartsWith | query | string | No | |
| BatchIDEndsWith | query | string | No | |
| BatchIDContains | query | string | No | |
| BatchIDLike | query | string | No | |
| BatchIDBetween | query | string[] | No | |
| BatchIDIn | query | string[] | No | |
| DestInvoiceID | query | string | No | |
| DestInvoiceIDStartsWith | query | string | No | |
| DestInvoiceIDEndsWith | query | string | No | |
| DestInvoiceIDContains | query | string | No | |
| DestInvoiceIDLike | query | string | No | |
| DestInvoiceIDBetween | query | string[] | No | |
| DestInvoiceIDIn | query | string[] | No | |
| DestInvoiceNo | query | string | No | |
| DestInvoiceNoStartsWith | query | string | No | |
| DestInvoiceNoEndsWith | query | string | No | |
| DestInvoiceNoContains | query | string | No | |
| DestInvoiceNoLike | query | string | No | |
| DestInvoiceNoBetween | query | string[] | No | |
| DestInvoiceNoIn | query | string[] | No | |
| SourceQuoteID | query | string | No | |
| SourceQuoteIDStartsWith | query | string | No | |
| SourceQuoteIDEndsWith | query | string | No | |
| SourceQuoteIDContains | query | string | No | |
| SourceQuoteIDLike | query | string | No | |
| SourceQuoteIDBetween | query | string[] | No | |
| SourceQuoteIDIn | query | string[] | No | |
| SourceQuoteNo | query | string | No | |
| SourceQuoteNoStartsWith | query | string | No | |
| SourceQuoteNoEndsWith | query | string | No | |
| SourceQuoteNoContains | query | string | No | |
| SourceQuoteNoLike | query | string | No | |
| SourceQuoteNoBetween | query | string[] | No | |
| SourceQuoteNoIn | query | string[] | No | |
| SourceQuoteHistoryID | query | string | No | |
| SourceQuoteHistoryIDStartsWith | query | string | No | |
| SourceQuoteHistoryIDEndsWith | query | string | No | |
| SourceQuoteHistoryIDContains | query | string | No | |
| SourceQuoteHistoryIDLike | query | string | No | |
| SourceQuoteHistoryIDBetween | query | string[] | No | |
| SourceQuoteHistoryIDIn | query | string[] | No | |
| SourceQuoteHistoryNo | query | short? | No | |
| SourceQuoteHistoryNoGreaterThanOrEqualTo | query | short? | No | |
| SourceQuoteHistoryNoGreaterThan | query | short? | No | |
| SourceQuoteHistoryNoLessThan | query | short? | No | |
| SourceQuoteHistoryNoLessThanOrEqualTo | query | short? | No | |
| SourceQuoteHistoryNoNotEqualTo | query | short? | No | |
| SourceQuoteHistoryNoBetween | query | Nullable<Int16>[] | No | |
| SourceQuoteHistoryNoIn | query | Nullable<Int16>[] | No | |
| SourceQuoteTotal | query | decimal? | No | |
| SourceQuoteTotalGreaterThanOrEqualTo | query | decimal? | No | |
| SourceQuoteTotalGreaterThan | query | decimal? | No | |
| SourceQuoteTotalLessThan | query | decimal? | No | |
| SourceQuoteTotalLessThanOrEqualTo | query | decimal? | No | |
| SourceQuoteTotalNotEqualTo | query | decimal? | No | |
| SourceQuoteTotalBetween | query | Nullable<Decimal>[] | No | |
| SourceQuoteTotalIn | query | Nullable<Decimal>[] | No | |
| DebtorID | query | string | No | |
| DebtorIDStartsWith | query | string | No | |
| DebtorIDEndsWith | query | string | No | |
| DebtorIDContains | query | string | No | |
| DebtorIDLike | query | string | No | |
| DebtorIDBetween | query | string[] | No | |
| DebtorIDIn | query | string[] | No | |
| QuoteInitDate | query | DateTime? | No | |
| QuoteInitDateGreaterThanOrEqualTo | query | DateTime? | No | |
| QuoteInitDateGreaterThan | query | DateTime? | No | |
| QuoteInitDateLessThan | query | DateTime? | No | |
| QuoteInitDateLessThanOrEqualTo | query | DateTime? | No | |
| QuoteInitDateNotEqualTo | query | DateTime? | No | |
| QuoteInitDateBetween | query | Nullable<DateTime>[] | No | |
| QuoteInitDateIn | query | Nullable<DateTime>[] | No | |
| NextActivateDate | query | DateTime? | No | |
| NextActivateDateGreaterThanOrEqualTo | query | DateTime? | No | |
| NextActivateDateGreaterThan | query | DateTime? | No | |
| NextActivateDateLessThan | query | DateTime? | No | |
| NextActivateDateLessThanOrEqualTo | query | DateTime? | No | |
| NextActivateDateNotEqualTo | query | DateTime? | No | |
| NextActivateDateBetween | query | Nullable<DateTime>[] | No | |
| NextActivateDateIn | query | Nullable<DateTime>[] | No | |
| Failed | query | bool? | No | |
| FailReason | query | string | No | |
| FailReasonStartsWith | query | string | No | |
| FailReasonEndsWith | query | string | No | |
| FailReasonContains | query | string | No | |
| FailReasonLike | query | string | No | |
| FailReasonBetween | query | string[] | No | |
| FailReasonIn | query | string[] | No | |
| DocType | query | short? | No | |
| DocTypeGreaterThanOrEqualTo | query | short? | No | |
| DocTypeGreaterThan | query | short? | No | |
| DocTypeLessThan | query | short? | No | |
| DocTypeLessThanOrEqualTo | query | short? | No | |
| DocTypeNotEqualTo | query | short? | No | |
| DocTypeBetween | query | Nullable<Int16>[] | No | |
| DocTypeIn | query | Nullable<Int16>[] | 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 |
|---|---|---|---|---|
| BatchLineID | form | string | No | |
| BatchID | form | string | No | |
| DestInvoiceID | form | string | No | |
| DestInvoiceNo | form | string | No | |
| SourceQuoteID | form | string | No | |
| SourceQuoteNo | form | string | No | |
| SourceQuoteHistoryID | form | string | No | |
| SourceQuoteHistoryNo | form | short? | No | |
| SourceQuoteTotal | form | decimal? | No | |
| DebtorID | form | string | No | |
| QuoteInitDate | form | DateTime? | No | |
| NextActivateDate | form | DateTime? | No | |
| Failed | form | bool | No | |
| FailReason | form | string | No | |
| DocType | form | short? | 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_ActivateBatchLinesQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"BatchLineID":"String","BatchLineIDStartsWith":"String","BatchLineIDEndsWith":"String","BatchLineIDContains":"String","BatchLineIDLike":"String","BatchLineIDBetween":["String"],"BatchLineIDIn":["String"],"BatchID":"String","BatchIDStartsWith":"String","BatchIDEndsWith":"String","BatchIDContains":"String","BatchIDLike":"String","BatchIDBetween":["String"],"BatchIDIn":["String"],"DestInvoiceID":"String","DestInvoiceIDStartsWith":"String","DestInvoiceIDEndsWith":"String","DestInvoiceIDContains":"String","DestInvoiceIDLike":"String","DestInvoiceIDBetween":["String"],"DestInvoiceIDIn":["String"],"DestInvoiceNo":"String","DestInvoiceNoStartsWith":"String","DestInvoiceNoEndsWith":"String","DestInvoiceNoContains":"String","DestInvoiceNoLike":"String","DestInvoiceNoBetween":["String"],"DestInvoiceNoIn":["String"],"SourceQuoteID":"String","SourceQuoteIDStartsWith":"String","SourceQuoteIDEndsWith":"String","SourceQuoteIDContains":"String","SourceQuoteIDLike":"String","SourceQuoteIDBetween":["String"],"SourceQuoteIDIn":["String"],"SourceQuoteNo":"String","SourceQuoteNoStartsWith":"String","SourceQuoteNoEndsWith":"String","SourceQuoteNoContains":"String","SourceQuoteNoLike":"String","SourceQuoteNoBetween":["String"],"SourceQuoteNoIn":["String"],"SourceQuoteHistoryID":"String","SourceQuoteHistoryIDStartsWith":"String","SourceQuoteHistoryIDEndsWith":"String","SourceQuoteHistoryIDContains":"String","SourceQuoteHistoryIDLike":"String","SourceQuoteHistoryIDBetween":["String"],"SourceQuoteHistoryIDIn":["String"],"SourceQuoteHistoryNo":0,"SourceQuoteHistoryNoGreaterThanOrEqualTo":0,"SourceQuoteHistoryNoGreaterThan":0,"SourceQuoteHistoryNoLessThan":0,"SourceQuoteHistoryNoLessThanOrEqualTo":0,"SourceQuoteHistoryNoNotEqualTo":0,"SourceQuoteHistoryNoBetween":[0],"SourceQuoteHistoryNoIn":[0],"SourceQuoteTotal":0,"SourceQuoteTotalGreaterThanOrEqualTo":0,"SourceQuoteTotalGreaterThan":0,"SourceQuoteTotalLessThan":0,"SourceQuoteTotalLessThanOrEqualTo":0,"SourceQuoteTotalNotEqualTo":0,"SourceQuoteTotalBetween":[0],"SourceQuoteTotalIn":[0],"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["String"],"QuoteInitDate":"0001-01-01T00:00:00.0000000","QuoteInitDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","QuoteInitDateGreaterThan":"0001-01-01T00:00:00.0000000","QuoteInitDateLessThan":"0001-01-01T00:00:00.0000000","QuoteInitDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","QuoteInitDateNotEqualTo":"0001-01-01T00:00:00.0000000","QuoteInitDateBetween":["0001-01-01T00:00:00.0000000"],"QuoteInitDateIn":["0001-01-01T00:00:00.0000000"],"NextActivateDate":"0001-01-01T00:00:00.0000000","NextActivateDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","NextActivateDateGreaterThan":"0001-01-01T00:00:00.0000000","NextActivateDateLessThan":"0001-01-01T00:00:00.0000000","NextActivateDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","NextActivateDateNotEqualTo":"0001-01-01T00:00:00.0000000","NextActivateDateBetween":["0001-01-01T00:00:00.0000000"],"NextActivateDateIn":["0001-01-01T00:00:00.0000000"],"Failed":false,"FailReason":"String","FailReasonStartsWith":"String","FailReasonEndsWith":"String","FailReasonContains":"String","FailReasonLike":"String","FailReasonBetween":["String"],"FailReasonIn":["String"],"DocType":0,"DocTypeGreaterThanOrEqualTo":0,"DocTypeGreaterThan":0,"DocTypeLessThan":0,"DocTypeLessThanOrEqualTo":0,"DocTypeNotEqualTo":0,"DocTypeBetween":[0],"DocTypeIn":[0],"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":[{"BatchLineID":"String","BatchID":"String","DestInvoiceID":"String","DestInvoiceNo":"String","SourceQuoteID":"String","SourceQuoteNo":"String","SourceQuoteHistoryID":"String","SourceQuoteHistoryNo":0,"SourceQuoteTotal":0,"DebtorID":"String","QuoteInitDate":"0001-01-01T00:00:00.0000000","NextActivateDate":"0001-01-01T00:00:00.0000000","FailReason":"String","DocType":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}