Sorry, you need to enable JavaScript to visit this website.
Skip to main content

Count of Transactions by Merchants - All Accounts

Overview

The Count of Transactions by Merchants - All Accounts insight is a schedule-trigger insight that tracks the user's spending across the top merchants based on the total number of transactions done during the given duration across all the aggregated bank and card accounts.

Following are the additional details for the insight:

Insight Name COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS
Applicable Entity ACCOUNT
Insight Type AGGREGATE
Trigger Type SCHEDULE
Supported Containers BANK, CARD

Use Cases

  • Customer:
    • User engagement
    • Up-Sell / Cross-Sell opportunities - Offer co-branded products or dedicated offers based on the user spending pattern
  • User:
    • Financial awareness - Keep track of spending.

Suggested Action

NA

Duplicate Insight Checks

To prevent the same insight from generating repeatedly, the insight is generated once per scheduled frequency for a user.

The following are the applicable frequencies for this insight:

Frequency Description
DAILY The insight will be triggered daily. Duplicate check will evaluate if the insight instance that matches the duplicate check criteria exists for the current day from 12:00 AM same day to the time of insight evaluation.
WEEKLY The insight will be triggered once every Monday. Duplicate check will evaluate if the insight instance that matches the duplicate check criteria exists for the current calendar week (Monday to Sunday).
For example:
  • Normal scenario: If the calendar week starts from 1st January to 7th January, the insight is triggered on 1st January.
  • Dynamic trigger scenario: If the calendar week starts from 1st January to 7th January, and the user triggers an insight on 3rd January using dynamic trigger, duplicate check happens from 1st January to 3rd January.
MONTHLY The insight will be triggered once on the first day of the calendar month. Duplicate check will evaluate if the insight instance that matches the duplicate check criteria exists for the current calendar month (1st of the calendar month to the last day of the month).
For example:
  • Normal scenario: If the calendar month starts from 1st January to 31st January, the insight is triggered on 1st January.
  • Dynamic trigger scenario: If the calendar month starts from 1st January to 31st January, and the user triggers an insight on 3rd January using dynamic trigger, duplicate check happens from 1st January to 3rd January.

Insight Dynamic Trigger (On-Demand Evaluation)

The insight can be triggered using the following on-demand insight trigger API:

Method and URL:

POST   /insights/trigger

Peer Benchmarking Data

This insight does not provide peer benchmarking data.

Thresholds

Threshold lets the customer or the user decide when the user has to be alerted about the transactions spending trends.

  • Threshold Name: TOP
  • Data Type: NUMBER
  • Range Allowed: 1 <= TOP <= 50
  • Default: 10

Note: Depending on the customer segment and account, threshold might need to be different for different users. If the default value is insufficient, the users can set a threshold they are comfortable tracking.

GET Customer Subscription

The GET customer subscription API provides all the information about the defaults set for the insights that are subscribed by the customer. The default frequency for the insight is MONTHLY and the default duration for the insight is THREE_MONTHS.

Method and URL:

GET   /insights/configs/customerSubscriptions

Header Parameters:

Key Value
Authorization Client credentials-based authorization Bearer {{Access Token}}
API key-based authentication Bearer {{JWT Token_Customer}}
Deprecated cobrand and user credential-based authentication cobSession={cobSession received in the cobrand login service}
Content-Type application/json
Api-Version 2.1
2
Cobrand-Name {Name of the Customer}

Sample Request:

GET /insights/configs/customerSubscriptions

Sample Response:

