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

Last updated