Get Customer Redemptions

This API allows you to retrieve points and coupons redemption history of a customer. You can filter the results by type, duration, coupon ids start with, and coupon ids end with. Besides filters you can also sort the results by ascending or descending order by redemption id/time and limit number of results to retrieve.

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

Example request

curl --location 'https://eu.api.capillarytech.com/v1.1/customer/redemptions?mobile=7744876415' \
--header 'Authorization: Basic =' \
--header 'Cookie: _cfuvid=a0NmZQvi.30LKK7NvCQJgMpK8Ig15sul9um2ZFRucDk-1757422794990-0.0.1.1-604800000'
curl --location 'https://eu.api.capillarytech.com/v1.1/customer/redemptions?mobile=1234512345&points_limit=1' \
--header 'Authorization: Basic Z2VvcmdRlbW86NjVhMDgzYjk1MWY5MGY1NTY5NDk1YmNkNzUxYmJiY2U=' \
--header 'Cookie: _cfuvid=a0NmZQvi.30LCQJgMpK8Ig15sul9um2ZFRucDk-1757422794990-0.0.1.1-604800000; _cfuvid=G34mU5xo45KXhscLi1wLSxlx.ZVXnKiUNc_XzQMNPBg-1765781430679-0.0.1.1-604800000'
curl --location 'https://eu.api.capillarytech.com/v1.1/customer/redemptions?mobile=1234512345&points_offset=10' \
--header 'Authorization: Basic Z2VvcmdlLmRvY2RlbW86NjVhMDgzYjk1MWYNTY5NDk1YmNkNzUxYmJiY2U=' \
--header 'Cookie: _cfuvid=a0NmZQvi.30LKK7NvCQJgMpK8m2ZFRucDk-1757422794990-0.0.1.1-604800000; _cfuvid=5yvhhI4kBWT.hvwsNG.I9UYaK_KkaA6C32ngT3G5Gvk-1765781837648-0.0.1.1-604800000'
curl --location 'https://eu.api.capillarytech.com/v1.1/customer/redemptions?mobile=918442838241&includePointsSourceBreakdown=true&type=points&points_limit=10' \
--header 'Authorization: Basic Z2VvcmdlLmRvY2RlbW86NjVhMDgzYjk1MWY5MGY1NTY5NDk1YmNkNzUxYmJiY2U='

Example response

