RSL Payment API

<back to all web services

QueryPaymentsTransactionByDateRange

The following routes are available for this service:
GET/payments/rangeFetch Braintree payments by dateFetch for Braintree payments by date range
QueryPaymentsTransactionByDateRange Parameters:
NameParameterData TypeRequiredDescription
StartDatequeryDateTimeYes
EndDatequeryDateTime?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
Payment Parameters:
NameParameterData TypeRequiredDescription
Amountformdecimal?No
ReferenceNumberformstringNo
TransactionIdformstringNo
IsSuccessformbool?No
TransactionStatusformTransactionStatus?No
ProcessorResponseCodeformstringNo
ProcessorResponseTextformstringNo
GatewayRejectionReasonformGatewayRejectionReason?No
CreatedAtformDateTimeNo
DisputesformList<Dispute>No
CreditCardformCreditCardNo
PayPalDetailsformPayPalDetailsNo
GooglePayformGooglePayDetailsNo
ApplePayformApplePayDetailsNo
SettlementBatchIdformstringNo
PaymentInstrumentTypeformPaymentInstrumentTypeNo
ResponseStatusTypeformResponseStatusTypeNo
ProcessorDeclineTypeformProcessorDeclineType?No
VoidTransactionIdformstringNo
VoidProcessorResponseCodeformstringNo
ProcessedWithNetworkTokenformbool?No
AcquirerReferenceNumberformstringNo
Retriedformbool?No
AchReturnCodeformstringNo
MerchantAccountIdformstringNo
TokenformstringNo
TransactionStatus Enum:
authorization_expired
authorized
authorizing
failed
gateway_rejected
processor_declined
settled
settling
submitted_for_settlement
voided
unrecognized
settlement_confirmed
settlement_declined
settlement_pending
failed_to_submit
submitting_to_braintree
timeout
GatewayRejectionReason Enum:
application_incomplete
avs
avs_and_cvv
cvv
duplicate
excessive_retry
fraud
risk_threshold
three_d_secure
token_issuance
unrecognized
Dispute Parameters:
NameParameterData TypeRequiredDescription
Amountformdecimal?No
CurrencyIsoCodeformstringNo
DateOpenedformDateTime?No
DateWonformDateTime?No
IdformstringNo
KindformDisputeKindNo
ReasonformDisputeReasonNo
PreDisputeProgramformPreDisputeProgramNo
ReceivedDateformDateTime?No
ReplyByDateformDateTime?No
StatusformDisputeStatusNo
CaseNumberformstringNo
PayPalMessagesformList<DisputePayPalMessage>No
ProtectionLevelformDisputeProtectionLevelNo
DisputeKind Enum:
chargeback
pre_arbitration
retrieval
unrecognized
DisputeReason Enum:
cancelled_recurring_transaction
credit_not_processed
duplicate
fraud
general
invalid_account
not_recognized
product_not_received
product_unsatisfactory
transaction_amount_differs
retrieval
PreDisputeProgram Enum:
none
unrecognized
visa_rdr
DisputeStatus Enum:
open
lost
won
unrecognized
accepted
auto_accepted
disputed
expired
DisputePayPalMessage Parameters:
NameParameterData TypeRequiredDescription
MessageformstringNo
SenderformstringNo
SentAtformDateTime?No
DisputeProtectionLevel Enum:
effortless_cbp
standard_cbp
no_protection
CreditCard Parameters:
NameParameterData TypeRequiredDescription
CardTypeformstringNoThe type of the credit card. Possible values: American Express, Carte Blanche, China UnionPay, Diners Club Discover, JCB, Laser, Maestro, MasterCard, Solo, Switch, Visa, Unknown
ExpirationMonthformstringNo
ExpirationYearformstringNo
BinformstringNoThe first 6 digits of the credit card, known as the Bank Identification Number.
LastFourformstringNoThe last 4 digits of the credit card number
UniqueNumberIdentifierformstringNo
CardholderNameformstringNo
TokenformstringNoThe payment method token
IsNetworkTokenizedformbool?No
DebitformCreditCardDebitNo
CreditCardDebit Enum:
yes
no
unknown
PayPalDetails Parameters:
NameParameterData TypeRequiredDescription
RefundIdformstringNo
CaptureIdformstringNo
SellerProtectionStatusformstringNo
PayerStatusformstringNo
PayerLastNameformstringNo
PayerFirstNameformstringNo
PayerIdformstringNo
PayeeEmailformstringNo
PayeeIdformstringNo
TokenformstringNo
AuthorizationIdformstringNo
PaymentIdformstringNo
PayerEmailformstringNo
TransactionFeeAmountformdecimalNo
TransactionFeeCurrencyIsoCodeformstringNo
DescriptionformstringNo
BillingAgreementIdformstringNo
TaxIdformstringNo
TaxIdTypeformstringNo
GooglePayDetails Parameters:
NameParameterData TypeRequiredDescription
SourceCardTypeformstringNo
CustomerIdformstringNo
ExpirationMonthformstringNo
ExpirationYearformstringNo
BinformstringNoThe first 6 digits of the credit card, known as the Bank Identification Number.
GoogleTransactionIdformstringNo
SourceCardLast4formstringNoThe last 4 digits of the credit card number
CardholderNameformstringNo
TokenformstringNoThe payment method token
IsNetworkTokenizedformbool?No
ApplePayDetails Parameters:
NameParameterData TypeRequiredDescription
CardTypeformstringNo
CustomerIdformstringNo
ExpirationMonthformstringNo
ExpirationYearformstringNo
BinformstringNoThe first 6 digits of the credit card, known as the Bank Identification Number.
LastFourformstringNoThe last 4 digits of the credit card number
CardholderNameformstringNo
TokenformstringNoThe payment method token
PaymentInstrumentType Enum:
unknown
paypal_account
credit_card
android_pay_card
apple_pay_card
ResponseStatusType Enum:
Unknown
Success
Fail
SoftFail
ProcessorDeclineType Enum:
Unknown
Soft
Hard
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.

