Get Points Ledger Explode Info

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

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

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.

Example request

curl --location 'https://eu.api.capillarytech.com/v2/pointsLedger/getLedgerExplodeInfo?identifierName=mobile&identifierValue=918088369835&source=INSTORE&eventIds=634510612' \
--header 'Authorization: Basic aWFtc2hpdkNWI1YTI5MWY=' \
--header 'Cookie: _cfuvid=PsFx0ALxLdrB1NEgHeuRoT3TmBSmBySaXbb3ptIqvJY-1732095262794-0.0.1.1-604800000'
curl --location 'https://eu.api.capillarytech.com/v2/pointsLedger/getLedgerExplodeInfo?identifierName=mobile&identifierValue=918088369835&source=INSTORE&eventName=TransactionAdd&eventReferenceIds=888812880' \
--header 'Authorization: Basic aWFtc2h1YTI5MWY=' \
--header 'Cookie: _cfuvid=PsFx0ALxLdrB1NEgHeuRoT3TmBSmBySaXbb3ptIqvJY-1732095262794-0.0.1.1-604800000'
curl --location 'https://eu.api.capillarytech.com/v2/pointsLedger/getLedgerExplodeInfo?identifierName=id&identifierValue=565039506&source=INSTORE&type=CUSTOMER&eventName=GenericEvent&eventReferenceIds=67587c26-d925-4f8d-9211-a9b4d6f8db8e' \
--header 'Authorization: Basic aWFtc2hpYTI5MWY=' \
--header 'Cookie: _cfuvid=PsFx0ALxLdrB1NEgHeuRoT3TmBSmBySaXbb3ptIqvJY-1732095262794-0.0.1.1-604800000'
curl --location 'https://eu.api.capillarytech.com/v2/pointsLedger/getLedgerExplodeInfo?identifierName=mobile&identifierValue=918088369835&source=INSTORE&eventIds=634510612&getPointsEarnedBreakup=true' \
--header 'Authorization: Basic ' \
--header 'Cookie: _cfuvid=PsFx0ALxLdrB1NEgHeuRoT3TmBSmBySaXbb3ptIqvJY-1732095262794-0.0.1.1-604800000; _cfuvid=8Dv9MBbR4vrWw540MN.YxjsaVPdriQsRVRJDtn4T2uE-1773323026611-0.0.1.1-604800000'

Prerequisites

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

Resource information

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

Query parameters

Parameter NameDescription
identifierName*Identifier type to identify the customer. Supported values: MOBILE, ID, EMAIL, CustomerID, primaryUserId, and EXTERNALID.
identifierValue*Value for the identifier. For example, the mobile number or customer ID.
source*Source in which the identifier is available. For example, INSTORE, MARTJACK, WECHAT, FACEBOOK, WEB_ENGAGE, TMALL, TAOBAO, JD, ECOMMERCE, WEBSITE, LINE, ALL.
eventIds**The list of eventLogId with comma-separated values. These are eventLogIds corresponding to events in loyalty, like TransactionAdd, CustomerRegistration, etc.
Note: Either eventIds, or a combination of eventName and eventReferenceIds, must be provided.
eventName**

Name of the event. Supports both behavioral and transactional events. Possible values: NewBill, TransactionAdd, GroupTransactionAdd, LineItemsPointsPromotionImport, BillPointsPromotionImport, CustomerPromotionImport, GenericEvent, CustomerRegistration, CustomerUpdate, AllocateGoodwillPoints, PointsTransfer, PointsRedemption, ReturnBill, TargetCompleted, ManualPointsAdjustment, VoucherRedemption

Note: Either eventIds or eventName and eventReferenceIds are mandatory.

