salesforce_search_all
Search across multiple Salesforce objects using SOSL queries, apply filters, and retrieve specific fields. Define WHERE, ORDER BY, and LIMIT clauses per object, and use WITH clauses like NETWORK or SNIPPET for advanced filtering.
Instructions
Search across multiple Salesforce objects using SOSL (Salesforce Object Search Language).
Examples:
Basic search across all objects: { "searchTerm": "John", "objects": [ { "name": "Account", "fields": ["Name"], "limit": 10 }, { "name": "Contact", "fields": ["FirstName", "LastName", "Email"] } ] }
Advanced search with filters: { "searchTerm": "Cloud*", "searchIn": "NAME FIELDS", "objects": [ { "name": "Account", "fields": ["Name", "Industry"], "orderBy": "Name DESC", "where": "Industry = 'Technology'" } ], "withClauses": [ { "type": "NETWORK", "value": "ALL NETWORKS" }, { "type": "SNIPPET", "fields": ["Description"] } ] }
Notes:
Use * and ? for wildcards in search terms
Each object can have its own WHERE, ORDER BY, and LIMIT clauses
Support for WITH clauses: DATA CATEGORY, DIVISION, METADATA, NETWORK, PRICEBOOKID, SNIPPET, SECURITY_ENFORCED
"updateable" and "viewable" options control record access filtering
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| objects | Yes | List of objects to search and their return fields | |
| searchIn | No | Which fields to search in | |
| searchTerm | Yes | Text to search for (supports wildcards * and ?) | |
| updateable | No | Return only updateable records | |
| viewable | No | Return only viewable records | |
| withClauses | No | Additional WITH clauses for the search |