get https://{host}/v1.1/customer/transactions
Retrieves transaction history of a customer which includes the following information. Transaction type, gross transaction amount, transaction date, points issued, points redeemed, coupons redeemed and so on.
By default, it shows up to 10 results and shows results based on the limit passed.
- There is no upper limit for number of transactions.
- There is no duration based limit.
By default, it shows up to 10 results and shows results based on the limit passed.
- There is no upper limit for number of transactions.
- There is no duration based limit.
Example request
curl --location 'https://eu.api.capillarytech.com/v1.1/customer/transactions?mobile=919986000586&format=json&local_currency=true' \
--header 'Authorization: Basic bmVlcmFqLmRvY3NlcDDkxZjg0ZTdi' \
--header 'Cookie: _cfuvid=7hXrm0hlY6PK.uIUfWNV_NmfVOT4Cmsn.3jaI1blBUo-1760427011419-0.0.1.1-604800000'Query parameters
| Parameter | Datatype | Description |
|---|---|---|
| identifierName* | enum | Pass any of the customer identifier with the identifier value. Value: mobile, email, external_id id. To retrieve transactions of multiple customers at a time, provide each identifier separating by a comma. Example: mobile=44700900000,44700900999,4470090345. |
| identifierValue* | string | Provide the respective identifier value. For example, ?email=[email protected]. |
| entity_type | enum | Attribute by which you want to filter the transactions. Value: ZONE, CONCEPT, STORE, TILL, STR_SERVER (store server). For oAuth2, you need to pass this in headers. See the Introduction > Authentication section for more details. |
| entity_code | 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. |
| number | string | Fetch transaction details by transaction number. |
| transaction_id | int | Fetch details of a transaction by transaction ID (internally generated unique ID for a transaction). |
| store_id | string | Filter transactions associated to a specific store id. |
| store_code | string | Filter transactions associated to a specific store code. |
| start_id | int | Filters transactions with transaction IDs are greater than or equal to a specific value. |
| end_id | int | Filter transactions with transaction IDs less than or equal to a specific value. |
| start_date | date-time | Retrieves transactions made on or after 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 |
| end_date | date-time | Retrieves transactions 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 |
| credit_notes | boolean | Retrieves the credit notes of the transactions. Value: true,false. Pass the parameter to retrieve credit notes along with the transaction details. Credit Notes is a receipt given by a cashier to a customer for returned goods which can be used for future purchases. |
| custom_fields | boolean | Pass true to retrieve transaction level custom field details. |
| points_breakup | boolean | Pass true to retrieve the breakup of points earned for each transaction. |
| limit | int | Limit the number of results to be displayed (default value is 10). For example, limit=20 shows up to 20 transactions of the customer. |
| offset | int | Number of records to be ignored from the top. Offset is the position of the entity in the database record. The value is assigned based on the sequence of creation. For example, offset=10 ignores the first 10 transactions of the customer. |
| sort | enum | Arranges transactions in ascending or descending order of transaction date if the value istrans_date, transaction id if the value is trans_id. By default, results are shown in descending order. |
| order | enum | Arranges the transactions based on the value set in sort in an ascending (asc) or descending order (desc). By default, results are shown in the descending order of transaction date/id. |
| local_currency | boolean | Pass true to retrieve the main transaction level amount, gross amount and discount values in transaction currency (the currency in which the transaction was made). The rest of the monetary values, including the line item level values, are displayed in the base currency (default currency set at the organisation level) only. |
Response parameters
| Parameter | Type | Description |
|---|---|---|
| start | string | First transaction ID in the response. |
| delayed_points | string | Delayed accrual points waiting to be available |
| delayed_returned_points | string | Delayed accrual points marked as returned |
| total_available_points | string | Total points currently available, including delayed accrual availability |
| total_returned_points | string | Total points returned, including delayed accrual returns |
| transaction | object | Transaction record |
| . id | string | Unique transaction identifier. |
| . number | string | External bill or reference number. |
| . type | string | Transaction type (for example, REGULAR). |
| . user_group2_id | string | Secondary user group identifier. |
| . return_type | string | Return type, if applicable. |
| . amount | string | Transaction amount in base currency (default currency set at organisation level). |
| . outlier_status | string | Outlier flag for fraud/anomaly checks. |
| . delivery_status | string | Processing status (for example, DELIVERED). |
| . notes | string | Free-text remarks. |
| . billing_time | string | Billing timestamp. |
| . auto_update_time | string | Last system update timestamp. |
| . gross_amount | string | Gross amount before discount in base currency. |
| . discount | string | Discount applied at bill level in base currency. |
| . store | string | Store name. |
| . store_code | string | Store code. |
| . returned_points_on_bill | string | Points returned on this bill. |
| . currency | object | Transaction currency info and ratio. |
| . . ratio | number | Exchange rate between the transaction currency and the base currency. |
| . . transaction_currency | object | Currency used for the transaction. The currency set at store level or the currency defined as local currency when adding transaction using the v1 API. |
| . . . supported_currency_id | number | Internal currency mapping id. |
| . . . name | string | Currency name. |
| . . . symbol | string | Currency symbol. |
| . . id | number | Currency record id. |
| . . name | string | Duplicate of currency name (root of currency). |
| . . symbol | string | Duplicate of currency symbol (root of currency). |
| . points | object | Points summary for the bill. |
| . . issued | string | Points issued. |
| . . redeemed | string | Points redeemed. |
| . . returned | string | Points returned. |
| . . expired | string | Points expired. |
| . . returnedPointsOnBill | string | Returned points specific to this bill. |
| . . expiry_date | string | Points expiry date, if any. |
| . . program_id | string | Loyalty programme identifier. |
| . custom_fields | object | Custom key–value fields. |
| . . field | array | List of custom fields. |
| . extended_fields | object | Extended key–value fields. |
| . . field | array | List of extended fields. |
| . identifiers | object | External identifiers. |
| . . field | array | List of identifier fields. |
| . coupons | array | Applied coupons. |
| . basket_size | number | Count of line items. |
| . line_items | object | Container for line item list. |
| . . line_item | array | Array of line items. |
| . . . [0] | object | First line item. |
| . . . . id | string | Line item id. |
| . . . . type | string | Line item type. |
| . . . . return_type | string | Line-item return type. |
| . . . . outlier_status | string | Outlier status at line level. |
| . . . . serial | string | Line sequence number. |
| . . . . item_code | string | SKU or product code. |
| . . . . description | string | Product description. |
| . . . . qty | string | Quantity purchased. |
| . . . . rate | string | Unit price in base currency. |
| . . . . value | string | Line value before bill-level effects in base currency. |
| . . . . discount | string | Line-level discount in base currency. |
| . . . . amount | string | Line amount in base currency. |
| . . . . line_item_point_details | array | Points breakdown at line level. |
| . . . . extended_fields | object | Extended fields for the line. |
| . . . . split_items | array | Split components, if any. |
| . . . . addon_items | array | Add-on items, if any. |
| . . . . combo_items | array | Combo components, if any. |
| . . . . attributes | object | Line attributes. |
| . . . . . attribute | array | Name–value attribute list. |
| . . . . local_currency | object | Includes the base currency and the transaction currency object at line item-level. This is available only when the local currency query parameter is set to true. |
| . . . . . id | string | Line currency record id. |
| . . . . . ratio | string | Exchange rate between the transaction currency and the base currency |
| . . . . . base_currency | object | Base currency details. This is the default currency set at the organisation level. |
| . . . . . . id | string | Base currency ID. |
| . . . . . . name | string | Base currency name. |
| . . . . . . symbol | string | Base currency symbol. |
| . . . . . transaction_currency | object | Original transaction currency. This is the currency at which the transaction took place. This is set at the store level or as the local currency when using the v1 add transaction API. |
| . . . . . . id | string | Base currency id. |
| . . . . . . name | string | base currency name. |
| . . . . . . symbol | string | Transaction currency symbol. |
| . . . . . amount | string | Line amount in base currency. |
| . . . . . value | string | Line value in base currency. |
| . . . . . rate | string | Unit price in base currency. |
| . . . . . discount | string | Line discount in base currency. |
| . local_currency | object | Bill-level currency mapping. The object containing transaction and base currency details for the whole transaction. This is available only when the local currency parameter is enabled. |
| . . id | string | Bill currency record id. |
| . . ratio | string | Exchange rate between the transaction currency and the base currency |
| . . base_currency | object | Base currency details. The default currency of the organisation. |
| . . . id | string | Base currency id. |
| . . . name | string | Base currency name. |
| . . . symbol | string | Base currency symbol. |
| . . transaction_currency | object | Original transaction currency. |
| . . . id | string | Transaction currency id. |
| . . . name | string | Transaction currency name. |
| . . . symbol | string | Transaction currency symbol. |
| . . amount | string | Bill amount in transaction currency. |
| . . value | string | An equivalent amount of the bill amount in the base currency. This parameter will be removed in future and can be ignored. |
| . . discount | string | Bill discount in transaction currency. |
| . . gross_amount | string | The total transaction value before any discounts are applied in the transaction currency. |
Error code
| Error | Description |
|---|---|
| 91001 | Failed to get point details |
Example response
{
"response": {
"status": {
"success": "true",
"code": 200,
"message": "Success"
},
"customer": {
"firstname": "Neeraj",
"lastname": "FiveEight",
"user_id": "564582355",
"mobile": "919986000586",
"email": "[email protected]",
"external_id": null,
"lifetime_points": 124374.4,
"lifetime_purchases": 72871,
"loyalty_points": 96330,
"current_slab": "Diamond",
"registered_on": "2025-01-06 09:56:21",
"updated_on": "2025-10-14 12:05:31",
"type": "LOYALTY",
"source": "instore",
"user_groups2": [],
"count": 37,
"start": "891340869",
"delayed_points": "0",
"delayed_returned_points": "0",
"total_available_points": "96330",
"total_returned_points": "0",
"rows": "10",
"transactions": {
"transaction": [
{
"id": "891340869",
"number": "DaveMustaine1",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "200.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "This is test",
"billing_time": "2025-09-19 09:04:20",
"auto_update_time": "2025-09-19 09:04:20",
"gross_amount": "110.00",
"discount": "10.00",
"store": "DocStore",
"store_code": "doc123",
"returned_points_on_bill": "0.0",
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "paymentmode",
"value": "cash"
}
]
},
"extended_fields": {
"field": [
{
"name": "additional_discount",
"value": "100"
},
{
"name": "cashier_name",
"value": "Singh"
}
]
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 0,
"line_items": {
"line_item": []
}
},
{
"id": "892288086",
"number": "NeeLocalTest4_2Disc",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "8600.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "Transaction Number 74",
"billing_time": "2025-04-08 17:30:00",
"auto_update_time": "2025-10-14 12:05:31",
"gross_amount": "8600.00",
"discount": "860.00",
"store": "DocSep25",
"store_code": "docsep25",
"returned_points_on_bill": "0.0",
"currency": {
"ratio": 86,
"transaction_currency": {
"supported_currency_id": 101182220,
"name": "United States dollar",
"symbol": "$"
},
"id": 101182220,
"name": "United States dollar",
"symbol": "$"
},
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "",
"value": ""
}
]
},
"extended_fields": {
"field": []
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 1,
"line_items": {
"line_item": [
{
"id": "4033748435",
"type": "REGULAR",
"return_type": "",
"outlier_status": "NORMAL",
"serial": "1",
"item_code": "model_id_001",
"description": "Steel Bottle3",
"qty": "4",
"rate": "430.00",
"value": "1720.00",
"discount": "258.00",
"amount": "1720.00",
"line_item_point_details": [
{
"issued": "0",
"promised": "0",
"promised_returned": "0",
"redeemed": "0",
"returned": "0",
"redeemable_from": "",
"expiry_date": "",
"program_id": "0"
}
],
"extended_fields": {
"field": []
},
"split_items": [],
"addon_items": [],
"combo_items": [],
"attributes": {
"attribute": [
{
"name": "Returnable",
"value": "true"
},
{
"name": "ReturnableDays",
"value": "-1"
}
]
},
"local_currency": {
"id": "352136823",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "1720.0",
"value": "1720.00",
"rate": "430.0",
"discount": "258.0"
}
}
]
},
"local_currency": {
"id": "101182220",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "100.0",
"value": "8600.0",
"discount": "10.0",
"gross_amount": "100.0"
}
},
{
"id": "892287951",
"number": "NeeLocalTest3_2Disc",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "8600.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "Transaction Number 74",
"billing_time": "2025-04-08 17:30:00",
"auto_update_time": "2025-10-14 11:59:23",
"gross_amount": "8600.00",
"discount": "860.00",
"store": "DocSep25",
"store_code": "docsep25",
"returned_points_on_bill": "0.0",
"currency": {
"ratio": 86,
"transaction_currency": {
"supported_currency_id": 101182187,
"name": "United States dollar",
"symbol": "$"
},
"id": 101182187,
"name": "United States dollar",
"symbol": "$"
},
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "",
"value": ""
}
]
},
"extended_fields": {
"field": []
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 1,
"line_items": {
"line_item": [
{
"id": "4033748056",
"type": "REGULAR",
"return_type": "",
"outlier_status": "NORMAL",
"serial": "1",
"item_code": "model_id_001",
"description": "Steel Bottle3",
"qty": "4",
"rate": "430.00",
"value": "1720.00",
"discount": "430.00",
"amount": "1720.00",
"line_item_point_details": [
{
"issued": "0",
"promised": "0",
"promised_returned": "0",
"redeemed": "0",
"returned": "0",
"redeemable_from": "",
"expiry_date": "",
"program_id": "0"
}
],
"extended_fields": {
"field": []
},
"split_items": [],
"addon_items": [],
"combo_items": [],
"attributes": {
"attribute": [
{
"name": "Returnable",
"value": "true"
},
{
"name": "ReturnableDays",
"value": "-1"
}
]
},
"local_currency": {
"id": "352136768",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "1720.0",
"value": "1720.00",
"rate": "430.0",
"discount": "430.0"
}
}
]
},
"local_currency": {
"id": "101182187",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "100.0",
"value": "8600.0",
"discount": "10.0",
"gross_amount": "100.0"
}
},
{
"id": "892287745",
"number": "NeeLocalTest3_Disc",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "8600.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "Transaction Number 74",
"billing_time": "2025-04-08 17:30:00",
"auto_update_time": "2025-10-14 11:45:21",
"gross_amount": "8600.00",
"discount": "860.00",
"store": "DocSep25",
"store_code": "docsep25",
"returned_points_on_bill": "0.0",
"currency": {
"ratio": 86,
"transaction_currency": {
"supported_currency_id": 101182174,
"name": "United States dollar",
"symbol": "$"
},
"id": 101182174,
"name": "United States dollar",
"symbol": "$"
},
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "",
"value": ""
}
]
},
"extended_fields": {
"field": []
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 1,
"line_items": {
"line_item": [
{
"id": "4033747481",
"type": "REGULAR",
"return_type": "",
"outlier_status": "NORMAL",
"serial": "1",
"item_code": "model_id_001",
"description": "Steel Bottle3",
"qty": "4",
"rate": "430.00",
"value": "1720.00",
"discount": "0.00",
"amount": "1720.00",
"line_item_point_details": [
{
"issued": "0",
"promised": "0",
"promised_returned": "0",
"redeemed": "0",
"returned": "0",
"redeemable_from": "",
"expiry_date": "",
"program_id": "0"
}
],
"extended_fields": {
"field": []
},
"split_items": [],
"addon_items": [],
"combo_items": [],
"attributes": {
"attribute": [
{
"name": "Returnable",
"value": "true"
},
{
"name": "ReturnableDays",
"value": "-1"
}
]
},
"local_currency": {
"id": "352136751",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "1720.0",
"value": "1720.00",
"rate": "430.0",
"discount": "0.0"
}
}
]
},
"local_currency": {
"id": "101182174",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "100.0",
"value": "8600.0",
"discount": "10.0",
"gross_amount": "100.0"
}
},
{
"id": "892287474",
"number": "NeeLocalTest2",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "8600.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "Transaction Number 74",
"billing_time": "2025-04-08 17:30:00",
"auto_update_time": "2025-10-14 11:27:56",
"gross_amount": "8600.00",
"discount": "0.00",
"store": "DocSep25",
"store_code": "docsep25",
"returned_points_on_bill": "0.0",
"currency": {
"ratio": 86,
"transaction_currency": {
"supported_currency_id": 101182172,
"name": "United States dollar",
"symbol": "$"
},
"id": 101182172,
"name": "United States dollar",
"symbol": "$"
},
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "",
"value": ""
}
]
},
"extended_fields": {
"field": []
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 1,
"line_items": {
"line_item": [
{
"id": "4033746711",
"type": "REGULAR",
"return_type": "",
"outlier_status": "NORMAL",
"serial": "1",
"item_code": "model_id_001",
"description": "Steel Bottle3",
"qty": "4",
"rate": "430.00",
"value": "1720.00",
"discount": "0.00",
"amount": "1720.00",
"line_item_point_details": [
{
"issued": "0",
"promised": "0",
"promised_returned": "0",
"redeemed": "0",
"returned": "0",
"redeemable_from": "",
"expiry_date": "",
"program_id": "0"
}
],
"extended_fields": {
"field": []
},
"split_items": [],
"addon_items": [],
"combo_items": [],
"attributes": {
"attribute": [
{
"name": "Returnable",
"value": "true"
},
{
"name": "ReturnableDays",
"value": "-1"
}
]
},
"local_currency": {
"id": "352136746",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "1720.0",
"value": "1720.00",
"rate": "430.0",
"discount": "0.0"
}
}
]
},
"local_currency": {
"id": "101182172",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "100.0",
"value": "8600.0",
"discount": "0.0",
"gross_amount": "100.0"
}
},
{
"id": "892285776",
"number": "NeeLocalTest1",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "8600.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "Transaction Number 74",
"billing_time": "2025-04-08 17:30:00",
"auto_update_time": "2025-10-14 09:40:10",
"gross_amount": "8600.00",
"discount": "0.00",
"store": "DocSep25",
"store_code": "docsep25",
"returned_points_on_bill": "0.0",
"currency": {
"ratio": 86,
"transaction_currency": {
"supported_currency_id": 101182166,
"name": "United States dollar",
"symbol": "$"
},
"id": 101182166,
"name": "United States dollar",
"symbol": "$"
},
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "",
"value": ""
}
]
},
"extended_fields": {
"field": []
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 1,
"line_items": {
"line_item": [
{
"id": "4033741540",
"type": "REGULAR",
"return_type": "",
"outlier_status": "NORMAL",
"serial": "1",
"item_code": "model_id_001",
"description": "Steel Bottle3",
"qty": "4",
"rate": "430.00",
"value": "1720.00",
"discount": "0.00",
"amount": "1720.00",
"line_item_point_details": [
{
"issued": "0",
"promised": "0",
"promised_returned": "0",
"redeemed": "0",
"returned": "0",
"redeemable_from": "",
"expiry_date": "",
"program_id": "0"
}
],
"extended_fields": {
"field": []
},
"split_items": [],
"addon_items": [],
"combo_items": [],
"attributes": {
"attribute": [
{
"name": "Returnable",
"value": "true"
},
{
"name": "ReturnableDays",
"value": "-1"
}
]
},
"local_currency": {
"id": "352136740",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "1720.0",
"value": "1720.00",
"rate": "430.0",
"discount": "0.0"
}
}
]
},
"local_currency": {
"id": "101182166",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "100.0",
"value": "8600.0",
"discount": "0.0",
"gross_amount": "100.0"
}
},
{
"id": "892283305",
"number": "NeeLocalTest",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "5160.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "Transaction Number 74",
"billing_time": "2025-04-08 17:30:00",
"auto_update_time": "2025-10-14 07:30:11",
"gross_amount": "5160.00",
"discount": "0.00",
"store": "DocSep25",
"store_code": "docsep25",
"returned_points_on_bill": "0.0",
"currency": {
"ratio": 86,
"transaction_currency": {
"supported_currency_id": 101182131,
"name": "United States dollar",
"symbol": "$"
},
"id": 101182131,
"name": "United States dollar",
"symbol": "$"
},
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "",
"value": ""
}
]
},
"extended_fields": {
"field": []
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 1,
"line_items": {
"line_item": [
{
"id": "4033733432",
"type": "REGULAR",
"return_type": "",
"outlier_status": "NORMAL",
"serial": "1",
"item_code": "model_id_001",
"description": "Steel Bottle3",
"qty": "4",
"rate": "430.00",
"value": "1720.00",
"discount": "0.00",
"amount": "1720.00",
"line_item_point_details": [
{
"issued": "0",
"promised": "0",
"promised_returned": "0",
"redeemed": "0",
"returned": "0",
"redeemable_from": "",
"expiry_date": "",
"program_id": "0"
}
],
"extended_fields": {
"field": []
},
"split_items": [],
"addon_items": [],
"combo_items": [],
"attributes": {
"attribute": [
{
"name": "Returnable",
"value": "true"
},
{
"name": "ReturnableDays",
"value": "-1"
}
]
},
"local_currency": {
"id": "352136663",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "1720.0",
"value": "1720.00",
"rate": "430.0",
"discount": "0.0"
}
}
]
},
"local_currency": {
"id": "101182131",
"ratio": "86.0",
"base_currency": {
"id": "95",
"name": "Indian rupee",
"symbol": "₹"
},
"transaction_currency": {
"id": "216",
"name": "United States dollar",
"symbol": "$"
},
"amount": "60.0",
"value": "5160.0",
"discount": "0.0",
"gross_amount": "60.0"
}
},
{
"id": "884649013",
"number": "DaveMustaineSearch",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "200.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "This is test",
"billing_time": "2025-04-07 04:15:10",
"auto_update_time": "2025-04-07 04:15:09",
"gross_amount": "110.00",
"discount": "10.00",
"store": "DocStore",
"store_code": "doc123",
"returned_points_on_bill": "0.0",
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "paymentmode",
"value": "cash"
}
]
},
"extended_fields": {
"field": [
{
"name": "additional_discount",
"value": "100"
},
{
"name": "cashier_name",
"value": "Singh"
}
]
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 0,
"line_items": {
"line_item": []
}
},
{
"id": "883010076",
"number": "DaveMustaine11",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "200.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "This is test",
"billing_time": "2025-03-11 13:04:07",
"auto_update_time": "2025-03-11 13:04:06",
"gross_amount": "110.00",
"discount": "10.00",
"store": "DocStore",
"store_code": "doc123",
"returned_points_on_bill": "0.0",
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "paymentmode",
"value": "cash"
}
]
},
"extended_fields": {
"field": [
{
"name": "additional_discount",
"value": "100"
},
{
"name": "cashier_name",
"value": "Singh"
}
]
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 0,
"line_items": {
"line_item": []
}
},
{
"id": "883009995",
"number": "DaveMustaine10",
"type": "REGULAR",
"user_group2_id": "0",
"return_type": "",
"amount": "200.00",
"outlier_status": "NORMAL",
"delivery_status": "DELIVERED",
"notes": "This is test",
"billing_time": "2025-03-11 13:01:45",
"auto_update_time": "2025-03-11 13:01:45",
"gross_amount": "110.00",
"discount": "10.00",
"store": "DocStore",
"store_code": "doc123",
"returned_points_on_bill": "0.0",
"points": {
"issued": "0",
"redeemed": "0",
"returned": "0",
"expired": "0",
"returnedPointsOnBill": "0.0",
"expiry_date": "",
"program_id": "983"
},
"custom_fields": {
"field": [
{
"name": "paymentmode",
"value": "cash"
}
]
},
"extended_fields": {
"field": [
{
"name": "additional_discount",
"value": "100"
},
{
"name": "cashier_name",
"value": "Singh"
}
]
},
"identifiers": {
"field": []
},
"coupons": [],
"basket_size": 0,
"line_items": {
"line_item": []
}
}
]
},
"item_status": {
"success": "true",
"code": "1052",
"message": "Transactions fetched successfully",
"warnings": {
"warning": []
}
}
}
}
}