For more information about the attributes that are returned in the API response, refer to the Insights Data Model page.

  • Api-Version 2.1 Response
{
   "customerSubscription":[
    {
            "insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS",
            "insightTitle": "Count of Transactions By Merchants - All Accounts",
            "insightType": "AGGREGATE",
            "triggerType": "SCHEDULE",
            "containers": [
                "BANK",
                "CARD"
            ],
            "description": "Generates an insight that provides spending trends (based on transaction count) by merchant over a configured time period across all the eligible accounts for the user.",
            "applicableEntity": [
                "ACCOUNT"
            ],
            "customerConfiguration": [
                {
                "entityType": "ACCOUNT",
                    "isSubscribed": true,
                    "frequency": "MONTHLY",
                    "duration": "THREE_MONTHS",
                    "threshold": [
                        {
                            "name": "TOP",
                            "value": "10",
                            "type": "NUMBER"
                        }
                    ]
                }
            ]
        }
   ]
}
  • Api-Version 2 Response
{
   "customerSubscription":[
    {
            "insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS",
            "insightTitle": "Count of Transactions By Merchants - All Accounts",
            "insightType": "AGGREGATE",
            "triggerType": "SCHEDULE",
            "container": [
                "BANK",
                "CARD"
            ],
            "description": "Generates an insight that provides spending trends (based on transaction count) by merchant over a configured time period across all the eligible accounts for the user.",
            "applicableEntity": [
                "ACCOUNT"
            ],
            "customerConfiguration": [
                {
                "entityType": "ACCOUNT",
                    "isSubscribed": true,
                    "frequency": "MONTHLY",
                    "duration": "THREE_MONTHS",
                    "threshold": [
                        {
                            "name": "TOP",
                            "value": "10",
                            "type": "NUMBER"
                        }
                    ]
                }
            ]
        }
   ]
}

PATCH Customer Subscription

Using the PATCH API for customer subscription, customers can change the defaults for each insight. Alternatively, customers can use the insights configuration tool to achieve the same result.

Warning! Changing any defaults can potentially impact all users who have subscribed to this insight. If the user has overridden the customer threshold, then the user preference will be applied. For all other users, the new defaults will apply.

Method and URL:

PATCH   /insights/configs/customerSubscriptions

Header Parameters:

Key Value
Authorization Client credentials-based authorization Bearer {{Access Token}}
API key-based authentication Bearer {{JWT Token_Customer}}
Deprecated cobrand and user credential-based authentication cobSession={cobSession received in the cobrand login service}
Content-Type application/json
Api-Version 2.1
2
Cobrand-Name {Name of the Customer}

Editable Parameters:

Editable Attributes Impact Allowed Values
isSubscribed Subscribes or unsubscribes all the users from the Count of Transactions by Merchants - All Accounts insight. true, false
insightTitle The title returned in the GET feed API as well as the insights config tool can be changed. Alphanumeric characters up to 100 characters (including spaces)
frequency The frequency with which an insight will be evaluated.
  • DAILY (every day - early morning)
  • WEEKLY (every Monday - early morning)
  • MONTHLY (1st of every month - early morning)
duration The data range that should be considered for evaluating the insight.
  • THIS MONTH
  • LAST MONTH
  • THREE_MONTHS (current month + last 2 months)
  • SIX_MONTHS (current month + last 5 months)
threshold The threshold (TOP) can be modified. Any number between 1 and 50.

Sample Request:

{
   "customerSubscription":[
      {
            "insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS",
            "insightTitle": "Count of Transactions By Merchants - All Accounts",
            "customerConfiguration": [
                {
                    "entityType": "ACCOUNT",
                    "isSubscribed": true,
                    "frequency": "MONTHLY",
                    "duration": "THREE_MONTHS",
                    "threshold": [
                        {
                            "name": "TOP",
                            "value": "10",
                            "type": "NUMBER"
                        }
                    ]
                }
            ]
        }
   ]
}

Response Messages:

