Get Allocated Points Details with Expiry in Specified Date Range

The API retrieves information about points allocated to customers that are set to expire within a specified date range.

🚧

Note

This API is a private API that has been exposed through Neo and made public.

Prerequisites

  • Access to Neo
  • Basic or OAuth authentication details
  • Access group resource - NA
  • Header x-cap-neo-dag-scope set to a valid scope value (e.g. global)

Resource information

URI/x/neo/pointsAllocation/dateRange
HTTP methodGET
Pagination supported?Yes
Rate limitBased on Neo
Batch supportNA

API endpoint example

<https://nightly.api.capillarytech.com/x/neo/pointsAllocation/dateRange?expiry_date_start=2025-06-01&expiry_date_end=2027-06-01&point_category_id=17383&program_id=2282&entity_id=383474113>

Request query parameters

Parameter(Parameters marked with * are mandatory) Data Type Description

program_id*

Integer

Unique identifier of the loyalty program.

point_category_id*

Integer

Unique identifier for a Point Category in the loyalty points system.

expiry_date_start*

Date

Start date of the expiry range.
Format: YYYY-MM-DD.
Example: 2025-06-01

expiry_date_end*

Date

End date of the expiry range.
Format: YYYY-MM-DD.
Example: 2025-06-30

entity_id*

Long

Customer ID of the customer for whom the points allocation ID is retrieved.

page

Integer

Retrieve details of a specific page. Page count starts from 1.
Example: page=2 retrieves data on page 2.

count

Integer

Number of results to display per page. The default value is 10. The maximum supported value is 100.

Sample request

curl --location 'https://nightly.api.capillarytech.com/x/neo/pointsAllocation/dateRange?expiry_date_start=2025-06-01&expiry_date_end=2027-06-01&point_category_id=17383&program_id=2282&entity_id=383474113' \
--header 'Content-Type: application/json' \
--header 'x-cap-neo-dag-scope: global' \
--header 'Authorization: Basic OTA3NWI5NjRiMDcxNTJkMjM0Yjcw' \
--header 'Cookie: _cfuvid=GGHmRJB3vR2afrZYKGGEonxyUpRW_cRsEMKHeQJEB9U-1749653959367-0.0.1.1-604800000; _cfuvid=3jRFTwrAkfN7jtZ9QZJxunCfld0NnS2Yp5yjoouddLA-1749725683120-0.0.1.1-604800000'

Response parameters

ParameterData TypeDescription
till_idIntegerIdentifier of the store/till where the transaction occurred
point_category_idIntegerID of the category under which the points fall
program_idIntegerID of the loyalty program
event_log_idIntegerID of the event log that recorded the transaction
event_type_idIntegerID indicating the type of event
points_source_type_idIntegerID of the source type from which points were earned
original_pointsIntegerNumber of points initially awarded
awarded_dateLongTimestamp when the points were awarded (in milliseconds)
returned_exclusive_valueIntegerExclusive value of points returned
points_source_idIntegerID of the source entity awarding the points
idIntegerUnique ID of the point allocation entry
cps_idIntegerID of the customer program state
original_customer_idIntegerID of the customer before merge or update
expiry_strategy_idIntegerID of the strategy used to determine point expiry
returned_valueIntegerTotal value of returned points
redeemed_exclusive_valueIntegerExclusive value of redeemed points
expiry_dateLongExpiry timestamp of the awarded points (in milliseconds)
auto_update_timeLongTimestamp of the last auto-update to the entry
redeemed_valueIntegerValue of points redeemed
expired_exclusive_valueIntegerExclusive value of points that expired
allocation_strategy_idIntegerID of the strategy used to allocate points
points_valueIntegerTotal value of the points awarded
org_idIntegerOrganization ID
expired_valueIntegerValue of points that expired
customer_idIntegerID of the customer to whom the points are allocated
points_exclusiveIntegerExclusive points that are available
statusStringCurrent status of the point entry

Sample response

[
    {
        "till_id": 50140377,
        "point_category_id": 17383,
        "program_id": 2282,
        "event_log_id": 33822621,
        "event_type_id": 15,
        "points_source_type_id": 1,
        "original_points": 0,
        "awarded_date": 1735309787000,
        "returned_exclusive_value": 50,
        "points_source_id": 2151585684,
        "id": 38855229,
        "cps_id": 80537188,
        "original_customer_id": 383474113,
        "expiry_strategy_id": 105462,
        "returned_value": 0,
        "redeemed_exclusive_value": 0,
        "expiry_date": 1766687399000,
        "auto_update_time": 1735309788000,
        "redeemed_value": 0,
        "expired_exclusive_value": 0,
        "allocation_strategy_id": 105594,
        "points_value": 0,
        "org_id": 50914,
        "expired_value": 0,
        "customer_id": 383474113,
        "points_exclusive": 100,
        "status": "AVAILABLE"
    }
]

Error Codes

Error CodeDescription
400Bad Request
404Not Found
500Internal Server Error
Language
Credentials
Basic
base64
:
URL
Click Try It! to start a request and see the response here!