# Payment Transaction Data API ## Authentication Obtain a token via the [authentication](https://docs.lenderlink.ph/product-guides/api-integration-guides/authentication "mention") procedure. ### Endpoint The API endpoint for accessing the Payment Transaction Data is: ``` https://sandbox-app.lenderlink.ph/api/v1/person/payment-transactions ``` Web Method: **GET**
ParameterTypeMandatoryDescription
requestIdString YesUnique identification code generated by the client
email String YesEmail address
cellphoneNumberString YesBorrower's phone number, the format is 63XXXXXXXXXX.
### Response Parameters System responds with HTTP status 401 (unauthorized) if an unsupported version number was provided. Otherwise, a status 200 and a JSON object is returned in its body. ```json { "requestId": "X123-AB45", "matchFlag": "Hit", "data": { "transactionCount": 33, "minAmount": 94, "maxAmount": 10150, "aveAmount": 2668.43, "sumAmount": 88058.04000000001, "stdDev": 2737.87, "refDates": [ "2025-01-16", "2025-01-20", "2025-01-21", "2025-02-02", "2025-02-16", "2025-02-19", "2025-02-20", "2025-02-28", "2025-03-03", "2025-03-15", "2025-03-30", "2025-04-17", "2025-04-18", "2025-04-21", "2025-05-02", "2025-05-09", "2025-05-10", "2025-05-11", "2025-05-18", "2025-05-21", "2025-05-23", "2025-05-25", "2025-05-28", "2025-05-30", "2025-05-31", "2025-06-10", "2025-06-13", "2025-06-28", "2025-06-29", "2025-07-02", "2025-07-04" ], "refDateDetails": [ { "refDate": "2025-01-21", "count": 1, "total": 2880 }, { "refDate": "2025-02-28", "count": 1, "total": 638.07 }, { "refDate": "2025-05-25", "count": 1, "total": 1140 }, { "refDate": "2025-02-16", "count": 1, "total": 6575 }, { "refDate": "2025-05-28", "count": 1, "total": 1315 }, { "refDate": "2025-05-18", "count": 1, "total": 182 }, { "refDate": "2025-03-03", "count": 1, "total": 406 }, { "refDate": "2025-04-18", "count": 1, "total": 5260 }, { "refDate": "2025-03-30", "count": 1, "total": 4350 }, { "refDate": "2025-02-02", "count": 1, "total": 406 }, { "refDate": "2025-06-29", "count": 1, "total": 2840 }, { "refDate": "2025-02-20", "count": 1, "total": 6400 }, { "refDate": "2025-04-17", "count": 2, "total": 3146.99 }, { "refDate": "2025-05-09", "count": 1, "total": 153 }, { "refDate": "2025-05-23", "count": 1, "total": 3287 }, { "refDate": "2025-05-30", "count": 1, "total": 10150 }, { "refDate": "2025-05-21", "count": 1, "total": 123 }, { "refDate": "2025-05-10", "count": 1, "total": 145 }, { "refDate": "2025-05-11", "count": 2, "total": 311 }, { "refDate": "2025-06-28", "count": 1, "total": 5260 }, { "refDate": "2025-04-21", "count": 1, "total": 669.98 }, { "refDate": "2025-07-04", "count": 1, "total": 94 }, { "refDate": "2025-07-02", "count": 1, "total": 2175 }, { "refDate": "2025-05-02", "count": 1, "total": 1440 }, { "refDate": "2025-05-31", "count": 1, "total": 1450 }, { "refDate": "2025-02-19", "count": 1, "total": 5800 }, { "refDate": "2025-01-16", "count": 1, "total": 6575 }, { "refDate": "2025-06-13", "count": 1, "total": 106 }, { "refDate": "2025-06-10", "count": 1, "total": 1180 }, { "refDate": "2025-03-15", "count": 1, "total": 7800 }, { "refDate": "2025-01-20", "count": 1, "total": 5800 } ], "categories": [ "Loans", "Fintech", "Marketplace" ], "procIds": [ "ECPY", "ABQR", "GCSH" ], "within1to30Days": [ { "category": "Loans", "transactionCount": 4, "minAmount": 1180, "maxAmount": 5260, "sumAmount": 11455, "stdDev": 1504.32 }, { "category": "Marketplace", "transactionCount": 2, "minAmount": 94, "maxAmount": 106, "sumAmount": 200, "stdDev": 6 } ], "within31to60Days": [ { "category": "Marketplace", "transactionCount": 6, "minAmount": 114, "maxAmount": 197, "sumAmount": 914, "stdDev": 29.61 }, { "category": "Loans", "transactionCount": 5, "minAmount": 1140, "maxAmount": 10150, "sumAmount": 17342, "stdDev": 3429.55 } ], "beyond61Days": [ { "category": "Loans", "transactionCount": 11, "minAmount": 1440, "maxAmount": 7800, "sumAmount": 55621, "stdDev": 1877.31 }, { "category": "Fintech", "transactionCount": 5, "minAmount": 405.99, "maxAmount": 669.98, "sumAmount": 2526.04, "stdDev": 121.93 } ], "matchKey": "cellphoneNumber" } } ``` The details of the JSON object are as follows:
ParameterData Type Description
transactionCount Integer The number of successful collection transactions completed by the user within the time period
minAmount Decimal The smallest amount among all the transactions by that user within the period
maxAmount Decimal The largest amount among all the transactions by that user within the period
aveAmount Decimal The average amount of all the transactions by that user within the period
sumAmount Decimal The total amount of all the transactions by that user within the period
stdDev Decimal The population standard deviation of the amounts
refDates Array of Date An array of dates when the transactions occurred
categories Array of String An array of categories covering the various merchants where the payments were made to
procIds Array of String An array of payment processors where the various payments were made to
within1to30Days Array of Sub-Details Records An array of records based on the transactions from the last 30 days showing the breakdown by category
within31to60Days Array of Sub-Details Records An array of records based on the transactions from the last 31 to 60 days showing the breakdown by category
beyond61Days Array of Sub-Details Records An array of records based on the transactions beyond the last 61 days showing the breakdown by category
matchKeycellphoneNumber or emailShows the key that matched
The Sub-details Record follows the format:
ParameterData Type Description
category String The industry or category of the merchant
transactionCount Integer The number of successful collection transactions completed by the user associated with the email within the time period
minAmount Decimal The smallest amount among all the transactions by that user within the time period
maxAmount Decimal The largest amount among all the transactions by that user within the time period
sumAmount Decimal The total amount of all the transactions by that user within the time period
stdDev Decimal The population standard deviation of the amounts