JiwaAPI

<back to all web services

SO_PaymentDetailsQuery

Requires Authentication
SO_PaymentDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
PaymentIDquerystringNo
PaymentIDStartsWithquerystringNo
PaymentIDEndsWithquerystringNo
PaymentIDContainsquerystringNo
PaymentIDLikequerystringNo
PaymentIDBetweenquerystring[]No
PaymentIDInquerystring[]No
CardNumberquerystringNo
CardNumberStartsWithquerystringNo
CardNumberEndsWithquerystringNo
CardNumberContainsquerystringNo
CardNumberLikequerystringNo
CardNumberBetweenquerystring[]No
CardNumberInquerystring[]No
CardExpiryqueryDateTime?No
CardExpiryGreaterThanOrEqualToqueryDateTime?No
CardExpiryGreaterThanqueryDateTime?No
CardExpiryLessThanqueryDateTime?No
CardExpiryLessThanOrEqualToqueryDateTime?No
CardExpiryNotEqualToqueryDateTime?No
CardExpiryBetweenqueryNullable<DateTime>[]No
CardExpiryInqueryNullable<DateTime>[]No
CardHolderquerystringNo
CardHolderStartsWithquerystringNo
CardHolderEndsWithquerystringNo
CardHolderContainsquerystringNo
CardHolderLikequerystringNo
CardHolderBetweenquerystring[]No
CardHolderInquerystring[]No
BankNamequerystringNo
BankNameStartsWithquerystringNo
BankNameEndsWithquerystringNo
BankNameContainsquerystringNo
BankNameLikequerystringNo
BankNameBetweenquerystring[]No
BankNameInquerystring[]No
BSBNquerystringNo
BSBNStartsWithquerystringNo
BSBNEndsWithquerystringNo
BSBNContainsquerystringNo
BSBNLikequerystringNo
BSBNBetweenquerystring[]No
BSBNInquerystring[]No
BankAccquerystringNo
BankAccStartsWithquerystringNo
BankAccEndsWithquerystringNo
BankAccContainsquerystringNo
BankAccLikequerystringNo
BankAccBetweenquerystring[]No
BankAccInquerystring[]No
AccountNamequerystringNo
AccountNameStartsWithquerystringNo
AccountNameEndsWithquerystringNo
AccountNameContainsquerystringNo
AccountNameLikequerystringNo
AccountNameBetweenquerystring[]No
AccountNameInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SO_PaymentDetails Parameters:
NameParameterData TypeRequiredDescription
PaymentIDformstringNo
CardNumberformstringNo
CardExpiryformDateTime?No
CardHolderformstringNo
BankNameformstringNo
BSBNformstringNo
BankAccformstringNo
AccountNameformstringNo
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/SO_PaymentDetailsQuery HTTP/1.1 
Host: localhost 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"PaymentID":"String","PaymentIDStartsWith":"String","PaymentIDEndsWith":"String","PaymentIDContains":"String","PaymentIDLike":"String","PaymentIDBetween":["String"],"PaymentIDIn":["String"],"CardNumber":"String","CardNumberStartsWith":"String","CardNumberEndsWith":"String","CardNumberContains":"String","CardNumberLike":"String","CardNumberBetween":["String"],"CardNumberIn":["String"],"CardExpiry":"0001-01-01T00:00:00.0000000","CardExpiryGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","CardExpiryGreaterThan":"0001-01-01T00:00:00.0000000","CardExpiryLessThan":"0001-01-01T00:00:00.0000000","CardExpiryLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","CardExpiryNotEqualTo":"0001-01-01T00:00:00.0000000","CardExpiryBetween":["0001-01-01T00:00:00.0000000"],"CardExpiryIn":["0001-01-01T00:00:00.0000000"],"CardHolder":"String","CardHolderStartsWith":"String","CardHolderEndsWith":"String","CardHolderContains":"String","CardHolderLike":"String","CardHolderBetween":["String"],"CardHolderIn":["String"],"BankName":"String","BankNameStartsWith":"String","BankNameEndsWith":"String","BankNameContains":"String","BankNameLike":"String","BankNameBetween":["String"],"BankNameIn":["String"],"BSBN":"String","BSBNStartsWith":"String","BSBNEndsWith":"String","BSBNContains":"String","BSBNLike":"String","BSBNBetween":["String"],"BSBNIn":["String"],"BankAcc":"String","BankAccStartsWith":"String","BankAccEndsWith":"String","BankAccContains":"String","BankAccLike":"String","BankAccBetween":["String"],"BankAccIn":["String"],"AccountName":"String","AccountNameStartsWith":"String","AccountNameEndsWith":"String","AccountNameContains":"String","AccountNameLike":"String","AccountNameBetween":["String"],"AccountNameIn":["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":[{"PaymentID":"String","CardNumber":"String","CardExpiry":"0001-01-01T00:00:00.0000000","CardHolder":"String","BankName":"String","BSBN":"String","BankAcc":"String","AccountName":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}