Questions tagged [externalobjects]

External objects are similar to custom objects, but external object record data is stored outside your Salesforce organization. External objects are available with Salesforce Connect and Files Connect.

Filter by
Sorted by
Tagged with
19
votes
1answer
240 views

Are Custom Metadata Types considered External Data Sources?

Back in 2016 we created a Custom Metadata Type with about 3000 rows. There is a trigger that reads all 3000 rows (via SOQL) and creates a map. This has been working for years, until Winter '19. Now, ...
6
votes
0answers
599 views

External Objects not supported in Force.com sites

(Edit: all of this is happening only in a Force.com site. The Lightning Web Component is not the source of the problem) I'm trying to query an External Object inside @AuraEnabled method, but I'm ...
5
votes
1answer
357 views

Can external object data be mocked?

We have a customer that has several large (many fields) external objects in their internal production environment. We need to do some development that will be very dependent on those object ...
4
votes
0answers
217 views

Scratch org with Knowledge and External objects

I'm having issues creating a Scratch Org with both Knowledge and External Objects enabled. It looks like Knowledge can only work in Enterprise edition scratch orgs while External Objects/Data sources ...
3
votes
3answers
459 views

Overcome Queueable maximum depth limit in dev orgs

To migrate "trees of related data" from an external system to Salesforce I am using dynamic chains of Apex Queueables. Imagine I am "synchronizing" Accounts, Opportunities and Contacts from an ...
3
votes
1answer
2k views

Salesforce Integration: Pros and cons of S2S over the other options (REST API etc) [closed]

I am very familiar with Salesforce 2 Salesforce (S2S) and it works well for sharing data going forward between production-production orgs or sandbox-sandbox orgs, either automatically or manually. In ...
3
votes
1answer
542 views

Identifying user interacting with external objects using Salesforce Connect OData 4.0

I have external data source configured in Salesforce, it connects to OData 4.0 API. Let's say I have 1 external object in this data source, called Kitten. The problem: I want security to be handled on ...
3
votes
1answer
1k views

Related List for external object not showing any records in Lightning (SharePoint Online)

I am having problems with displaying data from external data source in Lightning. I have a connection to SharePoint Online while using Indirect Lookup relationship to match external data with Accounts....
3
votes
0answers
128 views

Salesforce Connect Custom Adapter test class

What is the correct way to approach testing Salesforce Connect custom adapters? Perhaps there is a unified approach to testing all of its parts, but specifically what is the approach for testing the ...
2
votes
2answers
742 views

How to overcome 2000 records limit for external object

I am able to fetch for each soql only 2000 records(Due to Governer limitis) for external objects. but i want to fetch the remaining records and pass the remaining list also to vf page to display the ...
2
votes
1answer
55 views

What is preferable choice for integration: Salesforce to Salesforce or MiddleWare tool?

If there are two companies which use the same Order data and the data is created in company A and then the Order data should be sent to company B, should Salesforce to Salesforce integration be used ...
2
votes
1answer
77 views

External Objects

We use a homebrew ERP system based on MySQL & Perl. In Salesforce accounts we need some picklists to select values from specific MySQL tables (only reading from external system is required). New ...
2
votes
1answer
115 views

Map SFDC object to existing Table in Heroku

We have a Customer table that already exists in Heroku and we want to map that table to a custom object in Salesforce. When the Postgres table is updated, we want the corresponding custom object ...
2
votes
0answers
45 views

Where to define server/credentials when connecting to External Objects?

This must be really simple and I'm completely overlooking it but where are the credentials/server specified when defining an External Data Source? In this org's case, we have a custom External Data ...
2
votes
0answers
111 views

Salesforce Connect report limitations?

We have an Odata endpoint configured for SF Connect access. 3 simple external objects, and having an extremely difficult time getting reports to function. Standard reports are ok until you add any ...
2
votes
1answer
230 views

Obtaning refresh token when using Extenral Data Source with Salesforce OAuth 2

