Query CRM records
crm_queryFinds what is stored on one list in the business CRM. model is the list name, such as Contacts. A filter is a detail they named, such as a person's name. A plain sentence is enough, such as change Sara's phone number. Use this before you say someone is missing or gone. search_contacts is the phone address book, not this CRM. A filter value matches that field. A filter object uses eq, ne, gt, gte, lt, lte, in, or contains. sort is a field name, {field, direction}, or a list of those. direction is asc or desc. sort_by is one field and sort_dir is asc or desc for this read only. It does not need a saved view and it is not stored. Ask for a count when you only need how many match. It does not change what is stored. Opening hours, addresses, and prices are in get_account.business_facts.
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": {
"model": "<model>"
},
"name": "crm_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | A field name, {field, direction}, or a list of those. direction is asc or desc. | |
| limit | No | Page size. Omitted means 50, and larger values are capped there. | |
| model | Yes | List name on this account. | |
| offset | No | How many matching records to skip. Defaults to 0. | |
| filters | No | Field name to a value, which means equals. Or {op, value}, or {eq, ne, gt, gte, lt, lte, in, contains} to a value. in takes a list. | |
| include | No | Ref field names to expand with the related record. | |
| sort_by | No | One field for this read. It does not need a saved view and it is not stored. | |
| group_by | No | Field names. Returns a count for each combination instead of records. Ignored when count_only is true. | |
| sort_dir | No | asc or desc for sort_by. Defaults to asc. A later read with no sort_by is unordered by this. | |
| direction | No | asc or desc when sort is a field name or a list of field names. Defaults to asc. | |
| count_only | No | When true, return how many records match and no rows. | |
| include_deleted | No | Include soft-deleted records. |