HTTP Status Code Reason
HTTP Status Code Reason
400 Y806: Invalid Input
400 Y800: Invalid value for insightName
400 Y800: Invalid value for insightTitle; special characters ><\"'%{}|^~[] are not supported
400 Y801: Invalid length for insightTitle; min 3 and max 100 characters including spaces are allowed.
400 Y800: Invalid value for TOP in COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS insight Min =1 and Max = 50
400 Y813: Invalid request. The entire object within threshold should be provided
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, modifying applicableEntity is not allowed
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, modifying triggerType is not allowed
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, modifying container is not allowed
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, modifying description is not allowed
400 Y800: Invalid value for isSubscribed; Supported values are true, false
400 Y825: Update not allowed without a valid request body
400 Y803: Invalid request; Either a valid insightTitle or customerConfiguration is required.
400 Y800: Invalid value for frequency; Supported values are DAILY, MONTHLY, WEEKLY
400 Y800: Invalid value for duration; Supported values are THIS_MONTH, LAST_MONTH, THREE_MONTHS, SIX_MONTHS
400 Y812: Required field/value - insightName missing in the request
400 Y802: Modifying InsightType attribute is not allowed
400 Y813 :entityType should be provided
400 Y803 :At least one additional attribute is required in addition to entityType.
400 Y800: Invalid value for customerConfiguration; customerConfiguration is either missing, duplicated, or has insufficient/ incorrect attributes.
400 Y800: Invalid value for entityType. Supported entityType for COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS insight are - [ACCOUNT]
400 Y802: For COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS insight, {Invalid String} inside the threshold is either repeated or not allowed
400 Y802: For COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS insight, {Invalid String} inside the threshold is not allowed
400 Y800: Invalid value for input json
401 Y020: Invalid token in authorization header
401 Y020: Token has expired

GET User Subscription

The GET user subscription API provides all the information about the user defaults set for the insight.

The entityId filter is not applicable for this insight.

Method and URL:

GET   /insights/configs/userSubscriptions

Header Parameters:

Key Value
Authorization Client credentials-based authorization Bearer {{Access Token}}
API key-based authentication Bearer {{JWT Token_Customer}}
Deprecated cobrand and user credential-based authentication cobSession={cobSession received in the cobrand login service}, userSession={userSession received in the user login service}
Content-Type application/json
Api-Version 2.1
2
Cobrand-Name {Name of the Customer}

Sample Request:

GET /insights/configs/userSubscriptions?insightName=COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS

Sample Response:

For more information about the attributes that are returned in the API response, refer to the Insights Data Model page.

  • Api-Version 2.1 Response
{
   "userSubscription":[
    {
            "insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS",
            "insightTitle": "Count of Transactions By Merchants - All Accounts",
            "insightType": "AGGREGATE",
            "triggerType": "SCHEDULE",
            "containers": [
                "BANK",
                "CARD"
            ],
            "description": "Generates an insight that provides spending trends (based on transaction count) by merchant over a configured time period across all the eligible accounts for the user.",
            "applicableEntity": [
                "ACCOUNT"
            ],
            "userConfiguration": [
                {
                    "entityType": "ACCOUNT",
                    "isSubscribed": true,
                    "frequency": "MONTHLY",
                    "duration": "THREE_MONTHS",
                    "threshold": [
                        {
                            "name": "TOP",
                            "value": "10",
                            "type": "NUMBER"
                        }
                    ]
                }
            ],
            "customerConfiguration": [
                {
                    "entityType": "ACCOUNT",
                    "isSubscribed": true,
                    "frequency": "MONTHLY",
                    "duration": "THREE_MONTHS",
                    "threshold": [
                        {
                            "name": "TOP",
                            "value": "10",
                            "type": "NUMBER"
                        }
                    ]
                }
            ]
        }
   ]
}
  • Api-Version 2 Response
{
   "userSubscription":[
    {
            "insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS",
            "insightTitle": "Count of Transactions By Merchants - All Accounts",
            "insightType": "AGGREGATE",
            "triggerType": "SCHEDULE",
            "container": [
                "BANK",
                "CARD"
            ],
            "description": "Generates an insight that provides spending trends (based on transaction count) by merchant over a configured time period across all the eligible accounts for the user.",
            "applicableEntity": [
                "ACCOUNT"
            ],
            "userConfiguration": [
                {
                    "entityType": "ACCOUNT",
                    "isSubscribed": true,
                    "frequency": "MONTHLY",
                    "duration": "THREE_MONTHS",
                    "threshold": [
                        {
                            "name": "TOP",
                            "value": "10",
                            "type": "NUMBER"
                        }
                    ]
                }
            ],
            "customerConfiguration": [
                {
                    "entityType": "ACCOUNT",
                    "isSubscribed": true,
                    "frequency": "MONTHLY",
                    "duration": "THREE_MONTHS",
                    "threshold": [
                        {
                            "name": "TOP",
                            "value": "10",
                            "type": "NUMBER"
                        }
                    ]
                }
            ]
        }
   ]
}

