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.
71
questions
0
votes
0
answers
43
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 - ...
0
votes
0
answers
30
views
Extracting Field dependencies from another Salesforce Org to display in LWC of Local Org
I need a way to display to picklist fields of Case from another org. (lets call it Global) to display in LWC of my local org. The dependent(Substatus__c) and controlling (Status) fields are both ...
- 494
0
votes
1
answer
58
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 ...
- 1,199
0
votes
0
answers
70
views
EXTERNAL OBJECT EXCEPTION: Could not find metadata for requested
I'm trying to query an external object I have and I'm always getting this error as a response:
EXTERNAL_OBJECT_EXCEPTION: Could not find metadata for requested [orgid XXXXXXXXXXXXXXX] [objectName ...
- 823
0
votes
0
answers
95
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 ...
0
votes
0
answers
32
views
How can you create mock data for a read only external object?
I have a non-writable external object based on a SharePoint integration. I am not able to create mock data for the external object since it is not writable. So when I try to create an instance ...
- 353
0
votes
0
answers
125
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 ...
- 823
0
votes
0
answers
71
views
Authorization required error on submit button to retrieve custom object field
I have created a salesforce site using visualforce page. User will input the value and after a button click, custom object should be displayed on page. After after button click, getting "...
- 1
0
votes
0
answers
71
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 ...
0
votes
0
answers
49
views
Trying to Create a Feed Using an External Callout Using Chatter API
What works:
All three files are communicating with each other
The lightning button calls handleClick()
handleClick() gets the return value of getFeedElements()
getFeedElements(any given record ID) ...
0
votes
2
answers
170
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 ...
1
vote
0
answers
68
views
How to use navigationmixin on externalobject with external-Id
I have a lwc page on click of the button i need to open an external object via external-id.
I know that i can first make a query with ext-id and get the record id and then i can redirect,
but is there ...
- 371
1
vote
0
answers
79
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: ...
0
votes
1
answer
187
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?
[...
- 14.7k
0
votes
1
answer
439
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 ...
1
vote
0
answers
462
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 ...
1
vote
0
answers
71
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 ...
- 183
0
votes
1
answer
497
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 ...
- 1,285
2
votes
1
answer
199
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 ...
- 14.7k
1
vote
1
answer
762
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 ...
- 287
0
votes
0
answers
371
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 (...
- 1
0
votes
1
answer
518
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 ...
1
vote
0
answers
198
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,734
1
vote
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 ...
- 41
1
vote
0
answers
236
views
Einstein Analytics on External objects [closed]
Can Salesforce Einstein Analytics be sourced on External objects and external data source
2
votes
0
answers
66
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 ...
- 121
1
vote
0
answers
12
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 ...
- 25
0
votes
1
answer
1k
views
Report on External Object
I am trying to create a report on an external object. The enable reports checkbox for this object is set to true, however when I go to reports and click on new report, the external object doesn't come ...
0
votes
1
answer
2k
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 ...
- 131
1
vote
1
answer
356
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.
&...
- 25
1
vote
2
answers
196
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 ...
- 57
0
votes
1
answer
336
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 ...
- 17
0
votes
1
answer
1k
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 ...
- 1,175
0
votes
0
answers
254
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(...
- 1,175
5
votes
0
answers
470
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 ...
- 724
1
vote
0
answers
50
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 ...
- 111
1
vote
1
answer
288
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.
1
vote
1
answer
3k
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 ...
- 63
0
votes
1
answer
31
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 ...
- 153
1
vote
2
answers
459
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,875
2
votes
1
answer
177
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 ...
- 475
1
vote
2
answers
1k
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 ...
- 11
6
votes
0
answers
848
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 ...
- 607
1
vote
1
answer
3k
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
1
answer
911
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
0
answers
79
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 ...
- 133k
1
vote
0
answers
511
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 <...
- 11
3
votes
1
answer
2k
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....
- 139
0
votes
1
answer
439
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 ...
4
votes
3
answers
899
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 ...
- 36.4k