advanced-search
Search and filter Attio CRM data across companies, people, lists, records, tasks, deals, and notes using complex query conditions and sorting options to find specific information.
Instructions
Advanced search with complex filtering across all resource types
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filters | No | Complex filter conditions with nested array structure. Required format: { "filters": [ { "attribute": {"slug": "field_name"}, "condition": "operator", "value": "search_value" } ] } Examples: - Single filter: {"filters": [{"attribute": {"slug": "name"}, "condition": "contains", "value": "Tech"}]} - Multiple filters: {"filters": [{"attribute": {"slug": "name"}, "condition": "contains", "value": "Tech"}, {"attribute": {"slug": "categories"}, "condition": "equals", "value": "Technology"}]} - OR logic: {"filters": [...], "matchAny": true} Supported conditions: contains, equals, starts_with, ends_with, greater_than, less_than, is_empty, is_not_empty | |
| limit | No | Maximum number of results to return | |
| offset | No | Number of results to skip for pagination | |
| query | No | Search query string | |
| resource_type | Yes | Type of resource to operate on (companies, people, lists, records, tasks) | |
| sort_by | No | Field to sort results by | |
| sort_order | No | Sort order | asc |
Input Schema (JSON Schema)
{
"properties": {
"filters": {
"additionalProperties": true,
"description": "Complex filter conditions with nested array structure.\n\nRequired format:\n{\n \"filters\": [\n {\n \"attribute\": {\"slug\": \"field_name\"}, \n \"condition\": \"operator\", \n \"value\": \"search_value\"\n }\n ]\n}\n\nExamples:\n- Single filter: {\"filters\": [{\"attribute\": {\"slug\": \"name\"}, \"condition\": \"contains\", \"value\": \"Tech\"}]}\n- Multiple filters: {\"filters\": [{\"attribute\": {\"slug\": \"name\"}, \"condition\": \"contains\", \"value\": \"Tech\"}, {\"attribute\": {\"slug\": \"categories\"}, \"condition\": \"equals\", \"value\": \"Technology\"}]}\n- OR logic: {\"filters\": [...], \"matchAny\": true}\n\nSupported conditions: contains, equals, starts_with, ends_with, greater_than, less_than, is_empty, is_not_empty",
"type": "object"
},
"limit": {
"default": 10,
"description": "Maximum number of results to return",
"maximum": 100,
"minimum": 1,
"type": "number"
},
"offset": {
"default": 0,
"description": "Number of results to skip for pagination",
"minimum": 0,
"type": "number"
},
"query": {
"description": "Search query string",
"type": "string"
},
"resource_type": {
"description": "Type of resource to operate on (companies, people, lists, records, tasks)",
"enum": [
"companies",
"people",
"lists",
"records",
"tasks",
"deals",
"notes"
],
"type": "string"
},
"sort_by": {
"description": "Field to sort results by",
"type": "string"
},
"sort_order": {
"default": "asc",
"description": "Sort order",
"enum": [
"asc",
"desc"
],
"type": "string"
}
},
"required": [
"resource_type"
],
"type": "object"
}