Query Pluggy accounts and transactions with SQL
pluggy_queryRun read-only SQL SELECT queries over bank accounts and transactions for a UTC date range, returning coverage metadata. Call pluggy_schema first before computing totals.
Instructions
Read-only SQLite SELECT over accounts and transactions for the requested UTC period. accounts includes every account returned by every configured Pluggy connection, including accounts without transactions. Reuses collection in memory for 15 minutes and returns coverage metadata. Call pluggy_schema before computing totals.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | Yes | ||
| sql | Yes | ||
| from | Yes | ||
| limit | No |