Apex Developer Guide

Apex Developer Guide
Getting Started with Apex
Writing Apex
Running Apex
Invoking Apex
Apex Transactions and Governor Limits
Using Salesforce Features with Apex
Actions
Approval Processing
Authentication
Chatter Answers and Ideas
Use Cases for the CommercePayments Namespace
Connect in Apex
Moderate Chatter Private Messages with Triggers
Moderate Feed Items with Triggers
Experience Cloud Sites
Email
Metadata
Platform Cache
Salesforce Knowledge
Salesforce Files
Salesforce Connect
Salesforce Connect
Apex Considerations for Salesforce Connect External Objects
Writable External Objects
External Change Data Capture Packaging and Testing
Get Started with the Apex Connector Framework
Key Concepts About the Apex Connector Framework
Considerations for the Apex Connector Framework
Apex Connector Framework Examples
Salesforce Reports and Dashboards API via Apex
Salesforce Sites
Support Classes
Territory Management 2.0
Flows
Integration and Apex Utilities
Debugging, Testing, and Deploying Apex
Apex Language Reference
Appendices
Glossary
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Apex Considerations for Salesforce Connect External Objects

Apex code can access external object data via any Salesforce Connect adapter, but some requirements and limitations apply.
  • These features aren’t available for external objects.
    • Apex-managed sharing
    • Apex triggers (However, you can create triggers on external change data capture events from OData 4.0 connections.)
  • When developers use Apex to manipulate external object records, asynchronous timing and an active background queue minimize potential save conflicts. A specialized set of Apex methods and keywords handles potential timing issues with write execution. Apex also lets you retrieve the results of delete and upsert operations. Use the BackgroundOperation object to monitor job progress for write operations via the API or SOQL.
  • Database.insertAsync() methods can’t be executed in the context of a portal user, even when the portal user is a community member. To add external object records via Apex, use Database.insertImmediate() methods.

When running an iterable batch Apex job against an external data source, the external records are stored in Salesforce while the job is running. The data is removed from storage when the job completes, whether or not the job was successful. No external data is stored during batch Apex jobs that use Database.QueryLocator.

Important

  • If you use batch Apex with Database.QueryLocator to access external objects via an OData adapter for Salesforce Connect:
    • Enable Request Row Counts on the external data source, and each response from the external system must include the total row count of the result set.
    • We recommend enabling Server Driven Pagination on the external data source and having the external system determine page sizes and batch boundaries for large result sets. Typically, server-driven paging can adjust batch boundaries to accommodate changing data sets more effectively than client-driven paging.

      When Server Driven Pagination is disabled on the external data source, the OData adapter controls the paging behavior (client-driven). If external object records are added to the external system while a job runs, other records can be processed twice. If external object records are deleted from the external system while a job runs, other records can be skipped.

    • When Server Driven Pagination is enabled on the external data source, the batch size at runtime is the smaller of the following:
      • Batch size specified in the scope parameter of Database.executeBatch. Default is 200 records.
      • Page size returned by the external system. We recommend that you set up your external system to return page sizes of 200 or fewer records.