Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [odata]

Open Data Protocol, is an open protocol to allow the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way. All question related to OData in reference with Sitecore should use this tag.

Filter by
Sorted by
Tagged with
1 vote
1 answer
42 views

How do you resolve: GetEdmModel cannot be called more than once error?

I have tried rebuilding the solution and deploying it. The deploy task finishes but I get the above error when the unicorn sync begins as the site cannot be accessed. I've searched online and cannot ...
Rob Connolly's user avatar
2 votes
0 answers
29 views

Getting error on multiple level children with field values using Sitecore Odata Itemservice

I am trying to get on multiple-level children with field values using Sitecore Odata Itemservice. I am using the below query: Query: sitecore/api/ssc/aggregate/content/Items('/sitecore/content/Booked'...
Sushil Pal's user avatar
0 votes
0 answers
24 views

How to get children's of item using odata service in sitecore [duplicate]

I need to get all the children of the below folder structure using the Sitecore OData service. Is there any way to get all the children without the folder structure, meaning all items under "...
Chandan Agrawal's user avatar
0 votes
0 answers
15 views

We are getting below error during fetch odata/Contacts and odata/DeviceProfiles in XDB XConnect Exception Filter OnException() [duplicate]

[Error] XConnect Exception Filter OnException(), url - "https://myinstance.com/odata/DeviceProfiles?%24filter=Id+eq+273b227a-0a0e-4695-b20b-cc3ab7ea60e5" System.OperationCanceledException: ...
Geetha's user avatar
  • 133
1 vote
1 answer
139 views

Is there a way to get rendering details of a sitecore item via Sitecore item Odata services?

We have a requirement to migrate content pages from Sitecore to AEM. For this we are using Sitecore Odata services approach. But this only provides information about page item fields and not ...
user9152709's user avatar
0 votes
0 answers
82 views

How can I use Commerce API in order to add data to the Shared Environments database?

I made a Sitecore API and registered a Router, and after that, I called it through PostmanAPI. I write a command process to add data to the database but follow the default when inheriting from ...
nhannt201's user avatar
3 votes
1 answer
138 views

OData Item service Support in Sitecore 8.2

For one of our new application[non-sitecore] we need some data from Sitecore Instance which is on version 8.2. We are looking for the available API options, Is OData Item Service is supportable with ...
AB1005's user avatar
  • 66
1 vote
1 answer
164 views

OData Itemservice throws Null Reference

I searched using the endpoint: http://url/sitecore/api/ssc/aggregate/content/Items?sc_apikey=D5471CCA-DB0D-4260-A588-3D15025BA5CF&$expand=FieldValues&$filter=contains(FieldValues/Summary,'...
Lala's user avatar
  • 397
0 votes
0 answers
501 views

Is it possible to query an integer in OData?

I'm trying to query an integer field using Sitecore's OData ItemService. This is my data: "FieldValues": { "$count": 3, "SiteName": "SiteA", "Min": "...
Lala's user avatar
  • 397
1 vote
1 answer
254 views

Searching using FieldValues is not working on OData

I have followed the docs and none of these worked: ?$filter=FieldValues/Product_Name eq 'XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX' and ?$filter=contains(FieldValues/Product_Name,'XXXXXXXX-XXXX-XXXX-XXXX-...
Lala's user avatar
  • 397
3 votes
1 answer
1k views

Sitecore OData MaxDepth $expand

I need to retrieve Sitecore item fields and its properties with more than few levels and while running the below query https://sc92instance/sitecore/api/ssc/aggregate/content/Items('76516a9f-203d-4006-...
Nick's user avatar
  • 109
1 vote
0 answers
63 views

"Parent context is required for this entity type" when querying for Contact Interactions on xConnect OData

We are using Microsoft Power BI to mine into xConnect OData. We are interested, among other things, in the Interactions of our contacts. However, Power BI generates requests that cannot be fulfilled ...
Andreas Warberg's user avatar
0 votes
0 answers
143 views

Generate downloadable link in Odata item service

I want add some media and files in sitecore and expose it through Odata Item Service to so that an external system can download the file from sitecore. But when we request any item over Odata, getting ...
Jojo's user avatar
  • 463
1 vote
0 answers
201 views

Fetch related items with Sitecore odata API result

I have a field in an item, which is data sourced as a multi list. When I try to access my item fields using OData Service, I am getting the multi-list field values as selected Item Ids. Is there any ...
D J's user avatar
  • 385
2 votes
1 answer
322 views

How to make Connect call to Commerce Engine

I am in the middle of writing a plugin to get product recommendations from a particular user to display on the XP Storefront side. I wrote my plugin to return a RecommendationList (which inherits from ...
Robert Michael Watson's user avatar
5 votes
1 answer
340 views

Component is an OData Entity and thus a NavigationProperty

I am using Sitecore Commerce Experience 9 update-2, and want to add a custom child component to an entity. The Sitecore.Commerce.Core.Component has a Key annotation (of type System.ComponentModel....
Joost's user avatar
  • 1,907
0 votes
1 answer
147 views

Sitecore Commerce 8.2.1 Get all carts of a given user

I need to give the customers the possibility to have more than one cart, and I am not able to find a way to retrieve all the carts related to a given customer. I'm creating carts with this name ...
User010203's user avatar
6 votes
1 answer
5k views

How to expand children ( multi level ) with FieldValues with OData

Trying to $expand multiple levels of an item's children. I have tried queries with //* at the end, but that didn't work, for example: /sitecore/api/ssc/aggregate/content/Items('/sitecore/content/Site/...
jay's user avatar
  • 211
12 votes
2 answers
3k views

Can I call the oData service directly in xConnect?

I've been playing round with Sitecore 9 recently and the xConnect api and had a question around oData. Underneath the api layer there is an oData service that can be reached via: https://...
Ian Graham's user avatar
  • 1,033
1 vote
1 answer
8k views

ODATA search against a string collection field, searching for one or more values

I've this document called entities. I would like to execute this query that contains "IN" to allow me to select a document based on whether one or more values are contained in a string list field: ...
drcimux's user avatar
  • 11