eventReferenceIds**Reference ID for the event. For transactional events, this is the transaction ID. For behavioral events, this is the unique request ID generated when a behavioral event is triggered. You can add up to ten reference IDs for the specified eventName, separated by commas.
accountIdFor a source with multiple accounts, pass the specific accountId in which the customer identifier is available.
getBillDetailsSetting this to true will return bill details like bill number, amount, discount, line items, etc.
getPointsEarnedBreakupSetting this to true returns the points breakup details, such as the points category name, points allocation strategy name, expiry strategy, and other related information.
Ensure that the ENABLE_POINTS_AWARDED_SOURCE_VALUE_CAPTURING configuration is enabled.
getCustomFieldsSetting this value will return the custom fields set up by the brand.
getExtendedFieldsSetting this field will return the extended fields set up by the brand.
getMaxConversionDetailsSetting this field to true will return the max conversion details set for Add Transaction. For all line items where delayed accrual is based on fixed or return date, the max of all dates is calculated and shown in the field maxConversionDate.
getPaymentModesSetting this field will show an array of payment modes used (e.g., UPI, CASH, etc.).
typeReturns entries for type of user—either individual customer or group. Supported values: CUSTOMER, USERGROUP2.
isPrimaryUserReturns entry for the primary member of a group, in case of user groups.
includeAlternateCurrenciesPass includeAlternateCurrencies=true to retrieve all alternate currencies available for the customer.
alternateCurrencyNamesFilter alternate currencies for the customer based on the name. You can also pass a list of comma-separated currency names. Set includeAlternateCurrencies to false when using this. If true, all available currencies are listed.

Example Response

