Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
RecID | query | string | No | |
RecIDStartsWith | query | string | No | |
RecIDEndsWith | query | string | No | |
RecIDContains | query | string | No | |
RecIDLike | query | string | No | |
RecIDBetween | query | string[] | No | |
RecIDIn | query | string[] | No | |
DB_Adjustments_RecID | query | string | No | |
DB_Adjustments_RecIDStartsWith | query | string | No | |
DB_Adjustments_RecIDEndsWith | query | string | No | |
DB_Adjustments_RecIDContains | query | string | No | |
DB_Adjustments_RecIDLike | query | string | No | |
DB_Adjustments_RecIDBetween | query | string[] | No | |
DB_Adjustments_RecIDIn | query | string[] | No | |
ItemNo | query | int? | No | |
ItemNoGreaterThanOrEqualTo | query | int? | No | |
ItemNoGreaterThan | query | int? | No | |
ItemNoLessThan | query | int? | No | |
ItemNoLessThanOrEqualTo | query | int? | No | |
ItemNoNotEqualTo | query | int? | No | |
ItemNoBetween | query | int[] | No | |
ItemNoIn | query | int[] | 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 | DateTime[] | No | |
DueDateIn | query | DateTime[] | No | |
DB_Main_RecID | query | string | No | |
DB_Main_RecIDStartsWith | query | string | No | |
DB_Main_RecIDEndsWith | query | string | No | |
DB_Main_RecIDContains | query | string | No | |
DB_Main_RecIDLike | query | string | No | |
DB_Main_RecIDBetween | query | string[] | No | |
DB_Main_RecIDIn | query | string[] | No | |
GL_Ledger_RecID_DebtorsControl | query | string | No | |
GL_Ledger_RecID_DebtorsControlStartsWith | query | string | No | |
GL_Ledger_RecID_DebtorsControlEndsWith | query | string | No | |
GL_Ledger_RecID_DebtorsControlContains | query | string | No | |
GL_Ledger_RecID_DebtorsControlLike | query | string | No | |
GL_Ledger_RecID_DebtorsControlBetween | query | string[] | No | |
GL_Ledger_RecID_DebtorsControlIn | query | string[] | No | |
InvoiceRemittanceNo | query | string | No | |
InvoiceRemittanceNoStartsWith | query | string | No | |
InvoiceRemittanceNoEndsWith | query | string | No | |
InvoiceRemittanceNoContains | query | string | No | |
InvoiceRemittanceNoLike | query | string | No | |
InvoiceRemittanceNoBetween | query | string[] | No | |
InvoiceRemittanceNoIn | query | string[] | No | |
WriteOnAmount | query | decimal? | No | |
WriteOnAmountGreaterThanOrEqualTo | query | decimal? | No | |
WriteOnAmountGreaterThan | query | decimal? | No | |
WriteOnAmountLessThan | query | decimal? | No | |
WriteOnAmountLessThanOrEqualTo | query | decimal? | No | |
WriteOnAmountNotEqualTo | query | decimal? | No | |
WriteOnAmountBetween | query | decimal[] | No | |
WriteOnAmountIn | query | decimal[] | No | |
WriteOffAmount | query | decimal? | No | |
WriteOffAmountGreaterThanOrEqualTo | query | decimal? | No | |
WriteOffAmountGreaterThan | query | decimal? | No | |
WriteOffAmountLessThan | query | decimal? | No | |
WriteOffAmountLessThanOrEqualTo | query | decimal? | No | |
WriteOffAmountNotEqualTo | query | decimal? | No | |
WriteOffAmountBetween | query | decimal[] | No | |
WriteOffAmountIn | query | decimal[] | No | |
GL_Ledger_RecID_OtherLedger | query | string | No | |
GL_Ledger_RecID_OtherLedgerStartsWith | query | string | No | |
GL_Ledger_RecID_OtherLedgerEndsWith | query | string | No | |
GL_Ledger_RecID_OtherLedgerContains | query | string | No | |
GL_Ledger_RecID_OtherLedgerLike | query | string | No | |
GL_Ledger_RecID_OtherLedgerBetween | query | string[] | No | |
GL_Ledger_RecID_OtherLedgerIn | query | string[] | No | |
Reference | query | string | No | |
ReferenceStartsWith | query | string | No | |
ReferenceEndsWith | query | string | No | |
ReferenceContains | query | string | No | |
ReferenceLike | query | string | No | |
ReferenceBetween | query | string[] | No | |
ReferenceIn | query | string[] | No | |
Remark | query | string | No | |
RemarkStartsWith | query | string | No | |
RemarkEndsWith | query | string | No | |
RemarkContains | query | string | No | |
RemarkLike | query | string | No | |
RemarkBetween | query | string[] | No | |
RemarkIn | query | string[] | No | |
DB_Trans_RecID | query | string | No | |
DB_Trans_RecIDStartsWith | query | string | No | |
DB_Trans_RecIDEndsWith | query | string | No | |
DB_Trans_RecIDContains | query | string | No | |
DB_Trans_RecIDLike | query | string | No | |
DB_Trans_RecIDBetween | query | string[] | No | |
DB_Trans_RecIDIn | query | string[] | No | |
TX_Main_RecID | query | string | No | |
TX_Main_RecIDStartsWith | query | string | No | |
TX_Main_RecIDEndsWith | query | string | No | |
TX_Main_RecIDContains | query | string | No | |
TX_Main_RecIDLike | query | string | No | |
TX_Main_RecIDBetween | query | string[] | No | |
TX_Main_RecIDIn | query | string[] | No | |
TaxRate | query | decimal? | No | |
TaxRateGreaterThanOrEqualTo | query | decimal? | No | |
TaxRateGreaterThan | query | decimal? | No | |
TaxRateLessThan | query | decimal? | No | |
TaxRateLessThanOrEqualTo | query | decimal? | No | |
TaxRateNotEqualTo | query | decimal? | No | |
TaxRateBetween | query | decimal[] | No | |
TaxRateIn | query | decimal[] | No | |
TaxAmount | query | decimal? | No | |
TaxAmountGreaterThanOrEqualTo | query | decimal? | No | |
TaxAmountGreaterThan | query | decimal? | No | |
TaxAmountLessThan | query | decimal? | No | |
TaxAmountLessThanOrEqualTo | query | decimal? | No | |
TaxAmountNotEqualTo | query | decimal? | No | |
TaxAmountBetween | query | decimal[] | No | |
TaxAmountIn | query | decimal[] | 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 | DateTime[] | No | |
LastSavedDateTimeIn | query | DateTime[] | No | |
RowHash | query | byte[] | No | |
AdjustmentDate | query | DateTime? | No | |
AdjustmentDateGreaterThanOrEqualTo | query | DateTime? | No | |
AdjustmentDateGreaterThan | query | DateTime? | No | |
AdjustmentDateLessThan | query | DateTime? | No | |
AdjustmentDateLessThanOrEqualTo | query | DateTime? | No | |
AdjustmentDateNotEqualTo | query | DateTime? | No | |
AdjustmentDateBetween | query | DateTime[] | No | |
AdjustmentDateIn | query | DateTime[] | 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 |
---|---|---|---|---|
RecID | form | string | No | |
DB_Adjustments_RecID | form | string | No | |
ItemNo | form | int | No | |
DueDate | form | DateTime | No | |
DB_Main_RecID | form | string | No | |
GL_Ledger_RecID_DebtorsControl | form | string | No | |
InvoiceRemittanceNo | form | string | No | |
WriteOnAmount | form | decimal | No | |
WriteOffAmount | form | decimal | No | |
GL_Ledger_RecID_OtherLedger | form | string | No | |
Reference | form | string | No | |
Remark | form | string | No | |
DB_Trans_RecID | form | string | No | |
TX_Main_RecID | form | string | No | |
TaxRate | form | decimal | No | |
TaxAmount | form | decimal | No | |
LastSavedDateTime | form | DateTime | No | |
RowHash | form | byte[] | No | |
AdjustmentDate | form | DateTime | 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 .json suffix or ?format=json
To embed the response in a jsonp callback, append ?callback=myCallback
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /json/reply/DB_AdjustmentLinesQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: application/json
Content-Type: application/json
Content-Length: length
{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"DB_Adjustments_RecID":"String","DB_Adjustments_RecIDStartsWith":"String","DB_Adjustments_RecIDEndsWith":"String","DB_Adjustments_RecIDContains":"String","DB_Adjustments_RecIDLike":"String","DB_Adjustments_RecIDBetween":["String"],"DB_Adjustments_RecIDIn":["String"],"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"DueDate":"0001-01-01T00:00:00.0000000","DueDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DueDateGreaterThan":"0001-01-01T00:00:00.0000000","DueDateLessThan":"0001-01-01T00:00:00.0000000","DueDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DueDateNotEqualTo":"0001-01-01T00:00:00.0000000","DueDateBetween":["0001-01-01T00:00:00.0000000"],"DueDateIn":["0001-01-01T00:00:00.0000000"],"DB_Main_RecID":"String","DB_Main_RecIDStartsWith":"String","DB_Main_RecIDEndsWith":"String","DB_Main_RecIDContains":"String","DB_Main_RecIDLike":"String","DB_Main_RecIDBetween":["String"],"DB_Main_RecIDIn":["String"],"GL_Ledger_RecID_DebtorsControl":"String","GL_Ledger_RecID_DebtorsControlStartsWith":"String","GL_Ledger_RecID_DebtorsControlEndsWith":"String","GL_Ledger_RecID_DebtorsControlContains":"String","GL_Ledger_RecID_DebtorsControlLike":"String","GL_Ledger_RecID_DebtorsControlBetween":["String"],"GL_Ledger_RecID_DebtorsControlIn":["String"],"InvoiceRemittanceNo":"String","InvoiceRemittanceNoStartsWith":"String","InvoiceRemittanceNoEndsWith":"String","InvoiceRemittanceNoContains":"String","InvoiceRemittanceNoLike":"String","InvoiceRemittanceNoBetween":["String"],"InvoiceRemittanceNoIn":["String"],"WriteOnAmount":0,"WriteOnAmountGreaterThanOrEqualTo":0,"WriteOnAmountGreaterThan":0,"WriteOnAmountLessThan":0,"WriteOnAmountLessThanOrEqualTo":0,"WriteOnAmountNotEqualTo":0,"WriteOnAmountBetween":[0],"WriteOnAmountIn":[0],"WriteOffAmount":0,"WriteOffAmountGreaterThanOrEqualTo":0,"WriteOffAmountGreaterThan":0,"WriteOffAmountLessThan":0,"WriteOffAmountLessThanOrEqualTo":0,"WriteOffAmountNotEqualTo":0,"WriteOffAmountBetween":[0],"WriteOffAmountIn":[0],"GL_Ledger_RecID_OtherLedger":"String","GL_Ledger_RecID_OtherLedgerStartsWith":"String","GL_Ledger_RecID_OtherLedgerEndsWith":"String","GL_Ledger_RecID_OtherLedgerContains":"String","GL_Ledger_RecID_OtherLedgerLike":"String","GL_Ledger_RecID_OtherLedgerBetween":["String"],"GL_Ledger_RecID_OtherLedgerIn":["String"],"Reference":"String","ReferenceStartsWith":"String","ReferenceEndsWith":"String","ReferenceContains":"String","ReferenceLike":"String","ReferenceBetween":["String"],"ReferenceIn":["String"],"Remark":"String","RemarkStartsWith":"String","RemarkEndsWith":"String","RemarkContains":"String","RemarkLike":"String","RemarkBetween":["String"],"RemarkIn":["String"],"DB_Trans_RecID":"String","DB_Trans_RecIDStartsWith":"String","DB_Trans_RecIDEndsWith":"String","DB_Trans_RecIDContains":"String","DB_Trans_RecIDLike":"String","DB_Trans_RecIDBetween":["String"],"DB_Trans_RecIDIn":["String"],"TX_Main_RecID":"String","TX_Main_RecIDStartsWith":"String","TX_Main_RecIDEndsWith":"String","TX_Main_RecIDContains":"String","TX_Main_RecIDLike":"String","TX_Main_RecIDBetween":["String"],"TX_Main_RecIDIn":["String"],"TaxRate":0,"TaxRateGreaterThanOrEqualTo":0,"TaxRateGreaterThan":0,"TaxRateLessThan":0,"TaxRateLessThanOrEqualTo":0,"TaxRateNotEqualTo":0,"TaxRateBetween":[0],"TaxRateIn":[0],"TaxAmount":0,"TaxAmountGreaterThanOrEqualTo":0,"TaxAmountGreaterThan":0,"TaxAmountLessThan":0,"TaxAmountLessThanOrEqualTo":0,"TaxAmountNotEqualTo":0,"TaxAmountBetween":[0],"TaxAmountIn":[0],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"RowHash":"AA==","AdjustmentDate":"0001-01-01T00:00:00.0000000","AdjustmentDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","AdjustmentDateGreaterThan":"0001-01-01T00:00:00.0000000","AdjustmentDateLessThan":"0001-01-01T00:00:00.0000000","AdjustmentDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","AdjustmentDateNotEqualTo":"0001-01-01T00:00:00.0000000","AdjustmentDateBetween":["0001-01-01T00:00:00.0000000"],"AdjustmentDateIn":["0001-01-01T00:00:00.0000000"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK Content-Type: application/json Content-Length: length {"Results":[{"RecID":"String","DB_Adjustments_RecID":"String","DB_Main_RecID":"String","GL_Ledger_RecID_DebtorsControl":"String","InvoiceRemittanceNo":"String","GL_Ledger_RecID_OtherLedger":"String","Reference":"String","Remark":"String","DB_Trans_RecID":"String","TX_Main_RecID":"String","RowHash":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}