salesforce_search_all

Search across multiple Salesforce objects using SOSL with customizable filters, fields, and clauses. Retrieve specific records by applying WHERE, ORDER BY, and LIMIT options for targeted and efficient data access.

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
`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

Input Schema (JSON Schema)

{
  "properties": {
    "objects": {
      "description": "List of objects to search and their return fields",
      "items": {
        "properties": {
          "fields": {
            "description": "Fields to return for this object",
            "items": {
              "type": "string"
            },
            "type": "array"
          },
          "limit": {
            "description": "Maximum number of records to return for this object",
            "optional": true,
            "type": "number"
          },
          "name": {
            "description": "API name of the object",
            "type": "string"
          },
          "orderBy": {
            "description": "ORDER BY clause for this object",
            "optional": true,
            "type": "string"
          },
          "where": {
            "description": "WHERE clause for this object",
            "optional": true,
            "type": "string"
          }
        },
        "required": [
          "name",
          "fields"
        ],
        "type": "object"
      },
      "type": "array"
    },
    "searchIn": {
      "description": "Which fields to search in",
      "enum": [
        "ALL FIELDS",
        "NAME FIELDS",
        "EMAIL FIELDS",
        "PHONE FIELDS",
        "SIDEBAR FIELDS"
      ],
      "optional": true,
      "type": "string"
    },
    "searchTerm": {
      "description": "Text to search for (supports wildcards * and ?)",
      "type": "string"
    },
    "updateable": {
      "description": "Return only updateable records",
      "optional": true,
      "type": "boolean"
    },
    "viewable": {
      "description": "Return only viewable records",
      "optional": true,
      "type": "boolean"
    },
    "withClauses": {
      "description": "Additional WITH clauses for the search",
      "items": {
        "properties": {
          "fields": {
            "description": "Fields for SNIPPET clause",
            "items": {
              "type": "string"
            },
            "optional": true,
            "type": "array"
          },
          "type": {
            "enum": [
              "DATA CATEGORY",
              "DIVISION",
              "METADATA",
              "NETWORK",
              "PRICEBOOKID",
              "SNIPPET",
              "SECURITY_ENFORCED"
            ],
            "type": "string"
          },
          "value": {
            "description": "Value for the WITH clause",
            "optional": true,
            "type": "string"
          }
        },
        "required": [
          "type"
        ],
        "type": "object"
      },
      "optional": true,
      "type": "array"
    }
  },
  "required": [
    "searchTerm",
    "objects"
  ],
  "type": "object"
}

Salesforce MCP Server

salesforce_search_all

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Salesforce MCP Server

Related Tools