{
    "events": [
        {
            "eventLogId": 30527930,
            "eventName": "TargetCompleted",
            "eventDetails": {
                "eventTime": "2024-10-25 22:59:12.0",
                "tillId": 50137565
            },
            "targetCompletedDetails": {
                "targetGroupID": 46750,
                "targetGroupName": "TGName",
                "targetId": 76041,
                "targetName": "TName",
                "targetDescription": "TDescription",
                "targetPeriodID": 66277,
                "targetPeriodName": "Cycle_4",
                "targetValue": "1000.000",
                "achievedValue": "1200.000",
                "sourceId": 641554,
                "sourceType": "USERTARGET",
                "pointsEarned": {
                    "promo": [
                        {
                            "promotionId": 1133572888,
                            "promotionName": "Progname",
                            "programId": 1933,
                            "programName": "DefaultProgram",
                            "value": 100.0,
                            "expiresOn": "2026-11-30 23:59:59.0",
                        		"expiresOnISO": "2026-11-30T23:59:59+05:30",
                            "expiryType": "fixed"
                        }
                    ],
                    "promised": []
                }
            },
            "eventReferenceId": "263985",
            "uniqueId": "71730c8b628d0978e21e5e374f50fae606779fd412"
        },
        {
            "eventLogId": 30527931,
            "eventName": "TargetCompleted",
            "eventDetails": {
                "eventTime": "2024-10-25 22:59:12.0",
                "tillId": 50137565
            },
            "targetCompletedDetails": {
                "targetGroupID": 46750,
                "targetGroupName": "TGName1",
                "targetId": 76041,
                "targetName": "TName1",
                "targetDescription": "TDesc1",
                "targetPeriodID": 66277,
                "targetPeriodName": "Cycle_4",
                "triggerValue": "300.000",
                "sourceId": 78104,
                "sourceType": "MILESTONE",
                "pointsEarned": {
                    "promo": [
                        {
                            "promotionId": 1133572888,
                            "promotionName": "Promoname",
                            "programId": 1933,
                            "programName": "Progname",
                            "value": 100.0,
                            "expiresOn": "2025-10-31 23:59:59.0",
                            "expiryType": "fixed"
                        }
                    ],
                    "promised": []
                },
                "mileStoneName": "Sub target 1"
            },
            "eventReferenceId": "263986",
            "uniqueId": "88248bc99f945f1778f85af7c6ba69e4b90651c6"
        },
        {
            "eventLogId": 30527932,
            "eventName": "TargetCompleted",
            "eventDetails": {
                "eventTime": "2024-10-25 22:59:12.0",
                "tillId": 50137565
            },
            "targetCompletedDetails": {
                "targetGroupID": 46750,
                "targetGroupName": "TGName1",
                "targetId": 76041,
                "targetName": "TName1",
                "targetDescription": "TDesc1",
                "targetPeriodID": 66277,
                "targetPeriodName": "Cycle_4",
                "triggerValue": "600.000",
                "sourceId": 78104,
                "sourceType": "MILESTONE",
                "pointsEarned": {
                    "promo": [
                        {
                            "promotionId": 1133572888,
                            "promotionName": "Promoname",
                            "programId": 1933,
                            "programName": "Progname",
                            "value": 100.0,
                            "expiresOn": "2025-10-31 23:59:59.0",
                            "expiryType": "fixed"
                        }
                    ],
                    "promised": []
                },
                "mileStoneName": "Sub target 2"
            },
            "eventReferenceId": "263987",
            "uniqueId": "7470f2457563461f66bc1aasgf1760d8ga71ec3ee0174c267"
        }
    ],
    "warnings": []
}
{
    "events": [
        {
            "eventLogId": 652367550,
            "eventName": "PointsRedemption",
            "eventDetails": {
                "eventTime": "2025-12-03 05:13:39.0",
                "eventTimeISO": "2025-12-03T05:13:39Z",
                "tillId": 75155297,
                "redemptionDetails": {
                    "pointsRedeemed": "20.000",
                    "redemptionPurpose": "",
                    "transactionNumber": "test00transact96",
                    "billingTime": "2025-07-24 14:00:00.0",
                    "billingTimeISO": "2025-07-24T14:00:00Z",
                    "redemptionId": "evjan8",
                    "notes": "Redeemed to transfer points to the friend",
                    "groupRedemption": false
                }
            },
            "customFields": [],
            "pointsBreakup": [],
            "eventReferenceId": "566135941",
            "uniqueId": "QGcBZ8Nv3C"
        }
    ],
    "warnings": []
}
{
    "events": [
        {
            "eventLogId": 634510612,
            "eventName": "TransactionAdd",
            "eventDetails": {
                "eventTime": "2025-07-16 14:00:00.0",
                "eventTimeISO": "2025-07-16T14:00:00Z",
                "tillId": 75152721
            },
            "eventReferenceId": "888812880",
            "uniqueId": "yFNq8FgavV"
        }
    ],
    "warnings": []
}
{
    "events": [
        {
            "eventLogId": 44049002,
            "eventName": "GenericEvent",
            "eventDetails": {
                "eventDisplayName": "Walk5Kms",
                "tillId": 50789251,
                "displayName": "Walk5Kms"
            },
            "pointsEarned": {
                "regular": [],
                "promo": [
                    {
                        "promotionId": 1133595541,
                        "promotionName": "Walk5Kms",
                        "programId": 3500,
                        "programName": "DocDemoDefaultProgram",
                        "value": 100.0,
                        "expiresOn": "2026-11-30 23:59:59.0",
                        "expiresOnISO": "2026-11-30T23:59:59+05:30",
                        "promotionStartDate": "2025-11-01 00:00:00.0",
                        "promotionEndDate": "2026-02-25 23:59:59.0"
                    }
                ],
                "promised": []
            },
            "behavioralEventMetadata": {
                "label": "Walk5Kms",
                "fields": [
                    {
                        "fieldName": "mobile",
                        "fieldType": "customer",
                        "attributes": {
                            "accountId": {
                                "valueType": "ENUM"
                            },
                            "addCustomerIfNotExists": {
                                "valueType": "BOOLEAN",
                                "value": "true"
                            },
                            "identifierType": {
                                "valueType": "ENUM",
                                "value": "mobile"
                            },
                            "isRequired": {
                                "valueType": "BOOLEAN",
                                "value": "true"
                            },
                            "source": {
                                "valueType": "ENUM",
                                "value": "INSTORE"
                            }
                        }
                    },
                    {
                        "fieldName": "stepsWalked",
                        "fieldType": "double",
                        "attributes": {
                            "isPsiData": {
                                "valueType": "BOOLEAN",
                                "value": "false"
                            },
                            "isRequired": {
                                "valueType": "BOOLEAN",
                                "value": "true"
                            },
                            "isUniqueKeyField": {
                                "valueType": "BOOLEAN",
                                "value": "false"
                            }
                        }
                    }
                ]
            },
            "eventReferenceId": "fb98ae16-668d-4c48-826b-1c13fa5344e7",
            "uniqueId": "fb98ae16-668d-4c48-826b-1c13fa5344e7"
        }
    ],
    "warnings": [
        {
            "code": 9018,
            "message": "no alternate currency found for org with given input params",
            "status": false
        }
    ]
}
{
    "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": []
}
{
    "events": [
        {
            "eventLogId": 659919680,
            "eventName": "AllocateGoodwillPoints",
            "eventDetails": {
                "eventTime": "2026-02-10 20:25:58.0",
                "eventTimeISO": "2026-02-10T20:25:58Z",
                "reason": "GoodGuy",
                "comments": "Good behaviour",
                "assocId": 0,
                "requestId": 17729827
            },
            "pointsEarned": {
                "regular": [],
                "promo": [
                    {
                        "promotionId": 75984,
                        "promotionName": "Goodwill Promotion",
                        "programId": 973,
                        "programName": "DocDemoDefaultProgram",
                        "value": 100.0,
                        "expiresOn": "2126-02-10 23:59:59.0",
                        "expiresOnISO": "2126-02-10T23:59:59Z",
                        "expiryType": "fixed"
                    }
                ],
                "promised": []
            },
            "eventReferenceId": "-1",
            "uniqueId": "rN5DUi2osg"
        }
    ],
    "warnings": []
}
{
    "events": [
        {
            "eventLogId": 632749682,
            "eventName": "PointsRedemption",
            "eventDetails": {
                "eventTime": "2025-07-03 07:13:20.0",
                "tillId": 75152721,
                "redemptionDetails": {
                    "pointsRedeemed": "101.000",
                    "redemptionPurpose": "testUpdate",
                    "transactionNumber": "txn-79",
                    "redemptionId": "kh4Mh7",
                    "notes": "Redeemed to transfer points to the friend",
                    "groupRedemption": false
                }
            },
            "customFields": [
                {
                    "name": "card_number",
                    "value": "123456"
                }
            ],
            "pointsBreakup": [],
            "eventReferenceId": "564332013",
            "uniqueId": "nQmaNo4ay9"
        }
    ],
    "warnings": []
}
{
    "events": [
        {
            "eventLogId": 24732968,
            "eventName": "TransactionAdd",
            "eventDetails": {
                "eventTime": "2024-03-26 10:38:00.0",
                "eventTimeISO": "2024-03-26T10:38:00+05:30",
                "tillId": 50671937
            },
            "billDetails": {
                "type": "loyalty",
                "billNumber": "num124536",
                "grossAmount": 30.0,
                "discount": 5.0,
                "billAmount": 200.0,
                "note": "this is test1",
                "source": "instore",
                "billDate": "2024-03-26 10:38:00.0",
                "billDateISO": "2024-03-26T10:38:00+05:30",
                "pointsEarned": {
                    "regular": [
                        {
                            "value": 0.0,
                            "expiresOn": "2025-03-31 23:59:59.0",
                            "expiresOnISO": "2025-03-31T23:59:59+05:30",
                            "programId": 2649,
                            "programName": "VidhiJainOrgDefaultProgram",
                            "expiryType": "fixed"
                        }
                    ],
                    "promo": [],
                    "promised": []
                },
                "pointsEarnedBreakup": {
                    "regular": [
                        {
                            "value": 0.0,
                            "expiresOn": "2025-03-31 23:59:59.0",
                            "expiresOnISO": "2025-03-31T23:59:59+05:30",
                            "awardedOn": "2024-03-26 10:38:00.0",
                            "awardedOnISO": "2024-03-26T10:38:00+05:30",
                            "sourceValue": 0.0,
                            "programId": 2649,
                            "programName": "VidhiJainOrgDefaultProgram",
                            "allocationStrategyId": 111526,
                            "allocationStrategyName": "10x fixed",
                            "pointsCategoryId": 18871,
                            "pointsCategoryName": "Main",
                            "expiryStrategyId": 109281,
                            "expiryStrategyName": "NUM_MONTHS_END12",
                            "expiryType": "fixed"
                        }
                    ],
                    "promised": []
                },
                "alternateCurrencyValueEarned": [
                    {
                        "regular": [
                            {
                                "value": 150.0,
                                "expiresOn": "2025-03-31 23:59:59.0",
                                "expiresOnISO": "2025-03-31T23:59:59+05:30",
                                "programId": 2649,
                                "programName": "VidhiJainOrgDefaultProgram",
                                "expiryType": "fixed"
                            }
                        ],
                        "promo": [],
                        "promised": [],
                        "alternateCurrencyName": "acName",
                        "alternateCurrencyIdentifier": "P7d8Br"
                    }
                ],
                "alternateCurrencyValueEarnedBreakup": [
                    {
                        "regular": [
                            {
                                "value": 0.0,
                                "expiresOn": "2025-03-31 23:59:59.0",
                                "expiresOnISO": "2025-03-31T23:59:59+05:30",
                                "awardedOn": "2024-03-26 10:38:00.0",
                                "awardedOnISO": "2024-03-26T10:38:00+05:30",
                                "sourceValue": 0.0,
                                "programId": 2649,
                                "programName": "VidhiJainOrgDefaultProgram",
                                "allocationStrategyId": 111529,
                                "allocationStrategyName": "alllocate 150",
                                "pointsCategoryId": 20151,
                                "pointsCategoryName": "acName_PointCategory",
                                "expiryStrategyId": 109281,
                                "expiryStrategyName": "NUM_MONTHS_END12",
                                "expiryType": "fixed"
                            }
                        ],
                        "promised": [],
                        "alternateCurrencyName": "acName",
                        "alternateCurrencyIdentifier": "P7d8Br"
                    }
                ],
                "lineItems": [
                    {
                        "id": 2158986015,
                        "itemCode": "sku_164716451_2",
                        "source": "instore",
                        "grossAmount": 0.0,
                        "discount": 0.0,
                        "amount": 300.0,
                        "rate": 10.5,
                        "qty": 3.0
                    },
                    {
                        "id": 2158986016,
                        "itemCode": "sku_164716451_3",
                        "source": "instore",
                        "grossAmount": 0.0,
                        "discount": 0.0,
                        "amount": 300.0,
                        "rate": 10.5,
                        "qty": 3.0
                    },
                    {
                        "id": 2158986017,
                        "itemCode": "sku_164716451_4",
                        "source": "instore",
                        "grossAmount": 0.0,
                        "discount": 0.0,
                        "amount": 300.0,
                        "rate": 10.5,
                        "qty": 3.0
                    }
                ]
            },
            "customFields": [],
            "extendedFields": [],
            "paymentModes": [],
            "pointInTimeSlabs": [
                {
                    "pointInTimeSlabNumber": 2,
                    "pointInTimeSlabName": "SILVER",
                    "programId": 2649,
                    "isDefaultProgram": true
                }
            ],
            "eventReferenceId": "2151534230",
            "uniqueId": "sC1RXvEHWU"
        }
    ],
    "warnings": [
        {
            "code": 9018,
            "message": "alternate currency with given name not found for org, name: dummy",
            "status": false
        }
    ]
}

