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

7
votes
2answers
7k views

SharePoint 2013 and anonymous access problem

We run into following problem: We have application, that makes authenticated calls to sharepoint 2013 REST services (PUT and GET). Everything works well, when anonymous access is turned off. But we ...
7
votes
1answer
260 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 ...
6
votes
3answers
6k views

How can I filter based on Choice fields when using ListData.svc in SharePoint 2010?

I have a list that I'm trying to query using ListData.svc. I am trying to pull back records within a date range and with a particular value from a Choice field checked. If I use Lists.asmx, I can ...
6
votes
3answers
5k 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?
5
votes
6answers
7k views

Paging using REST/OData with SP 2013

I'm trying to do paging on a document library (also trying this on a list) with SP 2013 using REST/OData but I can't seem to get the skipping of items working. Here are some examples of URLs that I'm ...
5
votes
2answers
2k views

SharePoint 2013 REST display lookup fields?

I am using SharePoint 2013 REST to show data from my list, one of my field in announce list is AnnouncedBy which is a user packer field or is a lookup field how can I display it or get it using ...
5
votes
1answer
1k views

$inlinecount and $count missing in new OData API?

can anybody verify that in the new OData endpoint of SharePoint 2013 found at /_api/ does not implement the keywords $inlinecount and $count? ListData.svc has it implemented. Example: ...
4
votes
5answers
3k views

Folder creation in Document library using listdata.svc

Do you have any tips how can I create a new folder in a document library using listdata.svc (OData REST interface of SharePoint 2010) from JavaScript? SP creates a new file instead of a folder. I can ...
4
votes
1answer
892 views

Need help retrieving site column names using REST service call in SP 2013

I need to retrieve content types and accompanying site column names and fields. Does anyone know how to construct the REST notation to accomplish this? I have tried variations of: /lists/sitecontents ...
4
votes
1answer
3k views

REST API + Expand Recurring Calendar Events?

Is there a way using the REST API (through javascript) to expand recurring calendar items? Or is there a helpful client side utility to assist with this?
4
votes
1answer
809 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). ...
4
votes
2answers
3k views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
3
votes
4answers
10k views

How to group distinct values from a list using odata rest api

Hi I have a list with two fields "Regions" & "Countries" I am using a rest api to retrieve the list of just regions like so: ...
3
votes
1answer
113 views

Sharepoint REST Api OData Version?

Can anyone tell what is odata version used by SharePoint REST Api? I am asking because I tried to run the Nested Filter in Expand supported by OData V4. ...
3
votes
1answer
86 views

Getting item id from newly created item

