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 methodGET
Pagination supported?Yes
Rate limitBased on Neo
Batch supportNA

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

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
[
    {
        "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 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!