{
    "response": {
        "status": {
            "success":true,
            "code":200,
            "message":"Success"
        },
        "customer": {
            "mobile": "917744876415",
            "email": "[email protected]",
            "external_id": null,
            "firstname": "tester",
            "lastname": "capillary",
            "user_groups2":[
],
            "rows": 4,
            "coupons_count": "3",
            "points_count": 1,
            "coupons_start_id": "16793490",
            "points_start_id": 1,
            "redemptions": {
                "coupons": {
                    "coupon": [
                         {
                             "id":"16793490",
                             "code": "RT2EJTAE",
                            "series_id":"689078",
                            "description":"LIKE1w2w2345678910",
                            "discount_code":"XYZ1w23",
                            "discount_type":"ABS",
                            "discount_value":"500",
                            "transaction_number":"bill-110",
                            "bill_id":"0",
                            "redeemed_time":"2025-02-24 13:01:40",
                            "redeemed_at":"satish.maharana",
                            "redeemed_store":
                            {
                                "name":"DocStore",
                                "code":"doc123"
                            },
                            "redeemed_till":{
                                "name":"satish.maharana",
                                "code":"satish.maharana"
                            },
                            "custom_fields": {
                                "field": [

                                ]
                            }
                                 },
                                                          {
                             "id":"16793484",
                             "code": "LU251JB2",
                            "series_id":"689078",
                            "description":"LIKE1w2w2345678910",
                            "discount_code":"XYZ1w23",
                            "discount_type":"ABS",
                            "discount_value":"500",
                            "transaction_number":"bill-110",
                            "bill_id":"0",
                            "redeemed_time":"2025-02-24 13:01:13",
                            "redeemed_at":"satish.maharana",
                            "redeemed_store":
                            {
                                "name":"DocStore",
                                "code":"doc123"
                            },
                            "redeemed_till":{
                                "name":"satish.maharana",
                                "code":"satish.maharana"
                            },
                            "custom_fields": {
                                "field": [

                                ]
                            }
                                 },
                                                          {
                             "id":"16787110",
                             "code": "K6OXLR0Q",
                            "series_id":"689078",
                            "description":"LIKE1w2w2345678910",
                            "discount_code":"XYZ1w23",
                            "discount_type":"ABS",
                            "discount_value":"500",
                            "transaction_number":"bill-110",
                            "bill_id":"0",
                            "redeemed_time":"2025-02-23 22:33:01",
                            "redeemed_at":"satish.maharana",
                            "redeemed_store":
                            {
                                "name":"DocStore",
                                "code":"doc123"
                            },
                            "redeemed_till":{
                                "name":"satish.maharana",
                                "code":"satish.maharana"
                            },
                            "custom_fields": {
                                "field": [

                                ]
                            }
                                 }
                                 ]
                },
                "points": {
                    "point": [
                        {
                           "id" :1,
                           "program_id":973,
                           "points_redeemed":100,
                           "transaction_number":"",
                           "bill_id":"-1",
                           "validation_code":"",
                           "redeemed_time":"2025-03-10 14:37:11",
                           "redeemed_at":"sant.p_123",
                           "redemption_purpose":"",
                           "notes":"Redeemed to transfer points to the friend",
                           "external_reference_number":"",
                           "redemption_id":"AfL1vt",
                           "redeemed_store":{
                               "code":"doc123",
                               "name":"DocStore"
                           },
                           "redeemed_till":{
                               "code":"sant.p_123",
                               "name":"sant.p_123"
                           },
                            "custom_fields": {
                                  "field": [

                                  ]
                            },
                               "reversals":
                               [
                                ],
                          "redemption_breakup_by_program":
                                    [
                                    ]
                        }
                         ]
                        
                    }
                }
            }
        }
}
{
    "response": {
        "status": {
            "success": true,
            "code": 200,
            "message": "Success"
        },
        "customer": {
            "mobile": "918442838241",
            "email": "[email protected]",
            "external_id": null,
            "firstname": "John",
            "lastname": "Doe",
            "user_groups2": [],
            "rows": 1,
            "points_count": 1,
            "points_start_id": 1,
            "redemptions": {
                "points": {
                    "point": [
                        {
                            "id": 1,
                            "program_id": 1886,
                            "points_redeemed": 8,
                            "transaction_number": "bill-123",
                            "bill_id": "-1",
                            "validation_code": "",
                            "redeemed_time": "2025-12-10 15:30:00",
                            "redeemed_at": "store_till",
                            "redemption_purpose": "Purchase discount",
                            "notes": "Redeemed at checkout",
                            "external_reference_number": "",
                            "redemption_id": "XyZ123",
                            "redeemed_store": {
                                "code": "store123",
                                "name": "Main Store"
                            },
                            "redeemed_till": {
                                "code": "till_01",
                                "name": "Till 01"
                            },
                            "custom_fields": {
                                "field": []
                            },
                            "reversals": [],
                            "redemption_breakup_by_program": [
                                {
                                    "program_id": 1886,
                                    "points_redeemed": 8,
                                    "program_name": "DefaultProgram"
                                }
                            ],
                            "redemption_breakup_by_source": [
                                {
                                    "source_store": {
                                        "code": "northstore",
                                        "name": "NorthStore"
                                    },
                                    "points_consumed": 6,
                                    "awarding_date": "2025-10-18 21:58:10"
                                },
                                {
                                    "source_store": {
                                        "code": "northstore",
                                        "name": "NorthStore"
                                    },
                                    "points_consumed": 2,
                                    "awarding_date": "2025-10-18 21:58:07"
                                }
                            ]
                        }
                    ]
                }
            }
        }
    }
}

