Payment Transaction Data API

Authentication

Prerequisites

In order to obtain an API Token you first need to have client_id and client secret from the previous step.

Token Request Flow

To authenticate and obtain an OAuth token, follow the standard OAuth token request flow.

  • POST API URL

Copy

https://sandbox-app.lenderlink.ph/oauth/token
  • Grant Type

Use this grant type when the client is a server and does not require user authentication.

Copy

"grant_type": "client_credentials"
  • Requesting the Access Token

To request the Access Token, submit a POST request to the API URL, including the following body parameters in JSON format:

Copy


{
    "grant_type": "client_credentials",
    "client_id": "your client id",
    "client_secret": "your client secret",
}
                                        
  • Handling the Token Response

Upon successful validation, the authorization server will respond with an access token:


{
    "token_type": "Bearer",
    "expires_in": 86400,
    "access_token": "eyJ0eXAiOiJKasd10sJhbGciOiJSUzI1NiJ9.eyJhdWQiOiI5YTc4MzVm..."
}
                                        
  • Token Lifespan

Access tokens have a limited lifespan of 86400 seconds. Once the token expires, you can obtain a new one.

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
            }
        ]
    }
}

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

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