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
1answer
31 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 ...
0
votes
1answer
30 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,'...
0
votes
0answers
26 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": "...
0
votes
1answer
24 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-...
0
votes
1answer
63 views

Sitecore OData MaxDepth $expand

I need to retrieve Sitecore item fields and its properties with more than few levels and while running below query https://sc92instance/sitecore/api/ssc/aggregate/content/Items('76516a9f-203d-4006-...
1
vote
0answers
18 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 ...
0
votes
0answers
39 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 ...
0
votes
0answers
30 views

OData Item Service Return Template Section

Is there a way out of the box to return a template section using OData Item Service? This is for version 9.1. Otherwise I believe the only way is to create a custom entity and return that instead.
1
vote
0answers
69 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 ...
2
votes
1answer
180 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 ...
4
votes
1answer
260 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....
0
votes
1answer
127 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 ...
5
votes
1answer
1k 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/...
9
votes
2answers
2k 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://...
1
vote
1answer
4k 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: ...