Get Customer Ledger Explode Info

The Customer Ledger Explode Info API retrieves additional points ledger info for a customer or user group in a connected organisation.

A customer points ledger is essentially a record that tracks the points earned, spent, and adjusted within an organization and its affiliates. These points are treated like currency and can be redeemed across various units or loyalty programs within the organization.

For more information, refer to the documentation on Points Ledgers.

API endpoint example

(https://eucrm.cc.capillarytech.com/v2.1/pointsLedger/getLedgerExplodeInfo?identifierName=mobile&identifierValue=917406401004&source=INSTORE&eventIds=18608683

Prerequisites

  • Authentication: Basic or OAuth credentials
  • Access points group resource: Read access to customer points group resource

Resource information

URIv2.1/pointsLedger/getLedgerExplodeInfo
HTTP MethodGET
PaginationYes
Batch supportNo
Rate limit informationNA

Headers

HeaderDescription
DATA-SCOPE-ORGList of Organization IDs
DATA-SCOPEScopes define what data can be accessed using the API. You can use scopes to control access to data from a parent or child organization. Defining a scope ensures that the response contains only data from the respective organization.

Supported headers: SELF and OTHER.

Refer to connected orgs data scopes for more information.

Query parameters

Parameter NameData TypeDescription
identifierName*StringIdentifier of the customer. Supported values mobile , id, email and externalid
identifierValue*IntegerValue for the identifier. For example, the mobile number or customer ID.
source*StringSource in which the identifier is available. For example,INSTORE, MARTJACK, WECHAT, FACEBOOK, WEB_ENGAGE, TMALL, TAOBAO, JD, ECOMMERCE, WEBSITE, LINE, ALL
eventIds*StringThe list of eventIDs with comma separated values. These are eventLogIds, corresponding to the events in loyalty like TransactionAdd, CustomerRegistration etc.
accountIdStringFor a source with multiple accounts, pass the specific accountId in which the customer identifier is available.
getBillDetailsBooleanSetting this to true will return Bill details like the bill no, amount, discount, line items etc
getPointsEarnedBreakupBooleanSetting this to true will return the points breakup details like points category Name, points allocation strategy Name, expiry strategy etc
getCustomFieldsBooleanSetting this value will return the custom fields set up by the brand
getExtendedFieldsBooleanSetting this field will return the extended fields set up by the brand
getMaxConversionDetailsBooleanSetting this field to true will return the max conversion details which is set for Add Transation, for all line items where delayed accrual is based on fixed or return date, max of all dates is calculated and show in the field name “maxConversionDate”
getPaymentModeStringSetting this field will show an array of payment modes used ex UPI, CASH etc
typeStringSetting this filed returns entries for type of user, whether individual customer or a group. Only two values are allowed here - CUSTOMER, USERGROUP2
isPrimaryUserBooleanReturns entry for the primary member of a group, in case of usergroups.
includeAlternateCurrenciesBooleanPass includeAlternateCurrencies=true to retrieve all alternate currencies available with the customer.
alternateCurrencyNamesStringFilter alternate currencies for the customer based on the name. You can also pass a list of comma-separated alternate currency names. Set the parameter includeAlternateCurrencies to false when you use this. If the value is true, includeAlternateCurrencies lists all the available currencies.
eventNameStringName of the event (GenericEvent, TransactionAdd, ReturnBill). An event refers to any activity performed by a customer, whether in an online store or a physical store.

GenericEvent: A generic event refers to a customizable behavioral event where specific attributes like Customer ID or Product SKU are used to track events.
TransactionAdd: A transaction add refers to the addition of a new transaction to the system.
ReturnBill: A return bill refers to a transaction where items previously purchased are returned, and any achievements earned are revoked.
eventReferenceIdsIntegerA reference ID is a unique identifier that links to an event.
For TransactionAdd and ReturnBill, the reference ID is the billId of the transaction.
For GenericEvent, the reference ID is the unique request ID for the event.

You can add up to ten reference IDs for the specified eventName separated by commas.

Refer to the documentation on getting transaction details and getting event details for more information.

Response parameters

ParameterData TypeDescription
eventLogIdIntegerUnique identifier for the event log.
eventNameStringName of the event that occurred.
eventDetailsObjectContains details about the event, such as time and ID.
eventTimeStringTimestamp of when the event occurred. YYYY-MM-DD HH:MM:SS.S
tillIdIntegerUnique ID of the till.
eventReferenceIdStringReference ID associated with the event.
orgIdIntegerUnique ID of the associated organization.

Sample Response

{
    "events": [
        {
            "eventLogId": 13499091,
            "eventName": "TransactionAdd",
            "eventDetails": {
                "eventTime": "2024-08-30 11:17:57.0",
                "tillId": 50161182
            "eventReferenceId": "36363905",
            "uniqueId": "aBcdEfG1H2",
            "orgId": 50406
        }
    ],
    "warnings": []
}
{
    "events": [
        {
            "eventLogId": 18608683,
            "eventName": "TransactionAdd",
            "eventDetails": {
                "eventTime": "2024-08-20 11:29:02.0",
                "tillId": 50681412
            },
            "eventReferenceId": "2151165932",
            "orgId": 4000218
        }
    ],
    "warnings": []
}
{
    "events": [
        {
            "eventLogId": 27909380,
            "eventName": "CustomerRegistration",
             “eventReferenceIds“:{RefId1},
            "eventDetails": {
                "eventTime": "2024-01-18 17:18:00.0",
                "tillId": 50697469
            },
            "pointsEarned": {
                "regular": [],
                "promo": [],
                "promised": []
            }
        },

{
            "eventLogId": 27909380,
            "eventName": "CustomerRegistration",
             “eventReferenceIds“:{RefId2},
            "eventDetails": {
                "eventTime": "2024-01-18 17:18:00.0",
                "tillId": 50697469
            },
            "pointsEarned": {
                "regular": [],
                "promo": [],
                "promised": []
            }
        }
    ],
    "warnings": []
}

API specific error codes

ErrorDescription
8013Identifier name missing or incorrect.
8015Identifier value missing or incorrect.
8003Source is missing or incorrect.
310144Connected Orgs not set properly in Headers.
Check whether the target organisation is a connected organisation.
Language
Credentials
Basic
base64
:
URL
Click Try It! to start a request and see the response here!