GET /payments/range HTTP/1.1 
Host: azs-dev-payment-web.azurewebsites.net 
Accept: text/csv
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"offset":0,"total":0,"results":[{"amount":0,"referenceNumber":"String","transactionId":"String","isSuccess":false,"transactionStatus":"authorization_expired","processorResponseCode":"String","processorResponseText":"String","gatewayRejectionReason":"application_incomplete","createdAt":"0001-01-01T00:00:00.0000000","disputes":[{"amount":0,"currencyIsoCode":"String","dateOpened":"0001-01-01T00:00:00.0000000","dateWon":"0001-01-01T00:00:00.0000000","id":"String","kind":"chargeback","reason":"cancelled_recurring_transaction","preDisputeProgram":"none","receivedDate":"0001-01-01T00:00:00.0000000","replyByDate":"0001-01-01T00:00:00.0000000","status":"open","caseNumber":"String","payPalMessages":[{"message":"String","sender":"String","sentAt":"0001-01-01T00:00:00.0000000"}],"protectionLevel":"effortless_cbp"}],"creditCard":{"cardType":"String","expirationMonth":"String","expirationYear":"String","bin":"String","lastFour":"String","uniqueNumberIdentifier":"String","cardholderName":"String","token":"String","isNetworkTokenized":false,"debit":"yes"},"payPalDetails":{"refundId":"String","captureId":"String","sellerProtectionStatus":"String","payerStatus":"String","payerLastName":"String","payerFirstName":"String","payerId":"String","payeeEmail":"String","payeeId":"String","token":"String","authorizationId":"String","paymentId":"String","payerEmail":"String","transactionFeeAmount":0,"transactionFeeCurrencyIsoCode":"String","description":"String","billingAgreementId":"String","taxId":"String","taxIdType":"String"},"googlePay":{"sourceCardType":"String","customerId":"String","expirationMonth":"String","expirationYear":"String","bin":"String","googleTransactionId":"String","sourceCardLast4":"String","cardholderName":"String","token":"String","isNetworkTokenized":false},"applePay":{"cardType":"String","customerId":"String","expirationMonth":"String","expirationYear":"String","bin":"String","lastFour":"String","cardholderName":"String","token":"String"},"settlementBatchId":"String","paymentInstrumentType":"unknown","responseStatusType":"Unknown","processorDeclineType":"Unknown","voidTransactionId":"String","voidProcessorResponseCode":"String","processedWithNetworkToken":false,"acquirerReferenceNumber":"String","retried":false,"achReturnCode":"String","merchantAccountId":"String","token":"String"}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}