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.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "query_contracts"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| columns | No | ||
| filters | No | ||
| order_by | No | ||
| aggregates | No | ||
| descending | No |