SePay

Interact with SePay API

Actions3

Transaction Actions

Overview

This node interacts with the SePay API to retrieve transaction data. Specifically, the "Transaction" resource with the "Get All" operation allows users to fetch multiple transactions from their SePay account. It supports filtering by various criteria such as account number, date range, reference number, and amounts, enabling targeted queries.

Common scenarios include:

Retrieving all recent transactions for reconciliation or reporting.
Filtering transactions within a specific date range or by account number.
Limiting the number of transactions returned to manage data volume.

For example, a user might want to get all transactions after January 1st, 2024, for a particular bank account, or fetch only the first 100 transactions matching certain filters.

Properties

Name	Meaning
Return All	Whether to return all matching transactions or limit the results.
Limit	Maximum number of transactions to return if not returning all (minimum 1, maximum 5000).
Filters	Collection of optional filters to narrow down the transactions:
- Account Number	Filter transactions by bank account number.
- Transaction Date Min	Show transactions created on or after this date/time (format: YYYY-MM-DD HH:MM:SS).
- Transaction Date Max	Show transactions created on or before this date/time (format: YYYY-MM-DD HH:MM:SS).
- Since ID	Show transactions starting from this transaction ID onwards.
- Reference Number	Filter transactions by reference number.
- Amount In	Filter by incoming amount value.
- Amount Out	Filter by outgoing amount value.

Output

The node outputs an array of JSON objects representing transactions. Each transaction object contains details as provided by the SePay API under the transactions field in the response. The exact structure depends on the API but typically includes fields like transaction ID, date, amounts, account numbers, and references.

No binary data output is produced by this operation.

Example output snippet (simplified):

[
  {
    "transaction_id": "12345",
    "account_number": "987654321",
    "transaction_date": "2024-04-01 10:00:00",
    "amount_in": "100.00",
    "amount_out": "0.00",
    "reference_number": "INV-001"
  },
  ...
]

Dependencies

Requires an active SePay API credential with a valid API token.
The node makes HTTP requests to the SePay API endpoint at https://my.sepay.vn/userapi.
Proper network connectivity to the SePay service is necessary.

Troubleshooting

API Authentication Errors: If the API token is invalid or expired, the node will throw an error indicating an authentication failure. Ensure the API credentials are correctly configured and valid.
Invalid Filter Values: Providing incorrectly formatted dates or unsupported filter values may result in no data or API errors. Use the specified date format (YYYY-MM-DD HH:MM:SS) and valid strings/numbers.
Limit Exceeded: Setting the limit above 5000 will be rejected; keep it within the allowed range.
Empty Results: If no transactions match the filters, the output will be an empty array.
Network Issues: Connectivity problems to the SePay API endpoint will cause request failures. Verify internet access and firewall settings.

Error messages from the API are surfaced prefixed with "SePay API Error:" followed by the message from the API response.

Links and References

SePay API Documentation (Assumed URL for reference, replace with actual if available)
n8n Documentation on Creating Custom Nodes

SePayInstall