Query String Parameters

Supported query parameters per report type

This table describes the supported query string parameters per report type.

Parameter

Value

Example

Report Types

accountId

BlueSnap account ID assigned to the shopper

accountId=27418741

RecurringCharges

accountUpdaterStatus

  • A (acknowledged)
  • C (completed)

By default, both A and C are returned.

accountUpdaterStatus=A

AU_MerchantVaultCards

chargeStatus

  • Success
  • Failure

By default, all charges are returned.

chargeStatus=Success

RecurringCharges

contracts

Number or a comma‑separated list of numbers

If not defined, data is returned for all contracts under the specified product

To use this, you must also include the products parameter

contracts=123456,987612

ActiveSubscriptions
CanceledSubscriptions
PendingRefunds
RecurringCharges
TransactionDetail

create_from_date, create_to_date

For a custom period, these parameters allow you to specify the date range for the report results. Format is MM/DD/YYYY or YYYY‑MM‑DD.

period=CUSTOM &create_from_date=01/30/2020 &create_to_date=03/30/2020

ActiveSubscriptions

create_period

The period for which you would like to view report results.

Values:

  • THIS_MONTH
  • LAST_WEEK
  • LAST_MONTH
  • LAST_3_MONTHS
  • LAST_6_MONTHS
  • LAST_12_MONTHS
  • CUSTOM: For a custom period, be sure to include the create_from_date and create_to_date parameters.

period=THIS_MONTH

ActiveSubscriptions

currency

Three‑letter currency code (uppercase)

currency=USD

ActiveSubscriptions
CanceledSubscriptions
DeclinedAuthFees
PayoutDetail
PayoutSummary
TransactionDetail

excludeZero

Whether to exclude zero value orders.

  • 0 (default; do not exclude)
  • 1 (exclude)

excludeZero=1

RecurringCharges

format

  • json (default)
  • csv (not applicable to PayoutSummaryStatement)
  • html (only applicable to PayoutSummaryStatement)

format=csv

All reports

fraudDeclineReason

  • 3D Secure
  • AVS/CVV Rules
  • Custom Decline Threshold
  • Custom Review Threshold
  • Decline Fraud Rules
  • Fraud Check Error
  • Review Fraud Rules

fraudDeclineReason=Velocity

StoppedFraud

from_time
to_time

Allows you to to filter the report by the transaction time (in PST). Default values for from_time and to_time are 00:00:00 and 23:59:59, respectively.

period=CUSTOM &from_date=07/01/2020&from_time=05:25:02 &to_date=07/31/2020&to_time=23:55:58

TransactionDetail

invoiceStatus

  • Approved
  • Canceled
  • Pending
  • Refunded

invoiceStatus=Approved

DirectDebit

merchantBatchId

A merchant generated alphanumeric string

merchantBatchId=B_12ed121aa

AU_MerchantVaultCards

merchantUpdaterId

A merchant generated alphanumeric string

merchantUpdaterId=4564106_1

AU_MerchantVaultCards

pageSize

Number of rows in the response page.

If not specified, each page contains a maximum of 5000 rows.

Relevant only for the first page call.

ActiveSubscriptions
AddCardAttempts
AU_BluesnapVaultCards
AU_MerchantVaultCards
CanceledSubscriptions
DeclinedAuthFees
DeclinedTransactions
PayoutDetail
Stopped Fraud
TransactionDetail
VendorDetails

paymentType

Screen the sales by the payment method.

DeclinedTransactions Report:

  • Apple Pay

  • Credit


TransactionDetail Report:

  • Alipay

  • Apple Pay

  • Balance

  • Boleto Bancario

  • Business Check

  • Cashier Check

  • cashU

  • Credit Card

  • Direct Debit

  • Electronic Check

  • GlobalCollect Cheque

  • Google Pay Tokenized

  • Card

  • Local Bank Transfer

  • Money Order

  • None

  • Offline Electronic Check

  • Online banking

  • PayPal

  • PaySafeCard

  • Personal Check

  • Prepaid

  • Purchase Order

  • SEPA Direct Debit

  • Skrill (Moneybookers)

  • Ukash

  • Wallie

  • WebMoney

  • Wire Transfer

