query_contracts
Filter and aggregate SECOP II contracts by supplier, entity, date, or value to get totals and counts; returns up to 100 rows.
Instructions
Query SECOP II contracts. Returns at most 100 rows.
With aggregates and columns together, rows are grouped by the columns (for example
columns=[proveedor_adjudicado, documento_proveedor] with sum of valor_del_contrato gives the
total per supplier). Filters are combined with AND; 'contains' is a case-insensitive
substring match on a text column. Dates are AAAA-MM-DD. order_by takes a requested column
or an aggregate alias such as sum_valor_del_contrato or count.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| columns | No | ||
| filters | No | ||
| order_by | No | ||
| aggregates | No | ||
| descending | No |