JiwaAPI

<back to all web services

RA_CreditExchangeLinesQuery

Requires Authentication
RA_CreditExchangeLinesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
RA_CreditMain_RecIDquerystringNo
RA_CreditMain_RecIDStartsWithquerystringNo
RA_CreditMain_RecIDEndsWithquerystringNo
RA_CreditMain_RecIDContainsquerystringNo
RA_CreditMain_RecIDLikequerystringNo
RA_CreditMain_RecIDBetweenquerystring[]No
RA_CreditMain_RecIDInquerystring[]No
RA_CreditLines_RecIDquerystringNo
RA_CreditLines_RecIDStartsWithquerystringNo
RA_CreditLines_RecIDEndsWithquerystringNo
RA_CreditLines_RecIDContainsquerystringNo
RA_CreditLines_RecIDLikequerystringNo
RA_CreditLines_RecIDBetweenquerystring[]No
RA_CreditLines_RecIDInquerystring[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenqueryNullable<Decimal>[]No
QuantityInqueryNullable<Decimal>[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
RemarkquerystringNo
RemarkStartsWithquerystringNo
RemarkEndsWithquerystringNo
RemarkContainsquerystringNo
RemarkLikequerystringNo
RemarkBetweenquerystring[]No
RemarkInquerystring[]No
TotalCreditValuequerydecimal?No
TotalCreditValueGreaterThanOrEqualToquerydecimal?No
TotalCreditValueGreaterThanquerydecimal?No
TotalCreditValueLessThanquerydecimal?No
TotalCreditValueLessThanOrEqualToquerydecimal?No
TotalCreditValueNotEqualToquerydecimal?No
TotalCreditValueBetweenqueryNullable<Decimal>[]No
TotalCreditValueInqueryNullable<Decimal>[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
TaxIDquerystringNo
TaxIDStartsWithquerystringNo
TaxIDEndsWithquerystringNo
TaxIDContainsquerystringNo
TaxIDLikequerystringNo
TaxIDBetweenquerystring[]No
TaxIDInquerystring[]No
TaxAmountquerydecimal?No
TaxAmountGreaterThanOrEqualToquerydecimal?No
TaxAmountGreaterThanquerydecimal?No
TaxAmountLessThanquerydecimal?No
TaxAmountLessThanOrEqualToquerydecimal?No
TaxAmountNotEqualToquerydecimal?No
TaxAmountBetweenqueryNullable<Decimal>[]No
TaxAmountInqueryNullable<Decimal>[]No
RowHashquerybyte[]No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
FXUnitCreditValuequerydecimal?No
FXUnitCreditValueGreaterThanOrEqualToquerydecimal?No
FXUnitCreditValueGreaterThanquerydecimal?No
FXUnitCreditValueLessThanquerydecimal?No
FXUnitCreditValueLessThanOrEqualToquerydecimal?No
FXUnitCreditValueNotEqualToquerydecimal?No
FXUnitCreditValueBetweenquerydecimal[]No
FXUnitCreditValueInquerydecimal[]No
FXTotalCreditValuequerydecimal?No
FXTotalCreditValueGreaterThanOrEqualToquerydecimal?No
FXTotalCreditValueGreaterThanquerydecimal?No
FXTotalCreditValueLessThanquerydecimal?No
FXTotalCreditValueLessThanOrEqualToquerydecimal?No
FXTotalCreditValueNotEqualToquerydecimal?No
FXTotalCreditValueBetweenquerydecimal[]No
FXTotalCreditValueInquerydecimal[]No
FXRatequerydecimal?No
FXRateGreaterThanOrEqualToquerydecimal?No
FXRateGreaterThanquerydecimal?No
FXRateLessThanquerydecimal?No
FXRateLessThanOrEqualToquerydecimal?No
FXRateNotEqualToquerydecimal?No
FXRateBetweenquerydecimal[]No
FXRateInquerydecimal[]No
UnitCreditValuequerydecimal?No
UnitCreditValueGreaterThanOrEqualToquerydecimal?No
UnitCreditValueGreaterThanquerydecimal?No
UnitCreditValueLessThanquerydecimal?No
UnitCreditValueLessThanOrEqualToquerydecimal?No
UnitCreditValueNotEqualToquerydecimal?No
UnitCreditValueBetweenqueryNullable<Decimal>[]No
UnitCreditValueInqueryNullable<Decimal>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
RA_CreditExchangeLines Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
RA_CreditMain_RecIDformstringNo
RA_CreditLines_RecIDformstringNo
Quantityformdecimal?No
LastSavedDateTimeformDateTimeNo
RemarkformstringNo
TotalCreditValueformdecimal?No
InventoryIDformstringNo
TaxIDformstringNo
TaxAmountformdecimal?No
RowHashformbyte[]No
ItemNoformintNo
FXUnitCreditValueformdecimalNo
FXTotalCreditValueformdecimalNo
FXRateformdecimalNo
UnitCreditValueformdecimal?No
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.

POST /json/reply/RA_CreditExchangeLinesQuery 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"],"RA_CreditMain_RecID":"String","RA_CreditMain_RecIDStartsWith":"String","RA_CreditMain_RecIDEndsWith":"String","RA_CreditMain_RecIDContains":"String","RA_CreditMain_RecIDLike":"String","RA_CreditMain_RecIDBetween":["String"],"RA_CreditMain_RecIDIn":["String"],"RA_CreditLines_RecID":"String","RA_CreditLines_RecIDStartsWith":"String","RA_CreditLines_RecIDEndsWith":"String","RA_CreditLines_RecIDContains":"String","RA_CreditLines_RecIDLike":"String","RA_CreditLines_RecIDBetween":["String"],"RA_CreditLines_RecIDIn":["String"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[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"],"Remark":"String","RemarkStartsWith":"String","RemarkEndsWith":"String","RemarkContains":"String","RemarkLike":"String","RemarkBetween":["String"],"RemarkIn":["String"],"TotalCreditValue":0,"TotalCreditValueGreaterThanOrEqualTo":0,"TotalCreditValueGreaterThan":0,"TotalCreditValueLessThan":0,"TotalCreditValueLessThanOrEqualTo":0,"TotalCreditValueNotEqualTo":0,"TotalCreditValueBetween":[0],"TotalCreditValueIn":[0],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"TaxAmount":0,"TaxAmountGreaterThanOrEqualTo":0,"TaxAmountGreaterThan":0,"TaxAmountLessThan":0,"TaxAmountLessThanOrEqualTo":0,"TaxAmountNotEqualTo":0,"TaxAmountBetween":[0],"TaxAmountIn":[0],"RowHash":"AA==","ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"FXUnitCreditValue":0,"FXUnitCreditValueGreaterThanOrEqualTo":0,"FXUnitCreditValueGreaterThan":0,"FXUnitCreditValueLessThan":0,"FXUnitCreditValueLessThanOrEqualTo":0,"FXUnitCreditValueNotEqualTo":0,"FXUnitCreditValueBetween":[0],"FXUnitCreditValueIn":[0],"FXTotalCreditValue":0,"FXTotalCreditValueGreaterThanOrEqualTo":0,"FXTotalCreditValueGreaterThan":0,"FXTotalCreditValueLessThan":0,"FXTotalCreditValueLessThanOrEqualTo":0,"FXTotalCreditValueNotEqualTo":0,"FXTotalCreditValueBetween":[0],"FXTotalCreditValueIn":[0],"FXRate":0,"FXRateGreaterThanOrEqualTo":0,"FXRateGreaterThan":0,"FXRateLessThan":0,"FXRateLessThanOrEqualTo":0,"FXRateNotEqualTo":0,"FXRateBetween":[0],"FXRateIn":[0],"UnitCreditValue":0,"UnitCreditValueGreaterThanOrEqualTo":0,"UnitCreditValueGreaterThan":0,"UnitCreditValueLessThan":0,"UnitCreditValueLessThanOrEqualTo":0,"UnitCreditValueNotEqualTo":0,"UnitCreditValueBetween":[0],"UnitCreditValueIn":[0],"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","RA_CreditMain_RecID":"String","RA_CreditLines_RecID":"String","Quantity":0,"Remark":"String","TotalCreditValue":0,"InventoryID":"String","TaxID":"String","TaxAmount":0,"RowHash":"AA==","UnitCreditValue":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}