I'm trying to configure an External Data Source to use Salesforce Auth Provider so the OAuth 2 will pass access and refresh token. My configuration: Identity Type: Per User Authentication ...
1
vote
2answers
892 views

External Object Query in trigger

I have an external object lookup in case. I have a scenario when a record inserted or updated on the case. If the type and subtype field condition matches, I have to check the external object field ...
1
vote
2answers
375 views

SOSL for External Object

I have configured a Salesforce Connect relationship to an external data source using a custom Apex adapter. I am trying to configure one of the external objects to allow search. I have selected the "...
1
vote
1answer
1k views

External Data source through apex custom adapter

I want to connect the external database from salesforce. I have developed the custom adapter (DataSource.Connection class and DataSource.Provider class). In connection class, Sync method is working ...
1
vote
1answer
73 views

How do I mock external objects for the purpose of testing a batch Apex class?

I have a Batchable Apex class that queries against an external object in the QueryLocator. I need to be able to write a test against the batch apex class to achieve coverage. I've looked this answer ...
1
vote
1answer
166 views

The External Change Data Capture doesn't work with an error!

I'm using OData v4.0 and the External Object is set in Salesforce, which is connected with Heroku Connect. However, the Change Data Capture feature does not work, and the following error occurs. &...
1
vote
2answers
218 views

External Object to make only subset of records from mysql table available for SF org

We have a rather typical requirement at a first glance - just to make bunch of records from external mysql database available in clients' sf orgs. And we are giving a short to SF External Object as an ...
1
vote
1answer
353 views

Code Coverage - Salesforce Connect Custom Adapter / Datasource.Connection Class

I am unable to find documentation on or get any code coverage for the customer adapter Apex Class (Datasource.Connection Class). For awareness, the external data source and customer adapter functions ...
1
vote
0answers
43 views

External Lookup Field Displayed as Textbox Instead of Lookup Input

I have a custom object which has two external lookup fields to two different external objects that were created via Cross Org Adapter. The first external lookup field is for eternal Case object. This ...
1
vote
0answers
125 views

Einstein Analytics on External objects [closed]

Can Salesforce Einstein Analytics be sourced on External objects and external data source
1
vote
0answers
10 views

How do I get a coverage with external object in Apex Class? [duplicate]

After retrieving data from an external object, I'm in progress type conversion to an External Object. However, when I run test class, it is not covered from this point. test__x objT = new ...
1
vote
2answers
97 views

oAuth: setting it up for server-to-server connection with External Objects

I'm setting up External Objects using Salesforce Connect (aka Lightning Connect) and OAuth. I've configured the Authentication Provider to use the OAuth parameters and the External Data Source to use ...
1
vote
0answers
32 views

Custom “Files Connect” integration between asset management system and Salesforce

Is possible to set up a Files Connect integration (that behaves like the existing out-of-box Files Connect integrations - Box, Google Drive, Sharepoint, etc) with a custom digital asset management ...
1
vote
1answer
2k views

Record level sharing for external objects

As per the docs, record sharing is not available on External object. Does that means that all users will be able to see all external object records? (as they are searchable) For example, let say you ...
1
vote
1answer
388 views

External Object Related List shows timeout error

I am trying to configure an external object in Salesforce for which the source is a Postgres table that contains approx. 34 million records. I was able to set up the External data Source which ...
1
vote
0answers
288 views

Database.querylocater on external object in batch class not returning any rows

I am writing a batch class on external object. Here I am using database.getQuerylocator in start method as the result will contain more thank 50k records. Batch class code: global class <...
1
vote
1answer
80 views

Add Image to External Objects

I have created an External Object Customer . I need to add documents as well such as passport pic & pdf document. The data is now saved as binary from the database that I load data from. My ...
1
vote
1answer
276 views

External Object general error message on login

When logging into an org as a System Admin, I receive the following error: The text of the error message: "Developer error in file apex://Order__x at line number -1" Stack trace error message: "...
1
vote
0answers
86 views

How to connect to SAP through Salesforce Connect

