Skip to main content

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
0 votes
0 answers
34 views

No HTTP resource was found that matches the request URI ExternalObjects

I have a custom connector wrote in c# which exposes a table from sql server and we have used the endpoint to External Data Source. We are able to query the data and see it in Salesforce but when we ...
sfdc_to_learn's user avatar
0 votes
0 answers
24 views

Place external object data on page layout

I have an external data source that I've set up a connector for. The external data source creates a few external objects, let's call the external object 'House'. This House object has fields, ...
ThePerson's user avatar
  • 101
0 votes
0 answers
40 views

Not able to list records from an External Object in Lightning Tab, but the same list is visible in Classic Tab

I stumbled upon this and spent a lot of time searching answers but found nothing promising. Let me set a context first, I'm using an External Data Source which responds following the OData 4.0 ...
Anmol's user avatar
  • 1
0 votes
0 answers
36 views

O Data Service - How to Auto sync data from other system to SFDC external objects?

From Odata services, I've connected to SAP system. It automatically created an external object and fields based on the table in SAP in SFDC and I created an indirect lookup to the case. I can see the ...
Surya's user avatar
  • 11
2 votes
0 answers
136 views

OData 4.0 External Object: Can't execute SOQL using IN or EQUALS operator, only LIKE - Bug or bad documentation?

According to the Salesforce documentation on SOQL Limits on Objects: External objects also don’t support the following. EXCLUDES operator FOR VIEW clause FOR REFERENCE clause INCLUDES operator LIKE ...
Morgan Marchese's user avatar
0 votes
0 answers
30 views

Salesforce external object (oData) and array in result

I'm having a problem configuring an external object. We have an oData API which allows us to retrieve order information and in this result we have a product table. When I configure the external object,...
NHAM's user avatar
  • 1
0 votes
1 answer
58 views

How can I add Federated Search Results into Experience Cloud portal?

I am following the article https://help.salesforce.com/s/articleView?id=sf.search_experience_enable_obj.htm&type=5 and trying to setup Federated Search Results external Object (Blog__x) into ...
Patlatus's user avatar
  • 17.3k
0 votes
0 answers
49 views

How to handle IndirectLookUp datatype in External Datasource in Salesforce while consuming metadata

In Salesforce External Datasource we are trying to Consuming Mule Application via Odata. As part of this, client requirement is for one of the field datatype is IndirectLookup which links to ...
saieem ali's user avatar
0 votes
1 answer
181 views

Global Search in Salesforce External Connector ( Odata V4.01 ) not working

With Odata v4.01 developed using Apache Olingo , I am facing issues with global search. While searching for an Id in global search, Salesforce is not triggering any request back to odata service. I ...
Shaurya Sharma's user avatar
0 votes
0 answers
89 views

Creating External Object Heroku Connect

Tldr; I am wondering if I create an External Object in Salesforce using my External Data Source (Heroku Connect to Heroku Postgres) if the object should be created automatically in Postgres? I have a ...
jordan.baucke's user avatar
-1 votes
1 answer
47 views

Link external object to a Google Sheets spreadsheet

I need to link an external object to a Google Sheets spreadsheet with the intention of having real-time updates. Does anyone know if this is possible and the best way to do it without using Cross-Org, ...
Marcelo Henrique Pereira Gomes's user avatar
0 votes
1 answer
39 views

Mapping Indirect Lookup field to Custom

In the context of this Trailhead "Quick Start: Salesforce Connect": https://trailhead.salesforce.com/content/learn/projects/quickstart-lightning-connect, is created the OrderDB external data ...
Luis Aguiar's user avatar
0 votes
0 answers
64 views

Field Labels Missing in LWC Display for External Objects After Installation in an Org

We have 2 Orgs. One 'Global' and one 'Local'. The local is connected to global via SF Connect and has some of global org's objects as external objects. In the local we have a LWC which acts a custom ...
nSv23's user avatar
  • 554
0 votes
0 answers
69 views

External Data Source via GraphQL - what happens if there is a new field

If I have a GraphQL endpoint setup to be consumed by Salesforce as an External Data Source, will Salesforce detect changes to fields? For example, let's say my GraphQL endpoint published an object ...
nstuyvesant's user avatar
0 votes
1 answer
127 views

Test Class for multiple external objects

