)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Custom SQL query development requires accurate Salesforce API field names, but discovering these names traditionally involves switching between multiple tools and documentation. Modern connectors provide comprehensive discovery methods within the query interface.
You’ll learn how to use built-in discovery tools, smart search, and contextual autocomplete to find exact API field names for your custom queries.
Discover Salesforce API field names efficiently with Coefficient
Coefficientprovides comprehensive field name discovery methods specifically designed for custom SQL query development. You never have to leave the query interface to find field API names.
How to make it work
Step 1. Use the Object Inspector to browse all fields with API names.
Navigate through your Salesforce objects visually in Coefficient’s sidebar where all custom fields are listed with their API names, data types, and descriptions including custom fields ending in __c.
Step 2. Search across objects and fields with Smart Search.
Use field search functionality to quickly find custom fields by API name, label, or partial match. Filter by data type and navigate object relationships to discover related field API names.
Step 3. Build queries with contextual autocomplete assistance.
As you type in the query editor, Coefficient suggests valid field API names based on your selected object. Hover over any field to see its API name, type, and description with one-click copying.
Step 4. Explore the Metadata Explorer for detailed field properties.
View comprehensive field properties including data types, picklist values, validation rules, and relationship mappings. Visualize object relationships with their API names for complex queries.
Step 5. Use advanced discovery methods for complex scenarios.
Find fields matching patterns using wildcard search (e.g., all fields ending in “__c”), discover all fields of specific types, and access recently used field API names for quick reference.
Build better custom queries with accurate field names
Start buildingComprehensive field discovery ensures you never have to guess API names or leave your query interface to find field information.custom queries with complete field visibility today.