PATCH User Subscription

Using the PATCH user subscription API for user subscription, users can change the defaults for each insight. If the user wants the insight to be evaluated for a new account, then add that account using the PATCH user subscription API. The customer default threshold values will apply if the user has not set any values.

Method and URL:

PATCH   /insights/configs/userSubscriptions

Header Parameters:

Key Value
Authorization Client credentials-based authorization Bearer {{Access Token}}
API key-based authentication Bearer {{JWT Token_Customer}}
Deprecated cobrand and user credential-based authentication cobSession={cobSession received in the cobrand login service}, userSession={userSession received in the user login service}
Content-Type application/json
Api-Version 2.1
2
Cobrand-Name {Name of the Customer}

Editable Parameters:

Editable Attributes Impact Allowed Values
isSubscribed Subscribes or unsubscribes from the Count of Transactions by Merchants - All Accounts insight. true, false
frequency The frequency with which an insight will be evaluated.
  • DAILY (every day - early morning)
  • WEEKLY (every Monday - early morning)
  • MONTHLY (1st of every month - early morning)
duration The data range that should be considered for evaluating the insight.
  • THIS MONTH
  • LAST MONTH
  • THREE_MONTHS (current month + last 2 months)
  • SIX_MONTHS (current month + last 5 months)
  • ONE_YEAR (current month + last 11 months)
threshold The threshold (TOP) can be modified. Any number between 1 and 50.

Sample Request:

{
   "userSubscription":[
    {
            "insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS",
            "userConfiguration": [
                {
                    "entityType": "ACCOUNT",
                    "isSubscribed": true,
                    "frequency": "MONTHLY",
                    "duration": "THREE_MONTHS",
                    "threshold": [
                        {
                         "name": "TOP",
                            "value": "10",
                            "type": "NUMBER"
                        }
                    ]
                }
            ]
        }
   ]
}

Response Messages:

HTTP Status Code Reason
400 Y806: Invalid input
400 Y800: Invalid value for insightName
400 Y800: Invalid value for input param in COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS insight
400 Y802: Modifying insightTitle using this API is not allowed
400 Y800: Invalid value for threshold data in COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS insight
400 Y800: Invalid value for TOP in COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS insight Min =1 and Max = 50
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, modifying applicableEntity is not allowed
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, modifying triggerType is not allowed
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, modifying container is not allowed
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, modifying description is not allowed
400 Y800: Invalid value for frequency; Supported values are DAILY, MONTHLY, WEEKLY
400 Y800: Invalid value for duration; Supported values are THIS_MONTH, LAST_MONTH, THREE_MONTHS, SIX_MONTHS
400 Y813: Invalid request. The entire object within threshold should be provided
400 Y800: Invalid value for isSubscribed; Supported values are true, false
400 Y825: Update not allowed without a valid request body
400 Y812: Required field/value - insightName missing in the request
400 Y802: Modifying InsightType attribute is not allowed
400 Y813: entityType should be provided
400 Y803: At least one additional attribute is required in addition to entityType.
400 Y800: Invalid value for userConfiguration; userConfiguration is either missing, duplicated, or has insufficient/ incorrect attributes
400 Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS, configurations at an entityId level are not allowed
400 Y800: Invalid value for entityType. Supported entityType for COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS insight are - [ACCOUNT]
400 Y800: Invalid value for input json
401 Y020: Invalid token in authorization header
401 Y020: Token has expired

