)
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.”
Salesforce’s standard reports only show notes you own or have explicit access to, creating blind spots when you need visibility into all opportunity-related notes across your team.
Here’s how to bypass these ownership restrictions and export comprehensive notes data using API-based extraction methods.
Export notes you don’t own using Coefficient
CoefficientSalesforce’sbypassesnative reporting restrictions by using custom SOQL queries to pull Notes data directly through the API. This approach often provides broader data visibility than standard reports because API permissions frequently exceed report-level access for Notes objects.
How to make it work
Step 1. Connect Coefficient to Salesforce and set up a custom SOQL query.
In Coefficient, select “Import from Salesforce” and choose “Custom SOQL Query.” This gives you direct API access to Notes data that may not appear in standard reports due to ownership restrictions.
Step 2. Write a SOQL query to access notes through parent object relationships.
Use this query structure:. This pulls all notes attached to opportunities you have access to, regardless of who created the notes.
Step 3. Join Notes data with Opportunity information for complete context.
Coefficient automatically handles complex joins between Notes and Opportunity records. Add fields like Parent.Name, Parent.StageName, and Parent.Amount to see notes within full opportunity context without manual data matching.
Step 4. Set up automated refresh schedules to maintain current data.
Configure hourly, daily, or weekly refreshes so your notes data stays current without manual intervention. This ensures you always have access to the latest notes from across your team.
Start accessing restricted notes data today
Get startedThis API-based approach transforms Salesforce notes from a restricted, ownership-limited dataset into comprehensive team visibility.with Coefficient to bypass notes ownership restrictions and build the reports you actually need.
