Payment Transaction Data API

Authentication

Obtain a token via the Authentication 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

Parameter	Type	Mandatory	Description
requestId	String	Yes	Unique identification code generated by the client
email	String	Yes	Email address
cellphoneNumber	String	Yes	Borrower'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.

{
    "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:

Parameter	Data 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
matchKey	cellphoneNumber or email	Shows the key that matched

The Sub-details Record follows the format:

Parameter	Data 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