execute_soql
Execute SOQL queries on Salesforce objects, including custom fields. Supports pagination and detail level selection for efficient data retrieval.
Instructions
Execute a SOQL query. Supports querying both standard and custom fields (custom fields end with __c in their API names). Use describe_object first to discover available fields.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SOQL query to execute. For custom fields, use the API name (e.g., Project_Status__c) | |
| pageSize | No | Number of records per page (default: 25) | |
| pageNumber | No | Page number to retrieve (default: 1) | |
| detail | No | Response detail level (default: summary) |