search_records
Search across government datasets with free-text queries, filters, and pagination. Retrieve specific fields and sort results for precise data extraction.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| q | No | Free-text search across all fields. Supports Hebrew/English, partial matches, and multiple words. Examples: 'תל אביב', 'בנק לאומי', 'emergency' | |
| sort | No | Sort results by one or more fields. Format: ["field_name asc/desc"]. Examples: ["Name asc"], ["Date desc", "Amount desc"] | |
| limit | No | Number of results to return (1-1000). Use 5-10 for quick exploration, 20-50 for analysis, 100-1000 for comprehensive data extraction | |
| fields | No | Return only specific fields to reduce response size and improve performance. Examples: ["Name", "City"], ["Amount", "Date", "Type"] | |
| offset | No | Skip first N results for pagination. Use with limit for paging: page 1: offset=0, page 2: offset=limit, page 3: offset=limit*2 | |
| filters | No | Exact field matches as JSON object. Supports single values, arrays, and operators. Examples: {"City": "תל אביב"}, {"City": ["תל אביב", "חיפה"]}, {"Amount": {"$gte": 1000}} | |
| distinct | No | Return unique values for a specific field only (no full records). Useful for getting all possible values. Examples: 'City', 'Type', 'Status' | |
| resource_id | Yes | Resource UUID from list_resources. Get this ID from datastore_active=true resources. Example: '2202bada-4baf-45f5-aa61-8c5bad9646d3' for bank branches | |
| include_total | No | Include total count of matching records in response. Essential for pagination planning and showing 'X of Y results' |