I am trying to write a test class for a apex class that contains multiple external objects. I`ve tried the answer in this link. Although test is passed, the code coverage is only 37%. How can I ...
salesforce1234's user avatar
0 votes
0 answers
216 views

How to validate external object data?

Requirement - When user enters a value in a field(Example__c) then it needs to be validated against an external object and only if the value matches then only we save the changes. Tried so far - ...
Hatake_Kakashi's user avatar
0 votes
1 answer
117 views

Limitations using Salesforce with Apex Class Connector? How should I architect an external database connector [closed]

Our external database has 3 million records. I want to leverage Salesforce Connect to bring the external data into Salesforce without copying it into Salesforce. I am getting my Data from the Metabase ...
Matthew Metros's user avatar
0 votes
0 answers
240 views

Getting an A callout was unsuccessful error for external object

Please assist I'm getting the following error while running a test class for external object : System.UnexpectedException: A callout was unsuccessful because of pending uncommitted work related to a ...
Ramik Allakhverdiev's user avatar
0 votes
0 answers
304 views

NOT IN filter does not work when querying External Object

I have an external object from which I want to retrieve certain values avoiding some other ones depending on certain conditions. The problem is that when I apply the NOT IN filter like in the ...
molinet's user avatar
  • 925
0 votes
0 answers
176 views

Cannot save data in custom field on external object

I have an external object that is coming from a heroku postgres database. I have managed to successfully import the data but not all of the fields have been imported. There is a field on the postgres ...
Valeriy Kutsar's user avatar
0 votes
2 answers
447 views

Edit external object records from Heroku using salesforce connect

We have an external database set up in Heroku using postgres. I would like to be able manage some data from the heroku postgres database in salesforce. I have configured salesforce connect with the ...
Valeriy Kutsar's user avatar
1 vote
0 answers
121 views

Assign permission set in a connected Org via external objects with Apex class

We are creating users in a connected Org via external objects without issues, but when trying to assign the permission sets to those users we are getting the error "System.SObjectException: ...
Cícero Schoeps's user avatar
0 votes
1 answer
403 views

Can External Objects be packaged in Managed Packages?

The [Metadata Coverage Report][1] doesn't mention if External Objects can be packaged as part of Managed Packages. So, this is not clear if External Objects can be packaged in Managed Packagesor not? [...
Patlatus's user avatar
  • 17.3k
0 votes
1 answer
653 views

Send JWT token with External Data Source for Odata v4 endpoint in header

I am trying to Authenticate the Calls to My Odatav4 , In My Service I have started accepting JWT token in header and it is working if i call the service in postman with JWT token in header, Now in my ...
Arjun Shrivatsa's user avatar
1 vote
0 answers
1k views

Query External Object filtering by Date or DateTime dataType

first time ever writing here, hope anyone can help me: We're working with Salesforce Files Connect, currently configured and working with SharePoint. Users can browse files by certain filters we're ...
Livio Cioffarelli's user avatar
1 vote
0 answers
114 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 ...
raj's user avatar
  • 183
0 votes
1 answer
918 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 ...
David Mycka's user avatar
  • 1,327
2 votes
1 answer
260 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 ...
Patlatus's user avatar
  • 17.3k
1 vote
1 answer
1k 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 ...
Kyle J V's user avatar
  • 285
1 vote
0 answers
903 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 (...
Frank's user avatar
  • 11
0 votes
1 answer
776 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 ...
Atharwa Samant's user avatar
1 vote
0 answers
364 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 ...
Hengky Djapar's user avatar
2 votes
1 answer
1k views

External Objects - Security based on logged in community User

Search is enabled on external objects in the community. What setup needs to be done so as results returned are specific to the logged in user? Based on what I researched so far I think: When external ...
Rahul Saxena's user avatar
1 vote
0 answers
312 views

Einstein Analytics on External objects [closed]

Can Salesforce Einstein Analytics be sourced on External objects and external data source
Santosh Patro's user avatar
2 votes
0 answers
81 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 ...
user2573690's user avatar
1 vote
0 answers
14 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 ...
Chris Jang's user avatar
0 votes
1 answer
3k views

Salesforce external data source "EXTERNAL_OBJECT_EXCEPTION: You are not authorized to perform that operation."

I configured a Salesforce external data source to connect to my Office 365 online Sharepoint account. Everything worked! I was able to browse Sharepoint files from the Files tab. I go to grab some ...
Randall's user avatar
  • 131
1 vote
1 answer
536 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. &...
Chris Jang's user avatar
1 vote
2 answers
241 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 ...
Mike Porter's user avatar
0 votes
1 answer
457 views

How to check values of OutputField in lightning component on external objects

I am trying to check the value based on outputfield, Here everytime it is showing else condition values only. Basically the value might be either 0 or 1. Here is my code. <aura:component ...
Aryan's user avatar
  • 27
0 votes
1 answer
2k 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 ...
Madhurima's user avatar
  • 1,425
0 votes
0 answers
372 views

AsyncSaveCallback not working in apex

I am trying to insert records to an external object and get the Id back for the inserted record I have the following piece of code Database.SaveResult[] insertResultAccount = Database.insertAsync(...
Madhurima's user avatar
  • 1,425
5 votes
0 answers
614 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 ...
markgarg's user avatar
  • 734
1 vote
0 answers
80 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 ...
icats's user avatar
  • 111
1 vote
1 answer
449 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.
Izhar Rahmani's user avatar
2 votes
1 answer
4k 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 ...
Venkat V's user avatar
0 votes
1 answer
73 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 ...
SBB's user avatar
  • 173
1 vote
2 answers
547 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 ...
wesaw's user avatar
  • 3,130
2 votes
1 answer
228 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 ...
Obi_77's user avatar
  • 475
1 vote
2 answers
2k 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 ...
AJ Sagar's user avatar