Request query parameters

ParameterData TypeRequiredDescription
identifierNamestring (enum)MandatoryIdentifier of the customer to use. Allowed: mobile, email, external_id, id.
identifierValuestringMandatoryValue of the specified identifier type. To retrieve transactions of multiple customers, provide each identifier separated by commas.Example: mobile=44700900000,44700900999,4470090345
typestring (enum)OptionalType of redemption. Allowed: POINTS, COUPONS, BOTH.
start_datedateOptionalRetrieves redemptions made on or after a specific date (YYYY-MM-DD). Use with end_date for a date range.
end_datedateOptionalRetrieves redemptions made on or before a specific date (YYYY-MM-DD). Use with start_date for a date range.Example: start_date=2013-12-21+23:45:45&end_date=2013-12-29+12:11:45
entity_codestringOptionalCode of the specified entity_type. Example: to get transactions of a zone with code zone01, pass entity_type=zone&entity_code=zone01.
coupons_limitint32OptionalLimit the number of coupon redemptions displayed. Use only when type is not passed.Example: coupons_limit=10
points_limitint32OptionalSpecifies the maximum number of point redemption records to return.
  • This parameter is applicable only when the type parameter is not provided.
  • The maximum supported value is 500.
    If a value greater than 500 is provided, the system automatically resets the limit to 500.
    Example: points_limit=10
    Default value: 10
limitint32OptionalLimit the number of redemption details (points and/or coupons). Default is 10. Use only when type is not passed.
coupons_start_idint64OptionalFilter results by coupon redemption ID starting with a specific number. Use only when type is not passed.
coupons_end_idint64OptionalFilter results by coupon redemption ID ending with a specific number. Use only when type is not passed.
points_start_idint64OptionalFilter results by points redemption ID starting with a specific number. Use only when type is not passed.
points_end_idint64OptionalFilter results by points redemption ID ending with a specific number. Use only when type is not passed.
sortstring (enum)OptionalSort results by redemption ID or redeemed time. Defaults to descending order of redeemed time.
Supported parameters: false, redemption_id, redeemed_time.
orderstring (enum)OptionalDefines sort order. Defaults to desc.
Supported parameters: asc, desc.
mlpbooleanOptionalPass true to get redemptions from all programs of the org; false for only the default program. Defaults to false.
formatstring (enum)OptionalFormat of the response. Allowed: xml, json.
user_idbooleanOptionalPass true to include customer ID in response. Defaults to not retrieved.
merchant_store_idint64OptionalMerchant store ID to fetch redemptions from a specific store.
program_idint32OptionalProgram ID to filter redemptions of a particular program.
external_reference_numberstringOptionalUnique reference number provided when making the points redemption request.
points_offsetintegerOptionalSpecifies the starting page for the records to be fetched. Default: 0
includePointsEarnBreakdownbooleanOptional

When set to true, includes source-level breakdown for each points redemption, showing which stores/tills originally awarded the redeemed points. This provides transparency into where points were earned before being redeemed.

Default: false

Note: This parameter only applies to points redemptions. It has no effect on coupon redemptions.

Response Parameters

