Retrieves report data in either JSON or CSV format.
Report Availablity
There is a time delay of 2 to 3 hours for report data. You cannot retrieve data for transactions that took place within the last 3 hours.
Endpoint
https://sandbox.bluesnap.com/services/2/report/{reportCode}?param=value[¶m=value...]
Request Content
Enter the report ID and query string parameters in the request URL:
services/2/report/{reportCode}?param=value[¶m=value...]
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
Tips
Parsing report dataParse 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.
Parsing by parameter name is especially important for report data in CSV format.
Retrieving payout reports for reconciliationRetrieve the Payout Detail and Payout Summary reports after you receive the
PAYOUTwebhook. This webhook is sent when your deposits are finalized.
Report Codes
These are the supported report code. A report code represents the type of report that you want to retrieve. 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. See Account Balance Report. |
ActiveSubscriptions | Provides details about active subscriptions, such as the next charge date, Subscription ID, and shopper info. See Active Subscriptions Report. |
AddCardAttempts | Provides the results of all card addition and update attempts. See Status of Attempts to Add Card. |
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. See Account Updater (BlueSnap Vault Cards) Report. |
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. See Account Updater (Merchant Vault Cards) Report. |
BalanceDetail | Provides transaction-level detail for all the transactions included in your account balance. See Account Balance Detail Report. |
CanceledSubscriptions | Provides a list of canceled subscriptions that include the plan, shopper, and cancellation details. See Canceled Subscriptions Report. |
CardAuths | Provides transaction-level details for all card authorization attempts. See Card Authorizations Report. |
ChargeBacks | Displays all chargebacks and chargeback related data. See Chargebacks Report. |
DeclinedAuthFees | Provides a list of all declined authorizations and the fees for those that have been charged. See Declined Auth Details Report. |
DeclinedTransactions | Provides a list of declined credit and debit card transactions with decline reason, payment details, and shopper information. See Declined Transactions Report. |
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. See ACH/Direct Debit Report. |
MonthlySummary | Provides a summary of all the events that were included in payouts that went out during the selected month allocated per region, currency and account type, including non-processing fees and manual adjustments. See Monthly Summary Statement. |
PayoutDetail | Provides details about the transactions included in BlueSnap deposits to your account. See Payout Details Report. |
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. See Summary of Processing Statements Report. |
PayoutSummaryStatement | Access summary reports from past payout cycles to view details such as sales, refunds, fees, and more. See Payout Summary Statement Report. |
PendingRefunds | Displays a list of all refunds pending processing due to insufficient balance funds. See Pending Refunds Report. |
RecurringCharges | Provides details about all the recurring charges that were attempted. See Recurring Charges Report. |
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. See Running Balance Report. |
StoppedFraud | Provides details about transactions that were declined because of your fraud rules or BlueSnap's fraud detection logic. See Stopped Fraud Report. |
TransactionDetail | Provides details about each transaction, including shopper info, payment details, subscription info and more. See Transaction Details Report. |
VendorDetails | Provides account details for each of the vendors in your marketplace. See Vendor Details Report. |
Query String Parameters
Filter report results with query string parameters.
Paging
Report Pagination describes how the Reporting API supports pagination.
Response Details
If successful, the HTTP status code is 200 OK. The report data is included in the data property.
For details about each parameter, see BlueSnap Reporting.
Errors
This endpoint returns the following errors in response to reporting API requests:
| Code | Name | Description |
|---|---|---|
| 21001 | INVALID_INPUT | In case of bad input errors, the API returns HTTP code 400, along with information about the error. For example:Invalid Next Page Token |
| 21002 | GENERAL_REPORT_ERROR | In case of service errors, the API returns HTTP code 500, along with this message:BI Reports are currently unavailable; please try again later. |
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"
}