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

1
vote
2answers
674 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 + ...
4
votes
1answer
673 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). ...
2
votes
1answer
199 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 ...
1
vote
1answer
227 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
657 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
508 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
81 views

How do I use REST $filter with a “Hyperlink or Picture” type column?

The $filter method works perfectly on regular text columns, but I can't figure out how to use it with a "Hyperlink or Picture" type column. For example: ...
0
votes
1answer
74 views

Connect SharePoint Lists with OData

I have a DataSet, I have created an Excel spreadsheet using OData connection. Now I want to create a SharePoint List using this Excel data. I want the Excel and SharePoint List to be sync so that list ...
0
votes
1answer
118 views

Add item to list using Fiddler and REST Urls

I'm currently reading up on using REST urls to add data in SharePoint 2013 On-Premises. Ultimately, I'd like to use JavaScript to leverage REST. I found this guide about testing this functionality ...
0
votes
1answer
272 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
349 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) ...
4
votes
0answers
145 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
92 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
195 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
50 views

Multi-factor authentication enabled Office 365 site

I am looking for any working examples of remote CSOM or SOAP OData calls against Office 365 with multi-factor authentication enabled. The available documentation is unclear on this scenario. I think ...
1
vote
0answers
417 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
283 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
164 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
51 views

Querying field is invalid when accessing it by using OData query operations in SharePoint 2013 REST requests

I'm trying to use the OData query operations in SharePoint REST requests, but I get an error message when Im trying to join two lists and access some fields. The message is saying: QUERYING THE ...
0
votes
0answers
46 views

OData batch request does not work well

Now I'm trying to use odata batch request in reference to the following things. http://www.andrewconnell.com/blog/part-2-sharepoint-rest-api-batching-exploring-batch-requests-responses-and-changesets ...
0
votes
0answers
44 views

sharepoint rest query for multiple parameters

I am using REST query for getting values in search I am trying to use a filter that combines topic and field http://URL/_api/search/query?querytext='Path:http://URL/en/topic/article OR ...
0
votes
0answers
53 views

Retrieve data from listdata.svc of an FBA site using jquery

I am trying to retrieve data from listdata.svc of an FBA site using jQuery but no success. Here is my code: <script> $(document).ready(function() { //use the getJSON mehtod of ...
0
votes
0answers
46 views

Author and CreatedBy, api/web and listdata.svc differences

This is such a strange problem I'm not even sure how to ask it. I have rely heavily on rest-based services to access my SP2013 data for web applications. Depending on the circumstance I'll either ...
0
votes
0answers
85 views

Auto refresh Odata connection between SharePoint list and MS Excel

I have an Odata connection set up in Excel Services to SharePoint list data. The Odata connection pivots the list data, then charts it in Excel Services, and the chart is hosted in SharePoint When I ...
0
votes
0answers
108 views

Sharepoint 2013 Document Library Excel oData Data Retrive issue

I am trying to retrieve data from SharePoint Document library to excel using oData Data Feed. My Document library name is "2015" and it have one choice field. I am getting the following error when I ...
0
votes
0answers
39 views

SharePoint oData expand not working when Associated multiselect Item is in a folder

We have Event and it contains Meetings and below oData Query was working fine. _vti_bin/ListData.svc/Events(22)?$select=Meetings&$expand=Meetings As soon as we associate a Meetings that is ...
0
votes
0answers
59 views

Sharepoint 2010 listdata.svc returning HTTP status 403

I am attempting to connect to a Sharepoint site using the Data Service endpoint of the form http://sitepath/_vti_bin/listdata.svc. I always get an HTTP 403 status which I checked using Fiddler. Based ...
0
votes
0answers
390 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
86 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
20 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
77 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
41 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
24 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
72 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
48 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 ...