GET Insight Feeds

The GET insights feed API retrieves all or a subset of the valid insight notifications generated for a particular user. However, using the insightName filter, the Count of Transactions by Merchants - All Accounts insight can be specifically requested. The insight will be generated only if transactionCount for all merchants and debitTotal are greater than 0.

The entityId filter does not apply to this insight.

Calculation Logic for Derived Attributes:
averageNetTotal = netTotal/duration

Method and URL:

GET   /insights/feed

Header Parameters:

Key Value
Authorization Client credentials-based authorization Bearer {{Access Token}}
API key-based authentication Bearer {{JWT Token_Customer}}
Deprecated cobrand and user credential-based authentication cobSession={cobSession received in the cobrand login service}, userSession={userSession received in the user login service}
Content-Type application/json
Api-Version 2.1
2
Cobrand-Name {Name of the Customer}

Sample Request:

GET /insights/feed?insightName=COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS

Sample Response:

For more information about the attributes that are returned in the API response, refer to the Insights Data Model page.

{
   "feed":[
      {
         "id":"60d43dbed59fdb46b0c91209",
         "insightName":"COUNT_OF_TRANSACTIONS_BY_MERCHANT_ALL_ACCOUNTS",
         "insightTitle":"Count of Transactions By Merchants - All Accounts",
         "insightType":"AGGREGATE",
         "triggerType":"SCHEDULE",
         "createdDate":"2021-06-24T08:09:31Z",
         "subscription":[
            {
               "entityType":"ACCOUNT",
               "frequency":"MONTHLY",
               "duration":"THREE_MONTHS",
               "threshold":[
                  {
                     "name":"TOP",
                     "value":"10",
                     "type":"NUMBER"
                  }
               ]
            }
         ],
         "basicAccount":[
            {
               "id":13709572,
               "providerName":"Dag Site",
               "accountName":"PDV Test Data- All Category",
               "accountType":"OTHER",
               "container":"bank",
               "link":{
                  "entityName":"account",
                  "url":"/accounts?accountId=13709572"
               }
            },
            {
               "id":13709567,
               "providerName":"Dag Site",
               "accountName":"PDV_Test_Data_Sch/Ref",
               "accountType":"CHECKING",
               "container":"bank",
               "link":{
                  "entityName":"account",
                  "url":"/accounts?accountId=13709567"
               }
            }
         ],
         "basicTrend":[
            {
               "debitTotal":{
                  "amount":488286.09,
                  "currency":"USD"
               },
               "creditTotal":{
                  "amount":2779.86,
                  "currency":"USD"
               },
               "netTotal":{
                  "amount":485506.23,
                  "currency":"USD"
               },
               "averageNetTotal":{
                  "amount":161835.41,
                  "currency":"USD"
               },
               "transactionCount":251,
               "merchantTrend":[
                  {
                     "basicMerchant":{
                        "name":"Others"
                     },
                     "debitTotal":{
                        "amount":276028.44,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":478.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":275550.44,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":91850.15,
                        "currency":"USD"
                     },
                     "transactionCount":150,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":87357.23,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":26.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":87331.23,
                              "currency":"USD"
                           },
                           "transactionCount":51
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                           "debitTotal":{
                              "amount":87795.23,
                              "currency":"USD"
                           },
                           "creditTotal":{
                           "amount":126.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":87669.23,
                              "currency":"USD"
                           },
                           "transactionCount":49
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                              "amount":100875.98,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":326.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":100549.98,
                              "currency":"USD"
                           },
                           "transactionCount":50
                        }
                     ]
                  },
                  {
                     "basicMerchant":{
                        "name":"Duke Energy"
                     },
                     "debitTotal":{
                        "amount":100399.76,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":100399.76,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":33466.59,
                        "currency":"USD"
                     },
                     "transactionCount":5,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                               "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":99999.76,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":99999.76,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                           "debitTotal":{
                              "amount":200.0,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":200.0,
                              "currency":"USD"
                           },
                           "transactionCount":2
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                              "amount":200.0,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":200.0,
                              "currency":"USD"
                           },
                           "transactionCount":2
                        }
                     ]
                     },
                  {
                     "basicMerchant":{
                        "name":"Insurance"
                     },
                     "debitTotal":{
                        "amount":14500.0,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":14500.0,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":4833.33,
                        "currency":"USD"
                     },
                     "transactionCount":2,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":14500.0,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":14500.0,
                              "currency":"USD"
                           },
                           "transactionCount":2
                        }
                     ]
                  },
                  {
                     "basicMerchant":{
                        "name":"Netflix"
                     },
                     "debitTotal":{
                        "amount":4199.0,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                         },
                     "netTotal":{
                        "amount":4199.0,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":1399.67,
                        "currency":"USD"
                     },
                     "transactionCount":5,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":2999.0,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":2999.0,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                           "debitTotal":{
                              "amount":600.0,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":600.0,
                              "currency":"USD"
                           },
                           "transactionCount":2
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                            "amount":600.0,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":600.0,
                              "currency":"USD"
                           },
                           "transactionCount":2
                        }
                     ]
                  },
                  {
                     "basicMerchant":{
                        "name":"Advertising"
                     },
                     "debitTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":1344.75,
                        "currency":"USD"
                     },
                     "transactionCount":3,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                           },
                        {
                           "dateRange":{
                              "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        }
                     ]
                  },
                  {
                     "basicMerchant":{
                        "name":"Breton Bay Dentistry"
                     },
                     "debitTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":4034.25,
                         "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":1344.75,
                        "currency":"USD"
                     },
                     "transactionCount":3,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                            "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        }
                     ]
                  },
                  {
                     "basicMerchant":{
                        "name":"Campus BookStore"
                     },
                     "debitTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":1344.75,
                        "currency":"USD"
                     },
                     "transactionCount":3,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                           "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        }
                     ]
                  },
                  {
                     "basicMerchant":{
                        "name":"Creative Child"
                     },
                     "debitTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                     "amount":1344.75,
                        "currency":"USD"
                     },
                     "transactionCount":3,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                               },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        }
                     ]
                  },
                  {
                     "basicMerchant":{
                        "name":"Home Improvement"
                     },
                     "debitTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":1344.75,
                        "currency":"USD"
                     },
                     "transactionCount":3,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                            "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        }
                     ]
                  },
                  {
                     "basicMerchant":{
                        "name":"Kings College"
                     },
                     "debitTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "creditTotal":{
                        "amount":0.0,
                        "currency":"USD"
                     },
                     "netTotal":{
                        "amount":4034.25,
                        "currency":"USD"
                     },
                     "averageNetTotal":{
                        "amount":1344.75,
                        "currency":"USD"
                     },
                     "transactionCount":3,
                     "detail":[
                        {
                           "dateRange":{
                              "fromDate":"2021-06-01",
                              "toDate":"2021-06-24"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-05-01",
                              "toDate":"2021-05-31"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        },
                        {
                           "dateRange":{
                              "fromDate":"2021-04-01",
                              "toDate":"2021-04-30"
                           },
                           "debitTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "creditTotal":{
                              "amount":0.0,
                              "currency":"USD"
                           },
                           "netTotal":{
                              "amount":1344.75,
                              "currency":"USD"
                           },
                           "transactionCount":1
                        }
                     ]
                  }
               ]
            }
         ]
      }
   ]
}