get_clearings
Retrieve accounting-level clearing and reconciliation data for transaction lifecycle analysis. Supports aggregation by detail, day, week, or month to facilitate financial reconciliation processes.
Instructions
Get clearing/reconciliation data. Provides accounting-level line items for the transaction lifecycle. Ideal for reconciliation. Supports detail, day, week, and month aggregation. Note: DiVA API limits results to 10,000 records per query. Use narrower date ranges or more specific filters for larger datasets.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| aggregation | No | Aggregation level for the data | detail |
| fields | No | Specific fields to return | |
| filters | No | Filters on data fields. For date filtering, use actual date field names with operators (e.g., {'post_date': '>=2023-10-20'}) | |
| sort_by | No | Field to sort by | |
| count | No | Maximum records to return (up to 10,000, default 10,000) | |
| program | No | Override default program |