Response Parameters

Parameter NameTypeDescription
eventLogIdIntegerA unique identifier for the event.
eventNameStringName of the event. NewBill, TransactionAdd, GroupTransactionAdd, LineItemsPointsPromotionImport, BillPointsPromotionImport, CustomerPromotionImport, GenericEvent, CustomerRegistration, CustomerUpdate, AllocateGoodwillPoints, PointsTransfer, PointsRedemption, ReturnBill, TargetCompleted, ManualPointsAdjustment, VoucherRedemption`
eventDetailsObjectContains details about the event.
-eventTimeStringIndicates the event-triggered date in YYYY-MM-DD HH:MM:SS.s format. Note: This field will be deprecated in the future and is being replaced by eventTimeISO.
-eventTimeISOString

Indicates the event-triggered date and time in ISO 8601 format, returned in the server timezone.

EU server example:
2025-12-16T14:30:45Z → 16 December 2025, 14:30:45 (UTC).

India server example:
2025-12-16T14:30:45+05:30 → 16 December 2025, 14:30:45 (IST).

Note: The response timezone always matches the server timezone, regardless of the timezone offset in the request.

-eventDisplayNameStringDisplay name of the event, e.g., "CupSeries2024".
-tillIdIntegerID of the till where the event was recorded.
-commentsStringAdditional comments provided while issuing goodwill points.
-assocIdlongUser ID of the Intouch user who issued the Goodwill points.
-displayNameStringName to display for the event, e.g., "CUP SERIES CHECK-IN".
-redemptionDetailsArrayIncludes the details related to the redemption of points.
--pointsRedeemedStringThe number of points that were redeemed in the transaction.
--redemptionPurposeStringPurpose of points redemption.
--transactionNumberStringThe transaction/bill number associated with the points redemption.
--redemptionIdStringA unique identifier for the redemption transaction.
targetCompletedDetailsArrayObject containing details of a completed target.
-targetGroupIDStringThe unique group ID of the target.
-targetGroupNameStringThe unique name of the target group.
-targetIdIntegerThe unique ID of the target.
-targetNameStringThe unique name of the target.
-targetDescriptionStringDescription of the target (if added).
-targetPeriodIDIntegerThe unique ID of the target period.
-targetPeriodNameStringThe unique name of the target period.
-sourceIdIntegerThe unique ID of the target source.
-sourceTypeStringThe type of source (MILESTONE, STREAKS, UNIFIED).
pointsEarnedObjectContains details of points earned in the event.
-regularArrayArray of regular points earned (empty in this case).
-promoArrayArray of promotional points earned during the event.
--promotionIdIntegerThe ID of the promotion, e.g., 8166.
--promotionNameStringThe name of the promotion, e.g., SummerPromo2025.
--programIdIntegerThe ID of the loyalty program associated with the promotion, e.g., 1155.
--programNameStringThe name of the loyalty program, e.g., "NASCAR LoyaltyDefaultProgram".
--valueFloatThe value of the points earned from the promotion, e.g., 200.0.
--expiresOnStringIndicates the promotion expiry date and time. Note: This field will be deprecated in the future and is being replaced by expiresOnISO.
--expiresOnISOString

Indicates the promotion expiry date and time in ISO 8601 format, returned in the server timezone.

EU server example:
2025-12-16T14:30:45Z → 16 December 2025, 14:30:45 (UTC).

India server example:
2025-12-16T14:30:45+05:30 → 16 December 2025, 14:30:45 (IST).

Note: The response timezone always matches the server timezone, regardless of the timezone offset in the request.

--promotionStartDateStringThe start date of the promotion, e.g., "2024-02-04 00:00:00.0".
--promotionEndDateStringThe end date of the promotion, e.g., "2024-03-05 23:59:59.0".
-promisedArrayArray of promised points (empty in this case).
behavioralEventMetadataObjectMetadata about the behavioral event associated with the check-in.
-labelStringThe label for the behavioral event, e.g., "CUP SERIES CHECK-IN".
-fieldsArrayAn array of fields related to the event's metadata.
--fieldNameStringThe name of the field, e.g., "activity_date".
--fieldTypeStringThe type of the field, e.g., "DATE".
--attributes.isRequired.valueTypeStringThe type of value for the isRequired attribute for the event, e.g., "BOOLEAN". This is configured during the creation of the event.
--attributes.isRequired.valueStringThe value indicating if the field is required, e.g., "false".
--isUniqueKeyField.valueTypeStringThe type of value for the isUniqueKeyField attribute, e.g., "BOOLEAN". This is configured during the creation of the event.
--isUniqueKeyField.valueStringThe value indicating if the field is a unique key, e.g., "false".
eventReferenceIdStringThe event request ID. This is generated when the event is sent. This helps to trace the event. For TargetCompleted events, this ID (targetAchievedEventLogId) is generated when a user has achieved a target.
uniqueIdStringA unique identifier for this specific event instance, e.g., "70375599-a144-4065-8db5-a6abd061ddf7". This can be the same as requestId or a hash of the payload when the isUniqueKeyField is enabled.
billDetailsObjectObject containing details on the following information: type (type of transaction), bill number (unique transaction number), gross amount, discount, bill amount, note, source, bill date (time in ISO 8601 format), and points earned details.
-billNumberStringUnique identifier for the transaction. This is defined when adding the original transaction.
-billAmountFloatTotal transaction amount for the transaction.
-noteStringNote for the transaction.
-returnDateStringDate when the transaction was returned in in ISO 8601 YYYY-MM-DDTHH:mm:ss.SSS format. Note: This field will be deprecated in the future and is being replaced by returnDateISO.
-returnDateISOString

Indicates the returned transaction date and time in ISO 8601 format, returned in the server timezone.

EU server example:
2025-12-16T14:30:45Z → 16 December 2025, 14:30:45 (UTC).

India server example:
2025-12-16T14:30:45+05:30 → 16 December 2025, 14:30:45 (IST).

Note: The response timezone always matches the server timezone, regardless of the timezone offset in the request.

-returnAmountFloatTotal amount for the return transaction.
-billDateStringDate when the transaction was created in ISO 8601 YYYY-MM-DDTHH:mm:ss.SSS format. Note: This field will be deprecated in the future and is being replaced by billDateISO.
-billDateISOString

Indicates the transaction created date and time in ISO 8601 format, returned in the server timezone.

EU server example:
2025-12-16T14:30:45Z → 16 December 2025, 14:30:45 (UTC).

India server example:
2025-12-16T14:30:45+05:30 → 16 December 2025, 14:30:45 (IST).

Note: The response timezone always matches the server timezone, regardless of the timezone offset in the request.

-returnTypeEnumType of return. Possible values: AMOUNT, FULL, LINE_ITEM, CANCELLED.
-returnBillIdlongUnique ID for the return transaction that is generated after a return transaction. This is the entityId of the return transaction.
-pointsEarnedObjectObject containing details on the points earned for the transaction.
-lineItemsObjectObject containing details on line items in the bill.
customFieldsObjectObject containing details on custom fields for the transaction.
-nameStringUnique name of the custom field.
-valueAnyValue for the corresponding custom field name. The data type for the value is based on what is configured for the custom field.
pointsEarnedBreakupObjectObject containing points earned details with break up.
awardedOnStringIndicates the points awarded date in YYYY-MM-DD HH:MM:SS.s format. Note: This field will be deprecated in the future and is being replaced by awardedOnISO.
awardedOnISOString

Indicates the points awarded date and time in ISO 8601 format, returned in the server timezone.

EU server example:
2025-12-16T14:30:45Z → 16 December 2025, 14:30:45 (UTC).

India server example:
2025-12-16T14:30:45+05:30 → 16 December 2025, 14:30:45 (IST).

Note: The response timezone always matches the server timezone, regardless of the timezone offset in the request.

Note: The timezone offset returned by awardedOnISO reflects the data as stored and may not match the server timezone in all cases.

expiresOnStringIndicates the points expiry date in YYYY-MM-DD HH:MM:SS.s format. Note: This field will be deprecated in the future and is being replaced by expiresOnISO.
expiresOnISOString

Indicates the points expiry date and time in ISO 8601 format, returned in the server timezone.

EU server example:
2025-12-16T14:30:45Z → 16 December 2025, 14:30:45 (UTC).

India server example:
2025-12-16T14:30:45+05:30 → 16 December 2025, 14:30:45 (IST).

Note: The response timezone always matches the server timezone, regardless of the timezone offset in the request.

warningsArrayWarnings, if any.

Response parameters: Filtered byManualPointsAdjustment event ID

{
    "events": [
        {
            "eventLogId": 656317605,
            "eventName": "ManualPointsAdjustment",
            "eventDetails": {
                "eventTime": "2026-01-07 05:43:40.0",
                "eventTimeISO": "2026-01-07T05:43:40Z",
                "tillId": 75152721
            },
            "eventReferenceId": "-1",
            "uniqueId": "J52P7ttKJL",
            "manualPointsAdjustmentDetails": {
                "orgId": 100737,
                "customerId": 566135941,
                "totalPointsDeducted": "100.000",
                "createdOn": "2026-01-07 05:43:40",
                "createdOnISO": "2026-01-07T05:43:40Z",
                "reason": "testing",
                "pointsDeductionBreakUpDetails": [
                    {
                        "customerId": 566135941,
                        "loyaltyId": 566135941,
                        "programId": 973,
                        "programName": "DocDemoDefaultProgram",
                        "promotionId": 75984,
                        "promotionName": "Goodwill Promotion",
                        "pointAwardedRefType": "POINT_AWARDED_CUSTOMER_PROMOTION",
                        "pointAwardedRefId": 738338727,
                        "deductionType": "MANUAL_ADJUSTMENT",
                        "pointsDeducted": 100.0,
                        "pointsDeductedStr": "100.000",
                        "pointsDeductedCurrencyValue": 100.0,
                        "pointsDeductedCurrencyValueStr": "100.000",
                        "pointsDeductedOn": "2026-01-07 05:43:40.0",
                        "pointsDeductedOnISO": "2026-01-07T05:43:40Z",
                        "pointsDeductedBy": "naman",
                        "pointsDeductedById": 75152721,
                        "sourceType": "Bill",
                        "awardedTillId": 75197941,
                        "awardedTillDate": "2025-12-03 12:16:59.0"
                    }
                ]
            }
        }
    ],
    "warnings": []
}
Parameter nameTypeDescription
pointsDeductionBreakUpDetailsList PointsDeductionBreakUpDetailList containing detailed breakup of loyalty points deductions for a customer.
customerIdintUnique identifier of the customer whose points were deducted.
loyaltyIdLongLoyalty ID associated with the customer.
programIdIntegerUnique identifier of the loyalty program.
programNameStringName of the loyalty program under which the points were deducted.
promotionIdLongUnique identifier of the promotion linked to the points deduction.
promotionNameStringName of the promotion associated with the deduction.
pointAwardedRefTypeStringReference type indicating how the original points were awarded.
pointAwardedRefIdLongReference ID of the original points award transaction.
deductionTypeStringType of points deduction (e.g., manual adjustment).
pointsDeductedBigDecimalNumber of loyalty points deducted.
pointsDeductedStrStringPoints deducted represented as a formatted string.
pointsDeductedCurrencyValueBigDecimalCurrency value equivalent of the deducted points.
pointsDeductedCurrencyValueStrStringCurrency value of the deducted points as a formatted string.
pointsDeductedOnStringIndicates the points deducte date in yyyy-MM-dd HH:mm:ss.S
format. Note: This field will be deprecated in the future and is being replaced by pointsDeductedOnISO.
pointsDeductedOnISODate

Indicates the date and time of the points deducted in ISO 8601 format, returned in the server timezone.

EU server example:
2025-12-16T14:30:45Z → 16 December 2025, 14:30:45 (UTC).

India server example:
2025-12-16T14:30:45+05:30 → 16 December 2025, 14:30:45 (IST).

Note: The response timezone always matches the server timezone, regardless of the timezone offset in the request.

pointsDeductedByStringUsername of the user who performed the points deduction.
pointsDeductedByIdLongUnique identifier of the user who performed the deduction.
sourceTypeStringSource that triggered the points deduction (e.g., Bill).
awardedTillIdIntegerIdentifier of the till where the original points were awarded.
awardedTillDateStringDate and time when the original points were awarded. Note: This field will be deprecated in the future and is being replaced by awardedTillDateISO.
awardedTillDateISODate

Indicates the date and time of when the original points were awarded in ISO 8601 format, returned in the server timezone.

EU server example:
2025-12-16T14:30:45Z → 16 December 2025, 14:30:45 (UTC).

India server example:
2025-12-16T14:30:45+05:30 → 16 December 2025, 14:30:45 (IST).

Note: The response timezone always matches the server timezone, regardless of the timezone offset in the request.

Error codes

HTTP CodeDescription
9022Event reference IDs are invalid.
11014Event name not found. Provide a valid event name.
11023Invalid identifiers found. Either EventLogId or (EventName and BillId) are required.
11012Invalid userId field value.
11013IdentifierName and identifierValue, source can not be empty.
8013Invalid identifiername field value.
9003Error fetching points ledger data when type is invalid. Provide a valid type.
1632group id/externalId/primary userId passed is invalid.
9021Invalid identifiers found when invalid eventid is passed. Provide a valid eventId.
11017Event id format exception. The provided value is not a valid numeric eventIds . Provide a valid numeric eventIds.
9005Invalid alternateCurrencyNames field value. Provide a valid alternateCurrencyNames.
9018Alternate currencies not found with provided category filters. Provide a valid alternate currency name.
11021EventId and Event References, both cannot be passed. Provide either eventId or eventName and eventReferenceIds.
11019Source value capturing status is disabled. To enable it raise a Jira ticket to the Capillary Product Support team.
Query Params
string
required
string
required
string
required
integer
required
string
boolean
boolean
boolean
boolean
boolean
string
string
boolean
boolean
string
string
int32
Headers
string
enum
Defaults to application/json
Allowed:
Response

Language
Credentials
Basic
base64
:
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json
text/plain