Mercury - Get Transactions

Description

This module allows getting the transaction history of a Mercury account, with filters by status, date, and pagination. It includes transfers, card payments, fees, and interest.

Configuration

Field	Type	Required	Description
credentials_id	credential	Yes	Mercury credentials
account_id	string	Yes	Account ID
status	select	No	Filter by status
start_date	string	No	Start date (YYYY-MM-DD)
end_date	string	No	End date (YYYY-MM-DD)
limit	number	No	Results limit (default: 50)
offset	number	No	Offset for pagination

Credentials

This module requires Mercury type credentials with the following fields:

Field	Description
`api_key`	Mercury API Key (obtained in Settings > API)

Output

{
  "success": true,
  "transactions": [
    {
      "id": "txn_abc123",
      "amount": -1500.00,
      "status": "sent",
      "counterpartyName": "Proveedor XYZ",
      "kind": "externalTransfer",
      "createdAt": "2024-01-15T10:30:00Z",
      "postedAt": "2024-01-15T14:00:00Z"
    }
  ],
  "total": 150,
  "account_id": "abc123",
  "message": "50 transacciones encontradas"
}

Statuses

pending: Transaction pending processing
sent: Transfer sent
cancelled: Transaction canceled
failed: Transaction failed

Transaction Types (kind)

externalTransfer: External transfer (ACH/Wire)
internalTransfer: Transfer between Mercury accounts
cardTransaction: Card transaction
fee: Fee
interest: Earned interest

Usage Example

{
  "credentials_id": "mercury_cuenta",
  "account_id": "abc123",
  "start_date": "2024-01-01",
  "end_date": "2024-01-31",
  "limit": 50
}

API Used

API: Mercury API v1
Endpoint: GET /api/v1/account/{id}/transactions
Documentation: https://docs.mercury.com/reference

Notes

Transactions are returned sorted by date
Negative amounts represent outgoing funds
Can be filtered by date range for reports
The kind field indicates the movement type

MercuryGetAccounts - Get account ID to query
MercuryGetTransfers - View only outgoing transfers
MercuryGetBalance - Check resulting balance