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
0answers
8 views

Giving Sharepoint add-in “Single Project” read or write permissions breaks queries?

I'm working on a Project Online add-in thats supposed to be able to read and edit projects and tasks. If I have the following permissions settings: "Status updates(Project server) - SubmitStatus" ...
0
votes
3answers
2k views

The field 'Author' of type 'User' cannot be used in the query filter expression

I was making a rest api call with Odata filter author/id. I want to get survey responses of a particular user. ...
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 + ...
0
votes
0answers
7 views

Business Intelligence - Pivot Chart refresh not saving

I have created a SharePoint list and added fake information about TV sales in Australia, I then created a excel document that connects to the list using OData. I have created pivot charts and ...
0
votes
0answers
17 views

Reading and expanding a foreign key value from an expanded list in SharePoint

I have a the following lists in my site: Staff - has staff details and a department foreign key Departments - has department details Project Tasks - has a number of tasks Department Tasks - has ...
0
votes
0answers
11 views

listdata.svc substringof oddities

I have been working on a tool which uses listdata.svc extensively and uses a lot of queries using the substringof operator. Originally I was creating filters in the manner: ...
2
votes
1answer
102 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 ...
0
votes
0answers
25 views

Exception when connecting to ODATA (Reporting Data) 403 Forbidden

We are trying to connect to ODATA SharePoint service in our windows service but it gives us Error 403 : Forbidden. The same as when we try to connect to it by adding a service reference, below is a ...
1
vote
1answer
572 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 ...
1
vote
2answers
413 views

How to do a Filter in a BCS External Data picker

I am using an OData web service with BCS (testing with Northwind) and I would like to define some filters when using the External Data picker. I'd like to be able to have a drop down that then ...
0
votes
0answers
38 views

Improving performance of a OData REST API call on a large document library

I have a requirement that requires that we use a built URL leveraging the REST API for our SharePoint 2013 site on a document library with many (about 800,000) documents. The format of the URL is ...
6
votes
3answers
5k 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 ...
1
vote
0answers
20 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 ...
0
votes
0answers
24 views

Can SSIS OData results return all records in list?

I have an OData source that is set to return the top 500 items of a list. I want to be able to return all records even if list exceeds 500 items. Can this be done in SSIS? If so, how would I go about ...
0
votes
4answers
5k views

How can I filter a list with ODATA for Person or Group Field?

I recently start working with ODATA in SharePoint 2013 and I have a list with the following fields: Employee : Person or Group ChildName : Text Let's say, I want to get all children of "Ray", How ...
0
votes
0answers
31 views

$expand on Lookup field without referential integrity

I have a query using the listservice where I'm trying to resolve a Lookup field - however not every row in the parent list has a row in the child list. If I run my query as below I just get a 'An ...
0
votes
0answers
27 views

Project Server 2013 CSOM cannot change ProjectData page size for specific EntitySet

I am trying to increase the default page sizes so that I can get 500 results instead of 200 results when showing ResourceTimephasedDataSet entries. I am having trouble setting the correct setting in ...
5
votes
3answers
2k 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?
1
vote
1answer
2k 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 + "'"; ...
0
votes
2answers
173 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
0answers
40 views

SharePoint Online OData Now() Function?

I am using Excel OData external data cocnnection to retrive data from SharePoint Online. I would like to filter this data so I only retrieve list items with a create date that is up to 7 days earlier ...
7
votes
1answer
230 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 ...
1
vote
1answer
794 views

SharePoint 2013 Rest API OData Query

I am calling rest uri from jQuery ajax with filter string comparison startswith as below ...
0
votes
1answer
46 views

OData feed to SharePoint List

Is it possible to import/update data from an OData feed into a SharePoint list? Right now I'm using the feed with an excel file + webpart for display, but the ability to manage this on a SharePoint ...
4
votes
1answer
771 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
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 ...
2
votes
2answers
4k 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' ...
1
vote
1answer
75 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.
0
votes
0answers
66 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
85 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
1answer
249 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
0answers
104 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
96 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
1answer
393 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
2answers
71 views

rest query orderby takes null as 0

I am making an ajax call to get the list data in SharePoint 2010 I am using orderby to sort based on a column ...
0
votes
0answers
95 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
1answer
192 views

Cannot find resource for the request $batch Sharepoint server 2013

When i try to execute sample batch code in Sharepoint server 2013 i'm getting the error 'Cannot find resource for the request $batch' Int16 listRetrievalCount = 0; if (IsPostBack) { ...
2
votes
1answer
122 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 ...
1
vote
0answers
122 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
179 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
53 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
1answer
211 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 ...
0
votes
0answers
96 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
1answer
497 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 ...
5
votes
6answers
6k 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 ...
0
votes
0answers
742 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
65 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 ...
1
vote
0answers
965 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
1answer
283 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 ...
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: ...