Query String Parameters

Supported query parameters for our custom reporting API

When you run your custom report, you can filter the results using query string parameters. Each of the following sections lists the supported query string parameters for the report category.

TransactionCategory Parameters

ParameterDescriptionExample
contractsFilters results for a specific contract or a list of contracts.

Value is a number or a comma‑separated list of numbers.

To use this parameter, include the products parameter as well.

If this parameter is not defined, data is returned for all contracts under the specified product.
contracts=123456

contracts=123456,987612
currencyFilters results by the transaction currency.

Value is the three‑letter currency code (uppercase).
currency=USD
formatSpecifies the format of the results.

Values:

- json (default)
- csv
format=csv
from_date, to_dateFor 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 &from_date=01/30/2020 &to_date=03/30/2020
from_time, to_timeFor a custom period, these parameters allow 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
merchantIdsQueries your report using multiple merchant IDs. It should contain a comma-separated list of numbers, where the numbers are merchants IDs. This can only be used with the API credentials of the associated parent VID (MID) or the associated referral partner ID.merchantIds=402650,612355,382526
paymentTypeFilters results by payment method.

Values:

- Alipay
- Apple Pay
- Balance
- Boleto Bancario
- Business Check
- Cashier Check
- cashU
- Credit Card
- Direct Debit
- Electronic Check
- GlobalCollect Cheque
- Google Pay Tokenized Card
- 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%20Card
payoutCycleFilters results by the payout cycle.

A BlueSnap assigned value identifying the payout cycle.
payoutCycle=2016D303
period (Required)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 from_date and to_date parameters.
period=THIS_MONTH
productsFilters results by a specific product or list of products.

If not defined, data is returned for all products.
products=444555

products=444555,888999
regionRegion where deposit is processed. Only available for merchants on regional payout.region=UK
skuTypeFilters results by the SKU type.

Values:

- ONE_TIME
- RECURRING
skuType=ONE_TIME
transactionTypeFilters results by the transaction type.

Values:

- CHARGEBACK
- SALE
- REFUNDNote: There are multiple types of fees, manual adjustments, and reserves not listed here.
transactionType=SALE
vendorFilters results by a marketplace vendor.

Value is the vendor's ID, which is a unique value assigned by BlueSnap.
vendor=513499
whitelabelIndicates whether to remove BlueSnap from report column names.

Values:

- Y
- N
whitelabel=Y

PayoutCategory Parameters

ParameterDescriptionExample
formatSpecifies the format of the results.

Values:

- json (default)
- csv
format=csv
forvendoridRuns a report on behalf of a vendor.

Value is the vendor's ID, which is a unique value assigned by BlueSnap.
forvendorid=513499
from_date, to_dateFor 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 &from_date=01/30/2020 &to_date=03/30/2020
nonProcessingFeesIncludes non-processing fees in your report. When you pass nonProcessingFees=1, the report will show all payout types, with non-processing fees included.

If any other value is passed, the report will only show CHARGE, CHARGEBACK, RDR, and REFUND events. This is the default behavior.
nonProcessingFees=1
payoutCurrencyFilters the results by the payout currency.

Value is the 3‑digit code (uppercase) of the currency of the bank account where you receive your payout.
payoutCurrency=USD
payoutCycleFilters results by the payout cycle.

A BlueSnap assigned value identifying the payout cycle.
payoutCycle=2016D303
periodPeriod 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 from_date and to_date parameters.
period=THIS_MONTH
regionRegion where deposit is processed. Only available for merchants on regional payout.region=UK
transactionTypeFilters results by the transaction type.

Values:

- CHARGEBACK
- SALE
- REFUNDNote: There are multiple types of fees, manual adjustments, and reserves not listed here.
transactionType=SALE
whitelabelIndicates whether to remove BlueSnap from report column names.

Values:

- Y
- N
whitelabel=Y