Salesforce SOQL Query
salesforce_queryQuery Salesforce records using SOQL to retrieve data like Accounts, Contacts, or Opportunities with customizable output format.
Instructions
Execute a SOQL (Salesforce Object Query Language) query to retrieve records from Salesforce.
SOQL is similar to SQL. Example queries:
SELECT Id, Name, Industry FROM Account WHERE Industry = 'Technology' LIMIT 10
SELECT Id, Name, Email FROM Contact WHERE AccountId = '001xx000...'
SELECT Id, Name, StageName, Amount FROM Opportunity WHERE CloseDate = THIS_YEAR
Args:
soql (string): A valid SOQL query string
limit (number): Max records to return from results (default: 20, max: 200)
response_format ('markdown' | 'json'): Output format (default: 'markdown')
Returns: JSON: { totalSize, done, records[], nextRecordsUrl? } Markdown: Formatted table of results
Error: Returns descriptive error if query syntax is invalid or fields don't exist.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| soql | Yes | SOQL query string (e.g., SELECT Id, Name FROM Account LIMIT 10) | |
| limit | No | Maximum number of records to return (default: 20) | |
| response_format | No | Output format: 'markdown' for human-readable or 'json' for machine-readable | markdown |