Skip to main content

Questions tagged [odata]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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
137 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
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
1 vote
1 answer
204 views

Salesforce Connect OData v4 needs a cookie from /Login endpoint before talking to data endpoints

Here's a rundown of my Salesforce Connect setup: FIRST I was able to set up a Named Credential, using password authentication API Name: MyAPI URL: https://myapi:50000/b1/v2 SECOND I then created an ...
bkwdesign's user avatar
  • 609
1 vote
1 answer
400 views

OData connection to Microsoft Dynamics GP 2019 "This data isn't available because the associated table in the external data source can't be found"

Attempting to set up an OData external data source to Dynamics Great Plains - confirmed I can connect via OData using MS Excel, so I believe that's right. When attempting to set this up in Salesforce ...
James Boutcher's user avatar
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
151 views

How to prepare OData provider for child-parent relationship

How an external data source of type OData, V2 AtomPub format, should be prepared in order to support the child-parent relationship in SF. The JSON response contains __metadata": { ...
DraganS's user avatar
  • 111
0 votes
1 answer
28 views

Is there a database method other than oData?

I wonder if there is a database and method other than oData. I wonder if there is a way to connect in real time like oData rather than importing a csv file.
Jack Den Per's user avatar
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
1 answer
608 views

SSJS HTTP GET OData REST API

I'm trying to perform a SSJS HTTP GET request to an endpoint that uses "OData", however the call fails (Cloud Page doesn't load). The SSJS GET function in question (seen below) is the only code on the ...
Cameron Robert's user avatar
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
1 vote
2 answers
818 views

How to deploy data source of type OData to scratch org

I'm trying to deploy an external data source of type 'OData' to my scratch org. The scratch org is an 'Enterprise' type. I get the following error: This org does not have the appropriate ...
Andreas86's user avatar
  • 357
0 votes
1 answer
2k views

Salesforce Connect - Associated table in the external data source can't be found

New to Salesforce Connect, but not necessarily new to parsing JSON responses and utilizing webservices. I am attempting a test connection to https://jsonplaceholder.typicode.com/comments with ...
S.B.'s user avatar
  • 2,111
1 vote
1 answer
908 views

External Data Source deployment (Salesforce Connect)

I have configured the External Data Sources using Odata 4.0,and i need to move this setup to UAT environment .What is best approach to do this ? Deployment OR manually create setup in UAT environment ...
SUresha Shettigar's user avatar
0 votes
1 answer
329 views

How to use same external object to display different related list in the same Parent Object

I have the following requirements. -> In the case object (this is a salesforce object) I have to create a related list of Transfer Transactions. I achieved this. And the related object is an external ...
MRP's user avatar
  • 3
3 votes
1 answer
954 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 ...
jkondratowicz's user avatar
0 votes
1 answer
300 views

How our database should be for using it with Salesforce Connect?

I have a on-premise data base(Oracle DB), this database i need to use in salesforce directly using External Object technology provided by salesforce. I understood how to use External objects in ...
user3576180's user avatar
2 votes
2 answers
867 views

Creating an external object using OData 4.0 adapter

I've got a ASP.NET WebAPI project that must integrate with a Salesforce instance, using the OData 4.0 adapter for Salesforce. Searching and viewing my external objects is working fine, but I am unable ...
GoatInTheMachine's user avatar
4 votes
1 answer
1k views

Integration with REST API that is not CRUD

I'm a developer working on an API that tries to be REST-ful, but is limited in terms of CRUD. Many entities expose a GET endpoint, but because many create and update actions have side-effects, we don'...
GoatInTheMachine's user avatar
3 votes
0 answers
1k views

External integration: MuleSoft vs Salesforce Connect? [closed]

I am looking to integrate an external system that supports OData into SFDC. Both ends of this integration will need to have read and write access to each other. I am assuming a peak traffic rate of 10,...
Mossi2's user avatar
  • 479
0 votes
1 answer
617 views

Odata : Get data from Salesforce Using Odata?

Is there any way to get Salesforce data (Lead,Contact) using Odata. There are some Application Cloud Drivers, Progress DataDirect Cloud and Skyvia Connect for it. Are they using Normal Rest Api and ...
Manjot Singh's user avatar
  • 3,526
1 vote
0 answers
117 views

Is it possible to see the URL salesforce generates through lightning connect

We are trying to connect to a dell boomi service with oData 2.0 but boomi is having an issue consuming the URL and parsing parameters. We do not have access to the boomi service, but is it possible ...
TemporaryFix's user avatar
  • 2,946
1 vote
1 answer
624 views

