Query sales
query_salesQueries sales metrics from the database: 'ventas_periodo', 'margen', 'ranking_productos', 'por_empleado', or 'historial_cliente'.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"metrica": "<metrica>"
},
"name": "query_sales"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | End date YYYY-MM-DD. Requires 'from'. | |
| from | No | Start date YYYY-MM-DD. Requires 'to'. | |
| limit | No | Max results (default 10, max 50). | |
| preset | No | Preset date range. Mutually exclusive with from/to. | |
| metrica | Yes | Metric to query. | |
| customer_name | No | Customer name or fragment. Only for historial_cliente. |