paymentType=Credit Card

DeclinedTransactions
TransactionDetail

payoutCurrency

3‑digit code of the currency of the bank account where you receive proceeds from the transaction.

payoutCurrency=USD

BalanceDetail
PayoutDetail
PayoutSummary
PendingRefunds
RunningBalance

payoutCycle

required for PayoutSummaryStatement; Optional otherwise

A BlueSnap assigned value identifying the payout cycle

payoutCycle=2016D303

DeclinedAuthFees
PayoutDetail
PayoutSummary
PayoutSummaryStatement
TransactionDetail

payoutPlannedDate

The date a payment is expected to be initiated according to your payout schedule. If the Planned Date falls on a weekend or bank holiday, the payment is initiated on the next business day.

payoutPlannedDate=11%2F15%2F2020

BalanceDetail

period

required; Optional for BalanceDetail, PayoutDetail, and PayoutSummaryStatement

Values:

  • THIS_FULL_MONTH: Current month from start to end. Only applicable to following reports: Summary of Processing Statements, Payout Category, Payout Details, Payout Summary Statement, Running Balance
  • THIS_MONTH: Current month to date
  • LAST_WEEK
  • LAST_MONTH
  • LAST_3_MONTHS
  • LAST_6_MONTHS
  • LAST_12_MONTHS
  • NEXT_MONTH: Only applicable to PayoutSummary
  • CUSTOM: For a custom period, you must also include the from_date and to_date parameters (format is MM/DD/YYYY or YYYY‑MM‑DD)

period=LAST_3_MONTHS

period=CUSTOM &from_date=01/30/2016 &to_date=03/30/2016

AccountBalance
ActiveSubscriptions
AU_BluesnapVaultCards
AU_MerchantVaultCards
CanceledSubscriptions
Chargebacks
DeclinedAuthFees
DeclinedTransactions
DirectDebit
PayoutSummary
PayoutSummaryStatement
PayoutDetail
RecurringCharges
RunningBalance
StoppedFraud
TransactionDetail

Note: The RunningBalance report period cannot exceed 31 days in total.

processingStatus

  • Success
  • Declined

processingStatus=Success

AddCardAttempts

products

Number or a comma‑separated list of numbers

If not defined, data is returned for all products

products=444555

ActiveSubscriptions
CanceledSubscriptions
PendingRefunds
RecurringCharges
TransactionDetail

region

required for RunningBalance; Optional otherwise

Region where deposit is processed (only available for merchants on regional payout)

Use Unknown for RunningBalance reports not assigned to a specific region.

region=UK

AccountBalance
Chargeback
PayoutDetail
PayoutSummaryStatement
PendingRefunds
RunningBalance
TransactionDetail
TransactionSummary

skuType

  • ONE_TIME
  • RECURRING

skuType=ONE_TIME

TransactionDetail

transactionType

  • SALE
  • REFUND
  • CHARGEBACK

transactionType=SALE

TransactionDetail

typeOfTransaction

  • Card Verification
  • Failover
  • Free Trial
  • Payment
  • Subscription Free Trial
  • Subscription Recurring
  • Charge
  • Subscription Retry

If not defined, data is returned for all transaction types.

typeOfTransaction=Charge

DeclinedAuthFees

forvendorid

Vendor ID, a unique value assigned by BlueSnap to each Marketplace vendor.

Parameter is used to retrieve account balance and payout details for vendor.

forvendorid=513499

All Reports

vendor

Vendor ID, a unique value assigned by BlueSnap to each Marketplace vendor.

vendor=123456

ActiveSubscriptions
BalanceDetail
CanceledSubscriptions
DeclinedAuthFees
DeclinedTransactions
DirectDebit
PayoutDetail
TransactionDetail
VendorDetails

vendorStatus

Vendor's account status. If not defined, data is returned for all statuses.

Values:

  • Active
  • Inactive

vendorStatus=Active

VendorDetails

whitelabel

Indicates whether to remove BlueSnap from report column names.

Values:

  • Y
  • N

whitelabel=Y

AccountBalance
AccountBalanceDetail
PayoutDetailsPayout
RunningBalancePayout
SummaryofProcessingStatements
AccountUpdater
TransactionDetail