I am using SharePoint 2013 Enterprise version. I am using below rest api code to add the record I kept below code in common js file function CreateListItemWithDetails(listName, webUrl, newItem, ...
3
votes
1answer
3k views

SharepointOnlineCredentials not working in an app

I want to authenticate against sharepoint online site using SharepointOnlineCredentials class. Below code works fine in a console application. But the same code is generating error when written in wcf ...
3
votes
1answer
577 views

How can I check files In using OData for SharePoint 2010?

I am uploading files to SharePoint 2010 following the answer here: Uploading files to Document Libraries using the REST API The issue is that all of the files are set as checked out due to some ...
3
votes
0answers
99 views

REST Api Filtered odata returning error: list view threshold

Why does the first query runs ok and the second throws list view threshold error? Note that it's a regular SP.ListTemplateType.tasksWithTimelineAndHierarchy List with Id and PercentComplete as ...
2
votes
2answers
6k views

Sharepoint REST API - Using caml query and select/expand to get lookup data

I have a Sharepoint app and I use a caml query to filter the data I get back: var caml = "<View><Query><Where><And><Contains><FieldRef Name='PublishingPageLayout' ...
2
votes
2answers
2k views

How to use jQuery and OData to expand multi user field in SharePoint 2013?

I am using jQuery to query a Sharepoint 2013 list and expanding the AssignedTo field (which is a Person or Group field type) in order to get the user id. I was able to get the code working when the ...
2
votes
1answer
36 views

Convert user id to user name in a single rest query that gets list items

So I get some items from a list via a rest query, and in the Creator field I get an ID. I want to display the name of the user and not the ID. Calling the GetUserByID isn't an option because it might ...
2
votes
1answer
156 views

Authenticating to Office 365 vNext with Multi-Factor Authentication enabled

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 ...
2
votes
1answer
137 views

Using NOT on REST date query

I am able to filter for items created on a specific date with the following query (using today [03-06-2015] as an example): "$filter=Created ge datetime'2015-03-06T05:00:00.000Z' and Created lt ...
2
votes
1answer
1k views

External Data Refresh failed - Unable to refresh list data in Excel Web Access WebPart

I have created a PivotChart in Excel workbook that fetches data from a SharePoint list using "OData Data Feed". When refreshing the connection in Excel 2013, the updated data is displayed in ...
2
votes
1answer
159 views

Sharepoint 2013 - OData Endpoint against External List - Supply Input Parameters

I have an external list in SharePoint 2013 that uses a filter (called idcode, say). I can supply the filter value in the "Modify View" UI of the site and it works as expected, but my ultimate aim ...
2
votes
1answer
2k views

How do I query the OData/REST API in 2013 effectively using JavaScript?

I want to use the improved OData/REST API in Sharepoint 2013 but it's hard to find good examples. As I see it, the OData-endpoint is of little use without a dedicated OData client library. With plain ...
2
votes
1answer
423 views

SP2010, Odata, anonymous access

Is anonymous access to listdata.svc possible? I'm trying to just simply get list items and display them using json but I either get asked to login or a 401 unauthorized. It's a claims based site ...
2
votes
0answers
173 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
1answer
655 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 ...
2
votes
1answer
238 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
0answers
235 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
2answers
3k views

REST API filter by month

I would like to filter a datetime field but I only want to filter MONTH var requestUri = "xxxx/getByTitle('Contact')/items?$select=CellPhone,mdate,ddate&$filter= Birthday ge '" + today + "'"; ...
1
vote
2answers
967 views

Get survey questions via Rest API

I am able to get all the fields in a survey using the web api url : _api/Web/Lists(guid'cecxc8b4-bbvc-472c-ae3f-d648bd0bb025')/Fields How ever I am not able to distinguish questions from the ...
1
vote
1answer
744 views

OData query in SPD workflow HTTP GET request

I'm building a 2013 workflow that uses an OData query in an HTTP GET request that is intended to return a list of items with titles that begin with a certain string (which has previously been recorded ...
1
vote
1answer
37 views

How can I retrieve data from excel workbooks stored in SharePoint

I am creating a workflow on SharePoint online using SharePoint designer. In it, I would like an action that retrieves the contents of cell(s) in excel workbook in a SharePoint document library. Please ...
1
vote
1answer
89 views

How to Connect SharePoint Online to SQL On Prem?

Has anyone successfully connected SharePoint Online or O365 to a SQL on prem server? If yes, a detailed how would be lovely.
1
vote
1answer
344 views

SharePoint 2013 OData $filter seems broken with date functions

I am using SP2013 SP1. I am trying to perform the following OData opertaion from a client app that contains an External Content Type. The ECT points to a ASP.Net OData service. My Javascript code in ...
1
vote
1answer
870 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
456 views

Error while connecting client.svc

I am trying to connect client.svc and getting below error "The server encountered an error processing the request. See server logs for more details." ULS is giving below two error, ...
1
vote
2answers
80 views

SharePoint 2010 REST URI won't return data for only some lists, why?

When creating lists in SharePoint, do you have to enable the REST service feature per list or something similar? I have one SharePoint list that returns data fine using REST, the URI is loosely as ...
1
vote
1answer
284 views

Item-level security possible with OData external content type?

I've created an External Content Type which uses an OData service as it source, and I created a content source in the Search Service Application in order to crawl this data. This works fine. However, ...
1
vote
1answer
1k views

403 Error connecting to ODATA via External Content Type with SharePoint

I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at ...
1
vote
0answers
17 views

How can I filter a REST query when the field's name is translated?

I have the following query : /_api/Web/Lists/GetByTitle('Discussions list')/Items?$filter=ContentType eq 'Discussion'" This works perfectly while my profile is set to English. When I'm set to ...
1
vote
1answer
38 views

Rest filter startswith(ContentTypeId,'0x0101') not working

This is driving me crazy, but I think it's an issue on my sharepoint online. Why the heck this is not working? /_api/web/lists/getByTitle('Documents')/items/?$filter=startswith(ContentTypeId, ...
1
vote
0answers
28 views

odata = verbose vs. select query options

I know that odata = verbose gets everything from the results in REST, and more data than necessary, but what's the use of the query option $select then if we're going to get everything when specifying ...
1
vote
1answer
13 views

Different result in OData Assignments

Based on this question: msdn forum (it's my question too) I got different result OData in Excel 2013 and Browser. Excel give more result than Browser. My app use result from Browser, so some data ...
1
vote
0answers
152 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 ...
1
vote
0answers
1k 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
3answers
1k 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 + ...
1
vote
1answer
546 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" ...