Hide "Display URL" on OData/External Object global search results?

Is it possible to not display the column "Display URL" within the Global Search page when displaying OData/External Object/Lightning Connect results? The field is not in the External Object's Search ...
Haphazard's user avatar
  • 331
3 votes
1 answer
5k views

Exposing Amazon RDS hosted table as OData service

I am new to AWS so please be easy on me.. I have a PostgreSQL DB hosted on Amazon RDS and would to expose few tables of the PostgreSQL database through OData service. The goal is to use these ...
user3861's user avatar
  • 181
0 votes
3 answers
1k views

Expose Salesforce sObjects as oData

Scenario Salesforce is the master system for data. All the data is stored in Salesforce. An external system can consume oData. Question Is it possible to use salesforce as the source of data and ...
Christian Deckert's user avatar
5 votes
0 answers
232 views

Lightning ODATA connect How to create a Test coverage case

I have tried to create a test coverage method against a database Query which goes after an external object. The external datasource is a Lightning ODATA 2.0 connector. I setup the MockHTTPcallout but, ...
ErnieA's user avatar
  • 51
1 vote
1 answer
395 views

Are external objects only available via Lightning Connect now?

I dabbled around with External Data Sources a while back with this public Northwind OData data feed. I decided to take another look at it for a project we are working on, but it appears Salesforce has ...
Swisher Sweet's user avatar
0 votes
1 answer
323 views

API Call Interruption

I am trying to make a webapi call from apex class. I have an external data source based on oData for Lightning connect. And I am trying to qeury the external object records. I am getting error - "...
Kalpi's user avatar
  • 1
1 vote
0 answers
277 views

Odata: External Object Create new data in external data source error

I'm trying to create new data in the external data source. create new data through any client tool works correctly but when i try to do the same clicking on new button on SFDC i got this message : ...
NightStorm's user avatar
1 vote
2 answers
380 views

External Data Source

I am trying to set up an External data Sourcein my developer Org. However I do not get any option other than "Simple URL" in the Type drop down. How can we get the other values to show up?
cloudy-ritz's user avatar
  • 2,583
4 votes
1 answer
2k views

Test class for a controller that has logic to query the external object records

We have enabled the Lightning connect and defined an External Data Source for Lightning Connect - Odata 2.0 Adapter and the External Object records are loaded from Informatica. The functionality ...
Sirisha Kodi's user avatar
3 votes
1 answer
320 views

Is there any way to consume Odata and make an insert and update?

I saw that we can only use read and query with Odata in SFDC with External source Objects is there any way we can make an insert or update using Odata Web services ? Thank you and sorry is this was ...
NightStorm's user avatar
1 vote
2 answers
2k views

How to map a field from External Object to Standard Object

Working on Odata first time , Needs to know Is it possible to map external object from Odata to standard object? Is it needs to be done using custom field (using formula) in standard object. ...
cloudy-ritz's user avatar
  • 2,583
-1 votes
2 answers
496 views

Lightning Connect - OData Service [closed]

Has anyone used Apache Olingo to create a OData service to expose Oracle database.
Vidya's user avatar
  • 1
3 votes
3 answers
575 views

Try out OData/External Object/Lightning Connect

We're designing a system for a client that involves quite a bit of data. The regular data storage limits in Salesforce will definitely be exceeded by a factor of 10 or more. So one technology that ...
Jochen's user avatar
  • 683
0 votes
1 answer
1k views

OData for Siebel/Oracle to connect with Salesforce using Lightning Connect

We want to expose Siebel data in Salesforce using Lightning Connect.As of now Lightning Connect supports OData v2.0 format.Can anyone let me know how to change Siebel data into OData v2 format....
Suneel's user avatar
  • 1,341
6 votes
2 answers
625 views

OData implementation in Salesforce

Salesforce is supporting OData 2 protocol using Lightning Connect, However do we have any information or way on how Data inside Salesforce can be exposed as OData ? These records then can be used by ...
Jitendra Zaa's user avatar
  • 3,102
3 votes
3 answers
2k views

How to create an OData v2 Service from scratch?

Can anyone direct me a to a good step by step instruction page on how to create an OData V2 service? I am a Salesforce person, with little exposure to .NET. Still, I do have Visual Studio Community ...
Lily Blunt's user avatar
2 votes
2 answers
455 views

Platform Connect / External Data Source from Siebel

I have to connect with in-premises Siebel system to a get the data for a Lookup in SFDC. Can we connect with Siebel with External Data source method ? I can see Siebel EBC here in this article but ...
amidstCloud's user avatar
  • 2,837