ParameterDatatypeDescription
coupons_countintNumber of coupon redemptions retrieved.
points_countintNumber of points redemptions received.
couponsobjDetails of coupon redemptions.
pointsobjDetails of points redemption.
codestringUnique code of the coupon.
series_idlongCoupon series ID associated to the coupon.
descriptionstringDescription of the coupon.
discount_codestringCoupon code used to avail discount.
discount_typeenumType of discount. PERC for discount in percentage, FLAT for flat amount discount.
idlongRedemption ID of that points or coupon.
transaction_numberstringTransaction number associated to the points or coupon redemption.
bill_idlongA numerical identifier for the bill.
redeemed_timedate-timeDate and time of points or coupon redemption.
redeemed_atstringStore or TILL code associated to points or coupon redemption.
program_idlongUnique ID of the loyalty program in which points is redeemed.
points_redeemedintNumber of points redeemed.
transaction_numberstringTransaction number associated to the points or coupon redemption.
redeemed_timedate-timeDate and time of points or coupon redemption.
redeemed_atstringStore or TILL code associated to points or coupon redemption.
redemption_breakup_by_programobjBreakup of points redeemed with respect to the program.
reversalsobjDetails of points reversed if the transaction for which points are redeemed is returned.
reversal_idlongUnique ID generated for the reversal of a specific set of redeemed points.
points_reversedintnumber of points reversed.
reversal_timedate-timeDate and time of points reversal in YYYY-MM-DD HH:MM:SS format.
reversed_on_till_idlongTill ID associated to the points reversal.
reversal_breakup_by_programobjBreakup of points reversed and associated loyalty program.
redemption_breakup_by_sourcearraySource-level breakdown of redeemed points (only included when includePointsSourceBreakdown=true). Shows which stores/tills originally awarded the points being redeemed. Each entry contains:
- source_store: Object with code and name of the store where points were awarded
- points_consumed: Number of points from that source used in this redemption
- awarding_date: Date and time when the points were awarded at that source store (format: YYYY-MM-DD HH:MM:SS)
Query Params
string
enum
required

Identifier of the customer to use.

Allowed:
string
required

Value of the specified identifier type. o retrieve transactions of multiple customers at a time, provide each identifier separating by a comma.
Example: mobile=44700900000,44700900999,4470090345

string
enum

Type of redemption.

Allowed:
date

Retrieves redemptions made on or after a specific date (YYYY-MM-DD). To get transactions of a particular duration, use both start_date and end_date.

date

Retrieves redemptions made on or before a specific date (YYYY-MM-DD). To get transactions of a particular duration, use both start_date and end_date. Example: start_date=2013-12-21+23:45:45&end_date=2013-12-29+12:11:45

string

Code of the specified entity_type. For example, to get transactions of a specific zone (with zone code zone01), pass entity_type=zone&entity_code=zone01.

int32

Limit the number of coupon redemptions to be displayed. Example:coupons_limit=10 to show only 10 coupon redemption details. Use only when the type parameter is not passed.

int32

Limit the number of points redemption results to be displayed. Example:points_limit=10 to show only 10 points redemption details. Use only when the type parameter is not passed.

int32

Limit the number of redemption details (points and/or coupons). Use only when the type parameter is not passed. Default value is 10.

int64

Filter the results by coupon redemption id starting with a specific number. Use only when the type parameter is not passed.

int64

Filter the results by coupon redemption id ending with a specific number. Use only when the type parameter is not passed.

int64

Filter the results by points redemption id ending with a specific number. Use only when the type parameter is not passed.

int64
Defaults to null

Retrieves the credit notes of the transactions. Credit Notes is a receipt given by a cashier to a customer for returned goods which can be used for future purchases.

string
enum
Defaults to false

Sort the results either by redemption id or redeemed time. By default, the results are sorted in the descending order of redeemed time.

Allowed:
string
enum
Defaults to desc

Arranges the transactions based on the value set in sort. By default, results are shown in the descending order of transaction date/id.

Allowed:
boolean
Defaults to false

Pass true to get redemptions of the customer from all programs of the org, false to fetch from the default program associated with the till.

string
enum

Representation of response content.

Allowed:
boolean

Pass true to return the customer ID in response. By default, customer id is not retrieved.

int64

Pass the merchant store ID of to fetch redemptions made in that particular merchant store.

int32

Pass program ID to filter redemptions of a particular program.

Responses

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