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
-2
votes
1answer
24 views

Salesforce to salesforce [closed]

We acquire two companies who are having salesforce orgs for their business. we would like to connect the 3 orgs(including my org) with salesforce to salesforce connection to share the records that are ...
0
votes
0answers
15 views

How do I put an external data source into an unmanaged package with named credentials?

I am packaging an external data source (namely Salesforce Connect: OData 4.0). I'm specifically having trouble implementing named credentials. For authentication, I'm using Named Principal with ...
1
vote
0answers
14 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 ...
0
votes
0answers
13 views

Query Case Feed Posts (Chatter)

I am bringing in a Case object from another org as an external object (read only). I am trying to re-create the notes associated with it from the chatter feed and build a lwc. The problem I am ...
0
votes
0answers
17 views

External objects don’t support some aggregate functions and clauses Like avg, groupBy etc. what are possible workarounds?

External objects don’t support the following aggregate functions and clauses. – AVG() function – COUNT(fieldName) function (however, COUNT() is supported) – HAVING clause - GROUP BY clause – MAX() ...
0
votes
1answer
20 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
20 views

SOQL Getting Related Records of External Object

I am trying to figure out how to write a SOQL query to get some related record data. I have an external Contact object I am bringing into my org. It has a field on it that I created an indirect ...
0
votes
1answer
27 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
10 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
0answers
17 views

External Object - AccountShare - RowCause Field missing

I am trying to create an external object from a Veeva Org via external data source. When i select AccountShare object and click on Sync the external object AccountShare__x is created with the ...
0
votes
0answers
9 views

Case object Access for other instance support people

my customer has acquired by some comp. they have two salesforce instances already. I would like provide my instance case object access to other instance support team. they should able to see and ...
0
votes
0answers
18 views

Data missing in external object longtext field

I have connected a salesforce org A with another org B (with-Veeva-configured) through external data source and i am using an external object from org B. This particular custom object includes text ...
1
vote
2answers
50 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 ...
2
votes
1answer
41 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 ...
1
vote
2answers
211 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 ...
0
votes
0answers
51 views

External Object (Files Connect): SOQL Query returns null for custom fields

I have created an External Object via Files Connect and linked up a custom field to a custom metadata column in SharePoint. The field displays correctly, when I change data in SharePoint it gets ...
6
votes
0answers
332 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 ...
1
vote
1answer
83 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 ...
0
votes
0answers
22 views

External Lookup Field Blank in LEX

I have 2 external objects: Buyer and Invoice. I have an external lookup field on Invoice to Buyer. On the Buyer Lightning Record Page, the Invoices are listed in a related list component, however, ...
1
vote
1answer
72 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 ...
0
votes
0answers
20 views

Can external objects access custom objects in the same org?

The External Objects documentation describes a cross-org adapter that: Uses the Lightning Platform REST API to access data that’s stored in other Salesforce orgs. Can this (or some other ...
0
votes
0answers
14 views

Show external object in search component for communities

I'm using the standard search component but I am not able to add external objects in the list of "Objects in Autocomplete Results" . However, I can find them in the search box for the Org. Does ...
1
vote
0answers
99 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 <...
3
votes
1answer
250 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....
0
votes
1answer
67 views

Salesforce External Object - Query where clause text size issue

As per requirement i was query to external object for selected product in where clause i was put all the product id but till 100 Id its working fine but for 200 its giving error . How we can avoid ...
2
votes
3answers
152 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 ...
0
votes
0answers
25 views

Error when trying retrieve record id from external object detail page on button click

I have a custom button on a external object detail page which executes a java script.I am trying to fetch the id of the record var id = '{!ExternalObject__x.Id}' and when i click on save I received ...
1
vote
0answers
140 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 ...
0
votes
0answers
41 views

Salesforce External Data Connect

I have connected an external data source to Salesforce to fetch data. The data was getting fetched properly.Currently when I am logging into the application it is showing an Internal Error.Also in the ...
0
votes
0answers
44 views

Pass Variable to Endpoint from External Data Object Filter - Salesforce Connect

I have an endpoint that I am utilizing for External Data Objects in Salesforce Connect. I pass a value from the SOQL filter (WHERE clause), but as we know this is only applicable if there is a field ...
2
votes
0answers
29 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 ...
1
vote
1answer
37 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 ...
19
votes
1answer
197 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, ...
1
vote
1answer
187 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
49 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.
3
votes
0answers
89 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
0answers
151 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 ...
0
votes
1answer
8 views

How can I add Tab to an External Object's Search Layouts?

I have two External Objects. One I added a few weeks ago and it has a Tab Search Layout: I can't remember how I gave it a Tab Search Layout but I need that for the following External Object (which ...
3
votes
1answer
284 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 ...
0
votes
1answer
152 views

External Objects: The value of a parameter contains a character that is not allowed or the value exceeds the maximum allowed length

I created an External Object using an OData 4.0 provider and attempted to display the values of this object (several columns) in a listview. The listview displays an error with text as in title of OP:...
0
votes
1answer
625 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, ...
1
vote
2answers
168 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
0answers
54 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 ...
2
votes
1answer
83 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 ...
5
votes
1answer
238 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 ...
1
vote
1answer
617 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 ...
0
votes
1answer
121 views

OData connection using Lightining 2.0

When i am set up the url in salesforce and validate ans sync i am receiving this error. Please suggest me how to solve this ,its kind of urgency You don't have permission to view this external data....