Get Report Data

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 the payout IPN, 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

Find the supported query parameters per report type here.

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.

Back to Top

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