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 - FailureBy 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 (see below) 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 CardTransactionDetail 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 * | Region where deposit is processed (*only available for merchants on regional payout) | region=UK | AccountBalance Chargeback PayoutDetail PayoutSummaryStatement PendingRefunds 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 RetryIf 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 |