OData is a standardized protocol for creating and consuming data APIs. OData builds on core protocols like HTTP and commonly accepted methodologies like REST. The result is a uniform way to expose full-featured data APIs.

learn more… | top users | synonyms

0
votes
2answers
89 views

Ajax Odata 400 bad request

I get a 400 Bad Request from this code, hard to debug, what can the problem be? function saveSelectedAnswer(radioValue) { var requestUri = _spPageContextInfo.webAbsoluteUrl + ...
2
votes
1answer
151 views

What is difference between SharePoint REST and ODATA?

I have read that SharePoint REST and ODATA provide web services like WCF to fetch list/items, etc. So what is difference between REST and ODATA? Please provide a programmatic example to show the ...
2
votes
1answer
564 views

Problems adding WCF Data Services to SharePoint 2010

I would like to add a custom OData endpoint to SharePoint 2010. Because of its dependency on .NET 4.0, the Web API OData provider is currently not an option for SharePoint 2010 (based on .NET 3.5). ...
1
vote
1answer
66 views

How do I get the List REST method to return the results with the display name and not the internal name

zopv & s2u2 are internal names, but I would like the results to be returned using the display name. FileSystemObjectType: 0 Id: 2 ContentTypeId: "0x010100517BCCBD1C63034A8C1141184DAB12C5" ...
1
vote
1answer
260 views

SharePoint 2013 Rest API OData Query

I am calling rest uri from jQuery ajax with filter string comparison startswith as below ...
1
vote
1answer
325 views

REST API ItemCount on oData BCS List

I have a list generated from a BCS oData provider and I am attempting to get the number of items in the list so I can generate a $top on my request rather than bring back only the 100 item generic ...
0
votes
1answer
31 views

The remote server returned an error: (407) Proxy Authentication Required.- BCS

We are trying to Consume OData in BCS using an App External Content Type. The OData service that we used is http://services.odata.org/V3/Northwind/Northwind.svc We followed ...
0
votes
1answer
473 views

Expanding columns in lookup fields

Using the SharePoint 2013 REST API, Can I get more than one column from the lookup column by using the $select and $expand endpoints?
0
votes
1answer
259 views

BCS create an item returns: The remote server returned an error: (500) Internal Server Error

I am using a SAP web service and I am using BCS to get the external data. However, when I try to create a new item via code I get this error: Stack trace: The remote server returned an error: (500) ...
3
votes
0answers
75 views

SharePoint Online List limitations

Is it just me or is it really strange that SSRS 2012 still does not support Claims based authentication or OData connections? Anybody know of plans? Reasons for such a hole in the strategy? Part of a ...
2
votes
0answers
51 views

Unable to Refresh BCS External Data

I am running into a refresh issue with BCS. Whenever I hit the little refresh button in the UI, I am repeatedly getting this error. I am using an OData web service for BCS with WindowsCredentials ...
2
votes
0answers
154 views

Tag not closed error in Datafeed

When accessing the standard data feed for a list I get the following error: Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was ...
1
vote
0answers
42 views

Odata Syntax to Orderby a Lookup Column Result

I have need to order an Odata call by by the results of a lookup list. I am having trouble using the $expand operator in tandem with the orderby operator. What changes can I make so that my Odata ...
1
vote
0answers
162 views

how to pares search api odata json result in C#

i'm using that search query string siteUrl = "<site>"; string queryText ="Path:\"pathTosearch/*\" IsDocument:1"; string rowlimit = "10"; string sortExpression = "Write:descending"; ...
1
vote
0answers
137 views

Return a Single Entity from SharePoint OData Service

I've created a custom OData service in SharePoint 2010 to return a list of entities representing subsites, however I'd also like to be able to return the root. To this end, I've created a function to ...
0
votes
0answers
41 views

2013 REST api $skiptoken with $orderby returns wrong number of results

I noticed some discrepancies in the number of results when getting paged list items when I $orderBy different fields. I set up a test list with 196 items, the below snippet will get items in batches ...
0
votes
0answers
14 views

Excel PowerQuery say “The User was not authorized” , when i am trying connect to a sharpoint list that I have full control permisson for it

When I am trying to connect to a sharpoint2010 list -that I have full control permisson for it-, with OData feed connection , Excel PowerQuery say "The User was not authorized" . I work in a windows ...
0
votes
0answers
14 views

Cannot see some SharePoint data feed because of user rights, that is wrong!

I try to see 2 list data feed with same user rights that are in same SharePoint 2010 site via browser by some url like this "http://SiteURL/_vti_bin/listdata.svc/ListName . One is ok but the another ...
0
votes
0answers
18 views

BCS OData navigation properties are not shown in SharePoint Hosted App external list

I have created a WCF Data Service that is hosted on Azure. I use this service as the data source for my SharePoint Hosted App's external lists. I noticed I was missing all navigation properties from ...
0
votes
0answers
21 views

showing data in custom asp.net from sharepoint 2013(document libs/lists)

What would be best approach to show docs or list in an asp.net page from SharePoint 2013 on premises? I would like to show documents and lists. Which one is better CSOM,Odata? With document libraries ...
0
votes
0answers
11 views

Set App External Content Type Connection Settings to OData Service Endpoint During Deployment

Is there anyway I can set the connection settings for the apps external content type during deployment/activation. The OData endpoint is hardcoded in the ECT file to my dev environment. Is there a ...
0
votes
0answers
18 views

How to read Odata service(created for SAP LOB) response which is a entity query set and expects filter parameters, in SharePoint BCS code?

I am performing DUET development where in the requirement is to read collection of data(attachments in SAP) is published over OData service by Gateway development. It is filtering based on 3 ...
0
votes
0answers
27 views

How to retrieve Listdata from a View via listdata.svc?

I'm using (http://name_of_server/_vti_bin/listdata.svc/Name_of_list) to retrieve data via an ODATA connection. How can I set this up to select only the data displayed on a specific view from the ...
0
votes
0answers
66 views

Can't create list item on Sharepoint Online (Office 365) from localhost

I created sharepoint hosted app in Office 365 and I use localhost HTML files to execute some Odata REST queries (I'm logged into Sharepoint online during execution). Read queries working fine, but ...
0
votes
0answers
58 views

Sharepoint 2010 OData query User Name and Group Name instead of User ID and Group ID

please help, how it is possible to query OData list to retrieve User Name and Group Name instead of User ID and Group ID through Microsoft Data Feed Provider for Power Pivot? What property should be ...
0
votes
0answers
123 views

2013 App Scoped External Content Type OData Throttling even though it's disabled

I have a 2013 SharePoint-hosted app that is using an OData External Content Type (inside of the app itself). With smaller amounts of data it works fine, but with larger results the OData calls are ...