Can anyone help me how to connect to External Data i.e, SAP through Salesforce connect using External Data Source and External Objects. Thanks.
1
vote
0answers
93 views

SF Connect Custom Adapter: upsertRows not called

I have implemented a custom adapter for Salesforce Connect - two Apex classes, one that implements DataSource.Provider, the other implements DataSource.Connection. I have configured an External Data ...
0
votes
1answer
880 views

Apex Test coverage on External Objects

How can the Test Coverage can be fulfilled for the Apex classes which queried for External Objects.I have written Test class just like assuming External Object behaves like a custom Object but getting ...
0
votes
1answer
525 views

Not being able to query External Object from Trigger

I need to query an external Object from Contact Trigger. If records are present in the external object, then we have to update the contact. Otherwise we have to create the contact. Now, my issue is ...
0
votes
1answer
98 views

advantages of using OData connector over Custom apex connector [closed]

so I have connected an external data source to salesforce using custom apex connector, I want to know the advantages and disadvantages of doing the same with odata connector.
0
votes
1answer
26 views

External Object Sync Without Wiping Cusomizations?

I have a table in a PostgreSQL database that I am exposing as an External ODATA Object to bring into my Salesforce Org. There are about 25 columns on this table. Within my Org, in the external object ...
0
votes
1answer
927 views

External Object in Lightning error: “Unsupported Item”

I am currently developing a custom Apex adapter for Salesforce Connect. In Classic, the external object record is loading successfully from the external source. When I load the record in Lightning, ...
0
votes
0answers
14 views

We ran into an error when running this report. Try to re-submit your query

The report is created using custom report type and the composition are: Legend: (C) = Custom | (X) = External Base: Account Joined Object: External Object from Heroku PG named as Collection Details ...
0
votes
0answers
17 views

Insert into External Object

We have set up a postgres on Heroku. Using Heroku Connect we have exposed couple of tables as external object following this [link][1] . We are able to read the data in Salesforce. But when we are ...
0
votes
0answers
17 views

Can we add add custom row level actions & and custom buttons on External Object that are defined in Salesforce Connect Custom Adapter?

I have created an External Object using Salesforce Connect Custom Adapter. I am able to see the records. Now I want to add custom row level actions and custom List buttons. Note: The above screenshot ...
0
votes
0answers
14 views

S3 connection with Einstein analytics- showing zero rows

I have created S3 connection with Einstein analytics. Connection is created successfully also object got run successfully with no warnings. But no. of rows in and rows out is showing zero. Checked all ...
0
votes
1answer
41 views

Not able to add External Data User Authentications to user profile/setting

I am trying to add External Data User Authentications to my user in salesforce. But it's showing Named Credentilas box has my option to select but somehow it is greyed out. Steps->Authentication ...
0
votes
0answers
11 views

External Object to synchronize with BigQuery table

I'd like to synchronize an External Object with data from BigQuery. Therefore, I have a BigQuery table which contains worklog data from our employees. The External Object in Salesforce should give me ...
0
votes
0answers
31 views

External Data Source Named Principal - Will an OAuth 2.0 Auth Provider eventually require another login?

I am setting up an External Data Source to OData, using a Named Credential that is set up as "Microsoft Access Control Service" to call Azure Active Directory. The External Data Source is ...
0
votes
0answers
36 views

Can't query more than 2000 records on external data source object

I understand query_all and query_more, but I can't seem to get more than 2000 records from an external data source object. I've tried this a few ways, and below is Python. Note that if I use the (...
0
votes
1answer
77 views

List View for External Object created using Custom Adapter is throwing an Error

We have created a custom adapter for Salesforce Connect. The "All" list view is working fine, but if I add a filter on the createdate = This Month, it throws me below error. The filter ...
0
votes
0answers
27 views

Non-admin Users unable to see Salesforce Connect External Data from an Odata Endpoint

I am using Salesforce Connect and have setup an OData based external data source and object and its working fine for admin users. But it does not show any data for the non-admin users. The ...