Get Allocated Points Details with Expiry in Specified Date Range

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

🚧
Note
This is a private API and is accessible only through Neo dataflows.

Prerequisites

Access to Neo
Basic or OAuth authentication details
Access group resource - NA

Resource information


URI to be used in Neo dataflow	/das/getPAIdsForProvidedDateRange
HTTP method	GET
Pagination supported?	Yes
Rate limit	Based on Neo
Batch support	NA

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-22
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.

Response parameters

Parameter	Data Type	Description
till_id	Long	Identifier of the store/till where the transaction occurred
point_category_id	Long	ID of the category under which the points fall
program_id	Long	ID of the loyalty program
event_log_id	Long	ID of the event log that recorded the transaction
event_type_id	Integer	ID indicating the type of event
points_source_type_id	Integer	ID of the source type from which points were earned
original_points	Integer	Number of points initially awarded
awarded_date	Long	Timestamp when the points were awarded in milliseconds
returned_exclusive_value	Integer	Exclusive value of points returned
points_source_id	Long	ID of the source entity awarding the points
id	Long	Unique ID of the point allocation entry
cps_id	Long	ID of the customer program state
original_customer_id	Long	ID of the customer before merge or update
expiry_strategy_id	Long	ID of the strategy used to determine point expiry
returned_value	Integer	Total value of returned points
redeemed_exclusive_value	Integer	Exclusive value of redeemed points
expiry_date	Long	Expiry timestamp of the awarded points in milliseconds
auto_update_time	Long	Timestamp of the last auto-update to the entry
redeemed_value	Integer	Value of points redeemed
expired_exclusive_value	Integer	Exclusive value of points that expired
allocation_strategy_id	Long	ID of the strategy used to allocate points
points_value	Integer	Total value of the points awarded
org_id	Long	Organization ID
expired_value	Integer	Value of points that expired
customer_id	Long	ID of the customer to whom the points are allocated
points_exclusive	Integer	Exclusive points that are available
status	String	Current 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 code

Error Code	Description
400	Bad Request
404	Not Found
500	Internal Server Error