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
requestId
String
Yes
Unique identification code generated by the client
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:
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:
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