Salesforce Reader
This document explains the Salesforce Reader node, which lets you pull data from Salesforce objects for use in your automations.
Node Inputs
Required Fields
- Object: Choose which Salesforce object to read (e.g., Account, Lead, Contact, Opportunity)
- Fields: Select which fields to retrieve from the chosen object
- Important: When using filtered List Views, make sure to include any fields used in the filter criteria
Optional Fields
- List View: Filter records using predefined Salesforce views
- Select “All Views” to read from the entire object
- The node will respect any filters set in your Salesforce views
Node Output
Each selected field becomes an output list that you can connect to other nodes.
Node Functionality
The Salesforce Reader node connects to your Salesforce instance and:
- Retrieves data from any standard or custom object
- Pulls complete datasets without record limits
- Uses your predefined list views for filtering
- Supports Loop Mode for processing multiple list views or objects
- Maintains secure authentication through Gumloop
Common Salesforce Field Issues and Workarounds
Why Some Fields May Appear Empty or Missing
When using the Salesforce Reader, you may sometimes find certain fields are unavailable or return as None
even though they appear in Salesforce. Here’s why this happens and how to fix it:
1. List View Query Limitations
List Views in Salesforce only fetch specific fields in their underlying queries:
- Only fields included in the List View’s actual SOQL query are available
- Fields used only for filtering but not displayed may not be retrievable
- Fields may appear in the Salesforce UI but aren’t directly accessible via the API query
Workaround: Create a custom List View in Salesforce that explicitly includes all the fields you need.
2. ID Fields vs. Display Values
You’ll often see ID fields (like AccountId
) instead of their display values (like the Account Name):
- Salesforce returns relationship fields as IDs (e.g.,
AccountId: 001xx000003DGb2AAG
) - Users typically expect to see the display value (e.g., “Acme Corporation”)
Workaround: Create formula fields in Salesforce that directly reference the display value:
3. Permission Issues
Some fields may be inaccessible due to permission settings:
- Fields the connected user doesn’t have read access to
- Fields restricted by field-level security
- Object permissions that limit access
Workaround: Check field-level permissions for the connected user and adjust as needed.
4. Polymorphic Relationship Fields
Certain fields like WhatId
in Task objects can reference different object types:
- These fields are particularly challenging because they could point to various object types
- The display value isn’t consistently accessible
Workaround: Create formula fields for each potential object type the field could reference.
Best Practice Workarounds Summary
-
Create Formula Fields:
- Add custom formula fields that directly reference related data
- Example:
Account_Name_Text__c
formula field with valueAccount.Name
- These formula fields will be consistently available to the Salesforce Reader
-
Customize List Views:
- Create specific List Views that include all fields you need
- Add any fields used in filters to the displayed columns
- Save these views with descriptive names for your automation
-
Use Text Formula Fields:
- For lookups and relationships, create text formula fields
- These are more reliable than trying to access the relationship directly
- Example: For a Contact’s Account Name, create
Account_Name__c
as a formula field
-
Check Field Accessibility:
- Ensure the connected Salesforce user has access to all required fields
- Review field-level security settings if fields are consistently missing
Example Workflows
1. Lead Enrichment Pipeline
2. Account Analysis with AI
3. Automated Customer Communication
4. Support Queue Management
Important Notes
Authentication Setup
- Configure your Salesforce credentials in Gumloop Credentials
- Ensure proper Salesforce permissions for the chosen objects and list views
In summary, the Salesforce Reader node provides flexible data extraction from Salesforce objects, supporting filtered views and customizable field selection for efficient data retrieval. With the right setup and workarounds for common field issues, you can ensure consistent and reliable data access from your Salesforce instance.