get https://sandbox.bluesnap.com/services/2
Definition
https://sandbox.bluesnap.com/services/2/report/{report_code}?{parameters}
Documentation
Use this GET request to retrieve report data in either JSON or CSV format.
Request Content
This is the basic request format for each BlueSnap environment:
- Sandbox:
https://sandbox.bluesnap.com/services/2/report/{report_code}?{parameters} - Production:
https://ws.bluesnap.com/services/2/report/{report_code}?{parameters}
Insert the report code for the type of report that you want to retrieve, plus the relevant parameters.
For example:
https://sandbox.bluesnap.com/services/2/report/TransactionDetail?period=LAST_MONTH&skuType=ONE_TIME
&transactionType=SALE&paymentType=Credit%20Card&products=281272&contracts=2117474&pageSize=2
Report Availablity
There is currently a time delay of 2–3 hours for report data, meaning that you will not see data for transactions that took place within the last 3 hours.
Tips
Parsing report data
Parse report data based on parameter name to ensure your integration continues to work properly when reports are updated (such as when the parameter order changes). This is because parameters are never renamed or removed.Parsing by parameter name is especially important if you get report data in CSV format.
Retrieving payout reports for reconciliation
Retrieve the Payout Detail and Payout Summary reports after you receive thepayoutIPN, as the IPN is sent when your deposits have been finalized.
Report codes
These are the supported report types. In the request, include the code for the report you want to retrieve.
| Report code | Description |
|---|---|
AccountBalance | Provides details about your current account balance (amount that has not been paid out yet), including payout currency(ies), gross and net amounts, and more. Learn more. |
ActiveSubscriptions | Provides details about active subscriptions, such as the next charge date, Subscription ID, and shopper info. Learn more. |
AddCardAttempts | Provides the results of all card addition and update attempts. Learn more |
AU_BluesnapVaultCards | Provides the results of your Account Updater requests. This report is designed for merchants who use BlueSnap's card vault to store credit card numbers. Learn more. |
AU_MerchantVaultCards | Provides the results of your Account Updater requests. This report is designed for merchants who vault credit card numbers on their own servers. Learn more. |
BalanceDetail | Provides transaction-level detail for all the transactions included in your account balance. Learn more. |
CanceledSubscriptions | Provides a list of canceled subscriptions that include the plan, shopper, and cancellation details. Learn more. |
ChargeBacks | Displays all chargebacks and chargeback related data. Learn more. |
DeclinedAuthFees | Provides a list of all declined authorizations and the fees for those that have been charged. Learn more. |
DeclinedTransactions | Provides a list of declined credit and debit card transactions with decline reason, payment details, and shopper information. Learn more. |
DirectDebit | Provides a list of all ACH / Electronic Check and SEPA Direct Debit transactions. Use this report to track the invoice status from Pending to Approved or Canceled. Learn more. |
PayoutDetail | Provides details about the transactions included in BlueSnap deposits to your account. Learn more. |
PayoutSummary | Helps you reconcile your gross sales to the amount deposited into your bank account for each payout currency. It also itemizes all processing fees, non-processing fees, and other adjustments to your account. Learn more. |
PayoutSummaryStatement | Access summary reports from past payout cycles to view details such as sales, refunds, fees, and more. Learn more. |
RecurringCharges | Provides details about all the recurring charges that were attempted. Learn more. |
RunningBalance | Provides a detailed list of all events and how they affect your balance. Allows you to see a snapshot of your balance in real time, at any chosen point in time, or within a chosen date range. Learn more. |
StoppedFraud | Provides details about transactions that were declined because of your fraud rules or BlueSnap's fraud detection logic. Learn more. |
TransactionDetail | Provides details about each transaction, including shopper info, payment details, subscription info and more. Learn more. |
VendorDetails | Provides account details for each of the vendors in your marketplace. Learn more. |
Query parameters
These are the supported query 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 RecurringCharges TransactionDetail |
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_timeto_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 10,000 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 Card 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 |
payoutCyclerequired 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 |
periodrequired; Optional for BalanceDetail, PayoutDetail, and PayoutSummaryStatement | THIS_MONTH LAST_WEEK LAST_MONTH LAST_3_MONTHS LAST_6_MONTHS LAST_12_MONTHS 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) NEXT_MONTH — Only applicable to PayoutSummary | period=LAST_3_MONTHSperiod=CUSTOM &from_date=01/30/2016 &to_date=03/30/2016 | AccountBalance ActiveSubscriptions AU_BluesnapVaultCards AU_MerchantVaultCards CanceledSubscriptions DeclinedAuthFees DeclinedTransactions DirectDebit PayoutSummary PayoutSummaryStatement PayoutDetail RecurringCharges StoppedFraud TransactionDetail |
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 RecurringCharges TransactionDetail |
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. Active Inactive | vendorStatus=Active | VendorDetails |
Paging
Pagination is supported. See Report Pagination for full details.
Response Details
If successful, the HTTP status code is 200 OK. The report data is included in the data property. For details on any of the report parameters, see BlueSnap Reporting.
Error Handling
For information about possible errors, see Errors.
Examples
Request Examples
curl -v -X GET https://sandbox.bluesnap.com/services/2/report/TransactionDetail?period=CUSTOM&from_date=01%2F01%2F2016&to_date=03%2F31%2F2016&skuType=ONE_TIME&transactionType=SALE&paymentType=Credit%20Card&products=281272&contracts=2117474&pageSize=2 \
-H 'Content-Type: application/json' \
-H 'Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQ='
curl -v -X GET https://sandbox.bluesnap.com/services/2/report/TransactionDetail?nextPageToken=bmV4dHBhZ2V0b2tlbg== \
-H 'Content-Type: application/json' \
-H 'Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQ='
curl -v -X GET https://sandbox.bluesnap.com/services/2/report/AccountBalance?period=THIS_MONTH \
-H 'Content-Type: application/json' \
-H 'Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQ='
###Response Examples
{
"data": [
{
"Invoice ID": "1019500824",
"Original Invoice ID": "1019500824",
"Merchant Transaction ID": "",
"PayPal Transaction ID": "",
"Transaction Type": "Sale",
"Transaction Date": "09/26/2019",
"Transaction Time (PST)": "04:00:16",
"Purchase Date": "",
"Payment ID": "2019W39",
"Refund / Chargeback Reason": "",
"Product": "One-Time Product",
"Product ID": "432949",
"Contract": "subscription test contract",
"Contract ID": "2337423",
"SKU Type": "Recurring contract",
"Payment Frequency": "Monthly",
"Recurring Cycle Group": "Recurring",
"Recurring Cycle Number": "28",
"Payment Type": "Credit Card",
"Card Network": "Visa",
"Qty": "1",
"BIN Country": "UNITED STATES",
"BIN Issuer Organization": "JPMORGAN CHASE BANK, N.A.",
"Regulated Issuer": "Y",
"BIN Number": "411111",
"BIN Card Type": "CREDIT",
"Last 4 Digits": "1111",
"Expiration Date": "01/2021",
"Auth. Currency": "USD",
"Merchant Sales (Auth Currency)": "25.00",
"BlueSnap Processing Fees (USD)": "1.75",
"PayPal Processing Fees (USD)": "0.00",
"Vat / Tax": "0.00",
"Merchant Base Currency": "USD",
"Merchant Sales (Base Currency)": "25.00",
"Coupon Code": "",
"Shopper ID": "21858491",
"Shopper First Name": "TestVaultedShopper",
"Shopper Last Name": "TVS",
"Shopper Email": "[email protected]",
"PayPal Email": "",
"Shopper Country": "Israel",
"Shopper State": "",
"Company Name": "",
"Vendor / Affiliate ID": "",
"Vendor / Affiliate Name": "",
"Vendor / Affiliate Commission (Auth. Currency)": "0.00",
"Soft Descriptor": "daniel_bluesnap",
"3DS Authentication": "No",
"Custom Field 1": "",
"Custom Field 2": "",
"Custom Field 3": "",
"Custom Field 4": "",
"Custom Field 5": "",
"Custom Field 6": "",
"Custom Field 7": "",
"Custom Field 8": "",
"Custom Field 9": "",
"Custom Field 10": "",
"Custom Field 11": "",
"Custom Field 12": "",
"Custom Field 13": "",
"Custom Field 14": "",
"Custom Field 15": "",
"Custom Field 16": "",
"Custom Field 17": "",
"Custom Field 18": "",
"Custom Field 19": "",
"Custom Field 20": "",
"Custom Field 21": "",
"Custom Field 22": "",
"Custom Field 23": "",
"Custom Field 24": "",
"Custom Field 25": "",
"Custom Field 26": "",
"Custom Field 27": "",
"Custom Field 28": "",
"Custom Field 29": "",
"Custom Field 30": ""
},
{
"Invoice ID": "1019492568",
"Original Invoice ID": "1019492568",
"Merchant Transaction ID": "",
"PayPal Transaction ID": "",
"Transaction Type": "Sale",
"Transaction Date": "09/25/2019",
"Transaction Time (PST)": "02:01:11",
"Purchase Date": "",
"Payment ID": "2019W39",
"Refund / Chargeback Reason": "",
"Product": "Adam example",
"Product ID": "472081",
"Contract": "subscription 1000",
"Contract ID": "2423381",
"SKU Type": "Recurring contract",
"Payment Frequency": "Monthly",
"Recurring Cycle Group": "Recurring",
"Recurring Cycle Number": "12",
"Payment Type": "Credit Card",
"Card Network": "Visa",
"Qty": "1",
"BIN Country": "UNITED STATES",
"BIN Issuer Organization": "JPMORGAN CHASE BANK, N.A.",
"Regulated Issuer": "Y",
"BIN Number": "411111",
"BIN Card Type": "CREDIT",
"Last 4 Digits": "1111",
"Expiration Date": "01/2022",
"Auth. Currency": "USD",
"Merchant Sales (Auth Currency)": "12.43",
"BlueSnap Processing Fees (USD)": "1.12",
"PayPal Processing Fees (USD)": "0.00",
"Vat / Tax": "0.00",
"Merchant Base Currency": "USD",
"Merchant Sales (Base Currency)": "12.43",
"Coupon Code": "",
"Shopper ID": "23198705",
"Shopper First Name": "daniel",
"Shopper Last Name": "millar",
"Shopper Email": "[email protected]",
"PayPal Email": "",
"Shopper Country": "Israel",
"Shopper State": "",
"Company Name": "",
"Vendor / Affiliate ID": "",
"Vendor / Affiliate Name": "",
"Vendor / Affiliate Commission (Auth. Currency)": "0.00",
"Soft Descriptor": "daniel_bluesnap",
"3DS Authentication": "No",
"Custom Field 1": "",
"Custom Field 2": "",
"Custom Field 3": "",
"Custom Field 4": "",
"Custom Field 5": "",
"Custom Field 6": "",
"Custom Field 7": "",
"Custom Field 8": "",
"Custom Field 9": "",
"Custom Field 10": "",
"Custom Field 11": "",
"Custom Field 12": "",
"Custom Field 13": "",
"Custom Field 14": "",
"Custom Field 15": "",
"Custom Field 16": "",
"Custom Field 17": "",
"Custom Field 18": "",
"Custom Field 19": "",
"Custom Field 20": "",
"Custom Field 21": "",
"Custom Field 22": "",
"Custom Field 23": "",
"Custom Field 24": "",
"Custom Field 25": "",
"Custom Field 26": "",
"Custom Field 27": "",
"Custom Field 28": "",
"Custom Field 29": "",
"Custom Field 30": ""
},
{
"Invoice ID": "1019475930",
"Original Invoice ID": "1019475930",
"Merchant Transaction ID": "",
"PayPal Transaction ID": "",
"Transaction Type": "Sale",
"Transaction Date": "09/23/2019",
"Transaction Time (PST)": "22:49:19",
"Purchase Date": "",
"Payment ID": "2019W39",
"Refund / Chargeback Reason": "",
"Product": "test product API",
"Product ID": "10299448",
"Contract": "Standard monthly SUB - API test",
"Contract ID": "12151480",
"SKU Type": "Recurring contract",
"Payment Frequency": "Monthly",
"Recurring Cycle Group": "Recurring",
"Recurring Cycle Number": "30",
"Payment Type": "Credit Card",
"Card Network": "Visa",
"Qty": "1",
"BIN Country": "UNITED STATES",
"BIN Issuer Organization": "JPMORGAN CHASE BANK, N.A.",
"Regulated Issuer": "Y",
"BIN Number": "411111",
"BIN Card Type": "CREDIT",
"Last 4 Digits": "1111",
"Expiration Date": "09/2019",
"Auth. Currency": "USD",
"Merchant Sales (Auth Currency)": "25.00",
"BlueSnap Processing Fees (USD)": "1.75",
"PayPal Processing Fees (USD)": "0.00",
"Vat / Tax": "0.00",
"Merchant Base Currency": "USD",
"Merchant Sales (Base Currency)": "25.00",
"Coupon Code": "",
"Shopper ID": "29563424",
"Shopper First Name": "John",
"Shopper Last Name": "Doe",
"Shopper Email": "[email protected]",
"PayPal Email": "",
"Shopper Country": "United States",
"Shopper State": "CA",
"Company Name": "JohnDoeAndSons",
"Vendor / Affiliate ID": "",
"Vendor / Affiliate Name": "",
"Vendor / Affiliate Commission (Auth. Currency)": "0.00",
"Soft Descriptor": "DANIEL_BLUESNAP",
"3DS Authentication": "No",
"Custom Field 1": "",
"Custom Field 2": "",
"Custom Field 3": "",
"Custom Field 4": "",
"Custom Field 5": "",
"Custom Field 6": "",
"Custom Field 7": "",
"Custom Field 8": "",
"Custom Field 9": "",
"Custom Field 10": "",
"Custom Field 11": "",
"Custom Field 12": "",
"Custom Field 13": "",
"Custom Field 14": "",
"Custom Field 15": "",
"Custom Field 16": "",
"Custom Field 17": "",
"Custom Field 18": "",
"Custom Field 19": "",
"Custom Field 20": "",
"Custom Field 21": "",
"Custom Field 22": "",
"Custom Field 23": "",
"Custom Field 24": "",
"Custom Field 25": "",
"Custom Field 26": "",
"Custom Field 27": "",
"Custom Field 28": "",
"Custom Field 29": "",
"Custom Field 30": ""
}
],
"columns": [
{
"css": "",
"currencyColumnId": 0,
"displayName": "Invoice ID",
"group": "",
"id": 8283,
"initiallyVisible": true,
"name": "Invoice ID",
"type": "INT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Original Invoice ID",
"group": "",
"id": 8285,
"initiallyVisible": true,
"name": "Original Invoice ID",
"type": "INT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Merchant Transaction ID",
"group": "",
"id": 8287,
"initiallyVisible": true,
"name": "Merchant Transaction ID",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "PayPal Transaction ID",
"group": "",
"id": 8289,
"initiallyVisible": true,
"name": "PayPal Transaction ID",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Transaction Type",
"group": "",
"id": 8291,
"initiallyVisible": true,
"name": "Transaction Type",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Transaction Date",
"group": "",
"id": 8293,
"initiallyVisible": true,
"name": "Transaction Date",
"type": "DATE",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Transaction Time (PST)",
"group": "",
"id": 8295,
"initiallyVisible": true,
"name": "Transaction Time (PST)",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Purchase Date",
"group": "",
"id": 8297,
"initiallyVisible": true,
"name": "Purchase Date",
"type": "DATE",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Payment ID",
"group": "",
"id": 8299,
"initiallyVisible": true,
"name": "Payment ID",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Refund / Chargeback Reason",
"group": "",
"id": 8301,
"initiallyVisible": true,
"name": "Refund / Chargeback Reason",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Product",
"group": "",
"id": 8303,
"initiallyVisible": true,
"name": "Product",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Product ID",
"group": "",
"id": 8305,
"initiallyVisible": true,
"name": "Product ID",
"type": "INT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Contract",
"group": "",
"id": 8307,
"initiallyVisible": true,
"name": "Contract",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Contract ID",
"group": "",
"id": 8309,
"initiallyVisible": true,
"name": "Contract ID",
"type": "INT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "SKU Type",
"group": "",
"id": 8311,
"initiallyVisible": true,
"name": "SKU Type",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Payment Frequency",
"group": "",
"id": 8313,
"initiallyVisible": true,
"name": "Payment Frequency",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Recurring Cycle Group",
"group": "",
"id": 8315,
"initiallyVisible": true,
"name": "Recurring Cycle Group",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Recurring Cycle Number",
"group": "",
"id": 8317,
"initiallyVisible": true,
"name": "Recurring Cycle Number",
"type": "INT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Payment Type",
"group": "",
"id": 8319,
"initiallyVisible": true,
"name": "Payment Type",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Card Network",
"group": "",
"id": 8321,
"initiallyVisible": true,
"name": "Card Network",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Qty",
"group": "",
"id": 8323,
"initiallyVisible": true,
"name": "Qty",
"type": "INT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "BIN Country",
"group": "",
"id": 8325,
"initiallyVisible": true,
"name": "BIN Country",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "BIN Issuer Organization",
"group": "",
"id": 8327,
"initiallyVisible": true,
"name": "BIN Issuer Organization",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Regulated Issuer",
"group": "",
"id": 8329,
"initiallyVisible": true,
"name": "Regulated Issuer",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "BIN Number",
"group": "",
"id": 8331,
"initiallyVisible": true,
"name": "BIN Number",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "BIN Card Type",
"group": "",
"id": 8333,
"initiallyVisible": true,
"name": "BIN Card Type",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Last 4 Digits",
"group": "",
"id": 8335,
"initiallyVisible": true,
"name": "Last 4 Digits",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Expiration Date",
"group": "",
"id": 8337,
"initiallyVisible": true,
"name": "Expiration Date",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Auth. Currency",
"group": "",
"id": 8339,
"initiallyVisible": true,
"name": "Auth. Currency",
"type": "CURRENCY",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 8339,
"displayName": "Merchant Sales (Auth Currency)",
"group": "",
"id": 8341,
"initiallyVisible": true,
"name": "Merchant Sales (Auth Currency)",
"type": "AMOUNT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 8339,
"displayName": "BlueSnap Processing Fees (USD)",
"group": "",
"id": 8343,
"initiallyVisible": true,
"name": "BlueSnap Processing Fees (USD)",
"type": "AMOUNT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 8339,
"displayName": "PayPal Processing Fees (USD)",
"group": "",
"id": 8345,
"initiallyVisible": true,
"name": "PayPal Processing Fees (USD)",
"type": "AMOUNT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 8339,
"displayName": "Vat / Tax",
"group": "",
"id": 8347,
"initiallyVisible": true,
"name": "Vat / Tax",
"type": "AMOUNT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Merchant Base Currency",
"group": "",
"id": 8349,
"initiallyVisible": true,
"name": "Merchant Base Currency",
"type": "CURRENCY",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 8349,
"displayName": "Merchant Sales (Base Currency)",
"group": "",
"id": 8351,
"initiallyVisible": true,
"name": "Merchant Sales (Base Currency)",
"type": "AMOUNT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Coupon Code",
"group": "",
"id": 8353,
"initiallyVisible": true,
"name": "Coupon Code",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Shopper ID",
"group": "",
"id": 8355,
"initiallyVisible": true,
"name": "Shopper ID",
"type": "INT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "First Name",
"group": "",
"id": 8357,
"initiallyVisible": true,
"name": "Shopper First Name",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Last Name",
"group": "",
"id": 8359,
"initiallyVisible": true,
"name": "Shopper Last Name",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Shopper Email",
"group": "",
"id": 8361,
"initiallyVisible": true,
"name": "Shopper Email",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "PayPal Email",
"group": "",
"id": 8363,
"initiallyVisible": true,
"name": "PayPal Email",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Shopper Country",
"group": "",
"id": 8365,
"initiallyVisible": true,
"name": "Shopper Country",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Shopper State",
"group": "",
"id": 8367,
"initiallyVisible": true,
"name": "Shopper State",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Company Name",
"group": "",
"id": 8369,
"initiallyVisible": true,
"name": "Company Name",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Vendor / Affiliate ID",
"group": "",
"id": 8371,
"initiallyVisible": true,
"name": "Vendor / Affiliate ID",
"type": "INT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Vendor / Affiliate Name",
"group": "",
"id": 8373,
"initiallyVisible": true,
"name": "Vendor / Affiliate Name",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 8339,
"displayName": "Vendor / Affiliate Commission (Auth. Currency)",
"group": "",
"id": 8375,
"initiallyVisible": true,
"name": "Vendor / Affiliate Commission (Auth. Currency)",
"type": "AMOUNT",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Soft Descriptor",
"group": "",
"id": 8377,
"initiallyVisible": true,
"name": "Soft Descriptor",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "3DS Authentication",
"group": "",
"id": 8379,
"initiallyVisible": true,
"name": "3DS Authentication",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 1",
"group": "",
"id": 8383,
"initiallyVisible": true,
"name": "Custom Field 1",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 2",
"group": "",
"id": 8385,
"initiallyVisible": true,
"name": "Custom Field 2",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 3",
"group": "",
"id": 8387,
"initiallyVisible": true,
"name": "Custom Field 3",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 4",
"group": "",
"id": 8389,
"initiallyVisible": true,
"name": "Custom Field 4",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 5",
"group": "",
"id": 8391,
"initiallyVisible": true,
"name": "Custom Field 5",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 6",
"group": "",
"id": 8393,
"initiallyVisible": true,
"name": "Custom Field 6",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 7",
"group": "",
"id": 8395,
"initiallyVisible": true,
"name": "Custom Field 7",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 8",
"group": "",
"id": 8397,
"initiallyVisible": true,
"name": "Custom Field 8",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 9",
"group": "",
"id": 8399,
"initiallyVisible": true,
"name": "Custom Field 9",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 10",
"group": "",
"id": 8401,
"initiallyVisible": true,
"name": "Custom Field 10",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 11",
"group": "",
"id": 8403,
"initiallyVisible": true,
"name": "Custom Field 11",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 12",
"group": "",
"id": 8405,
"initiallyVisible": true,
"name": "Custom Field 12",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 13",
"group": "",
"id": 8407,
"initiallyVisible": true,
"name": "Custom Field 13",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 14",
"group": "",
"id": 8409,
"initiallyVisible": true,
"name": "Custom Field 14",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 15",
"group": "",
"id": 8411,
"initiallyVisible": true,
"name": "Custom Field 15",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 16",
"group": "",
"id": 8413,
"initiallyVisible": true,
"name": "Custom Field 16",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 17",
"group": "",
"id": 8415,
"initiallyVisible": true,
"name": "Custom Field 17",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 18",
"group": "",
"id": 8417,
"initiallyVisible": true,
"name": "Custom Field 18",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 19",
"group": "",
"id": 8419,
"initiallyVisible": true,
"name": "Custom Field 19",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 20",
"group": "",
"id": 8421,
"initiallyVisible": true,
"name": "Custom Field 20",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 21",
"group": "",
"id": 8423,
"initiallyVisible": true,
"name": "Custom Field 21",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 22",
"group": "",
"id": 8425,
"initiallyVisible": true,
"name": "Custom Field 22",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 23",
"group": "",
"id": 8427,
"initiallyVisible": true,
"name": "Custom Field 23",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 24",
"group": "",
"id": 8429,
"initiallyVisible": true,
"name": "Custom Field 24",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 25",
"group": "",
"id": 8431,
"initiallyVisible": true,
"name": "Custom Field 25",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 26",
"group": "",
"id": 8433,
"initiallyVisible": true,
"name": "Custom Field 26",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 27",
"group": "",
"id": 8435,
"initiallyVisible": true,
"name": "Custom Field 27",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 28",
"group": "",
"id": 8437,
"initiallyVisible": true,
"name": "Custom Field 28",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 29",
"group": "",
"id": 8439,
"initiallyVisible": true,
"name": "Custom Field 29",
"type": "STRING",
"withTotal": false
},
{
"css": "",
"currencyColumnId": 0,
"displayName": "Custom Field 30",
"group": "",
"id": 8441,
"initiallyVisible": true,
"name": "Custom Field 30",
"type": "STRING",
"withTotal": false
}
],
"title": "Transaction Details",
"params": [
{
"name": "Period",
"value": "LAST_WEEK"
},
{
"name": "Merchant Id",
"value": "523585"
}
],
"date_range": "09/22/2019 - 09/28/2019"
}
"Transaction Details"
"Results for 09/01/2019 - 09/30/2019"
"Report parameters:"
"Period=LAST_MONTH"
"Merchant Id=523585"
"Invoice ID","Original Invoice ID","Merchant Transaction ID","PayPal Transaction ID","Transaction Type","Transaction Date","Transaction Time (PST)","Purchase Date","Payment ID","Refund / Chargeback Reason","Product","Product ID","Contract","Contract ID","SKU Type","Payment Frequency","Recurring Cycle Group","Recurring Cycle Number","Payment Type","Card Network","Qty","BIN Country","BIN Issuer Organization","Regulated Issuer","BIN Number","BIN Card Type","Last 4 Digits","Expiration Date","Auth. Currency","Merchant Sales (Auth Currency)","BlueSnap Processing Fees (USD)","PayPal Processing Fees (USD)","Vat / Tax","Merchant Base Currency","Merchant Sales (Base Currency)","Coupon Code","Shopper ID","Shopper First Name","Shopper Last Name","Shopper Email","PayPal Email","Shopper Country","Shopper State","Company Name","Vendor / Affiliate ID","Vendor / Affiliate Name","Vendor / Affiliate Commission (Auth. Currency)","Soft Descriptor","3DS Authentication","Custom Field 1","Custom Field 2","Custom Field 3","Custom Field 4","Custom Field 5","Custom Field 6","Custom Field 7","Custom Field 8","Custom Field 9","Custom Field 10","Custom Field 11","Custom Field 12","Custom Field 13","Custom Field 14","Custom Field 15","Custom Field 16","Custom Field 17","Custom Field 18","Custom Field 19","Custom Field 20","Custom Field 21","Custom Field 22","Custom Field 23","Custom Field 24","Custom Field 25","Custom Field 26","Custom Field 27","Custom Field 28","Custom Field 29","Custom Field 30"
"1019523676","1019523676","","","Sale","09/30/2019","01:00:46","","","","test product API","10299448","Standard monthly SUB - API test","12151480","Recurring contract","Monthly","Recurring","27","Credit Card","Visa","1","UNITED STATES","JPMORGAN CHASE BANK, N.A.","Y","411111","CREDIT","1111","01/2021","USD","25.00","1.75","0.00","0.00","USD","25.00","","21937075","Daniel","Millar","[email protected]","","Israel","","","","","0.00","DANIEL_BLUESNAP","No","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"1019500824","1019500824","","","Sale","09/26/2019","04:00:16","","2019W39","","One-Time Product","432949","subscription test contract","2337423","Recurring contract","Monthly","Recurring","28","Credit Card","Visa","1","UNITED STATES","JPMORGAN CHASE BANK, N.A.","Y","411111","CREDIT","1111","01/2021","USD","25.00","1.75","0.00","0.00","USD","25.00","","21858491","TestVaultedShopper","TVS","[email protected]","","Israel","","","","","0.00","daniel_bluesnap","No","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"1019492568","1019492568","","","Sale","09/25/2019","02:01:11","","2019W39","","Adam example","472081","subscription 1000","2423381","Recurring contract","Monthly","Recurring","12","Credit Card","Visa","1","UNITED STATES","JPMORGAN CHASE BANK, N.A.","Y","411111","CREDIT","1111","01/2022","USD","12.43","1.12","0.00","0.00","USD","12.43","","23198705","daniel","millar","[email protected]","","Israel","","","","","0.00","daniel_bluesnap","No","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"1019475930","1019475930","","","Sale","09/23/2019","22:49:19","","2019W39","","test product API","10299448","Standard monthly SUB - API test","12151480","Recurring contract","Monthly","Recurring","30","Credit Card","Visa","1","UNITED STATES","JPMORGAN CHASE BANK, N.A.","Y","411111","CREDIT","1111","09/2019","USD","25.00","1.75","0.00","0.00","USD","25.00","","29563424","John","Doe","[email protected]","","United States","CA","JohnDoeAndSons","","","0.00","DANIEL_BLUESNAP","No","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"1025470089","1025470089","","","Sale","09/20/2019","00:00:49","","2019W38","","One-Time Product","432949","subscription 2 test","2337425","Recurring contract","Monthly","Recurring","30","Credit Card","Discover","1","","","","601155","","9458","12/2021","USD","23.00","1.65","0.00","0.00","USD","23.00","","21729891","John","Doe"," [email protected]","","United States","CA","JohnDoeAndSons","","","0.00","daniel_bluesnap","No","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"1025406399","1025406399","","","Sale","09/18/2019","06:00:24","","2019W38","","Adam example","472081","subscription 1000","2423381","Recurring contract","Monthly","Recurring","11","Credit Card","Visa","3","UNITED STATES","JPMORGAN CHASE BANK, N.A.","Y","411111","CREDIT","1111","01/2022","USD","37.35","2.37","0.00","0.00","USD","37.35","","23298117","bla","blabla","[email protected]","","United States","CA","","","","0.00","daniel_bluesnap","No","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"1025314601","1025314601","","","Sale","09/14/2019","02:00:34","","2019W38","","Subscriptions","10299442","subscription product 2","2388011","Recurring contract","Monthly","Recurring","20","Credit Card","Visa","1","UNITED STATES","JPMORGAN CHASE BANK, N.A.","Y","411111","CREDIT","1111","01/2022","USD","1.00","0.55","0.00","0.00","USD","1.00","","22417205","Daniel","Millar","[email protected]","","Israel","","","","","0.00","daniel_bluesnap","No","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"1019429504","1019429504","","","Sale","09/03/2019","22:00:26","","2019W38","","One-Time Product","432949","subscription test contract","2337423","Recurring contract","Monthly","Recurring","29","Credit Card","Visa","1","UNITED STATES","JPMORGAN CHASE BANK, N.A.","Y","411111","CREDIT","1111","01/2021","ILS","92.67","1.75","0.00","0.00","USD","25.00","","21747437","Daniel new","new name","[email protected]","","Israel","","","","","0.00","daniel_bluesnap","No","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
{
"data": [
{
"Currency": "USD",
"Total of Gross Amount": "57,622.63",
"Total of Commission Amount": "-1,864.41",
"Affiliates Amount": "0.00",
"Total of Net Amount": "55,758.22",
"Total of Paid by 3rd Party": "-13,227.74",
"Total of Payout Adjustment Amount": "0.00",
"Account Balance": "42,530.48"
}
],
"title": "Account Balance",
"params": [
{
"name": "Period",
"value": "THIS_MONTH"
},
{
"name": "Merchant Id",
"value": "391328"
}
],
"date_range": "01/01/2017 - 01/24/2017"
}
Back to Top