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
1answer
14 views

Sharepoint 2010 List Lookup values in ODATA

It's a common case that you use lookups in your list. When using ODATA, Is it possible to include the actual value of the lookup instead of the (other) SharePoint list item ID?
0
votes
0answers
7 views

New oData Feed in PWA

Is there a way to create a new oData feed in PWA? I would like to build a new custom list that has similar properties to the issues/risk lists in that it would have its own oData feed. Thanks!
0
votes
2answers
716 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 ...
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
1answer
762 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 this to create app ...
6
votes
4answers
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 ...
3
votes
2answers
696 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
37 views

SharePoint 2013 custom list attachment link

I am creating custom form in jQuery and HTML5. I am using rest api for getting data. I am fetching attachment also and generating dynamic string with HTML code with jQuery. Every thing goes fine it ...
1
vote
1answer
50 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, '...
0
votes
1answer
38 views

Convert CAML queries to OData Filters

Is it possible to convert complex CAML query to OData filters so that I can use them in REST APIs? Some CAML queries have nested condition and multiple values to be passed in IN operator. Also, ...
0
votes
0answers
43 views

SharePoint REST ODATA Exception

When querying the ODATA service, every second query fails with the following SOAP exception (Unhandled exception encountered while forwarding ODATA request to the App Server): <error xmlns="http://...
1
vote
0answers
24 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 ...
0
votes
0answers
50 views

$expand field on a different site

I'm performing a rest call against a list on our subsite, but I can't expand one of the columns. The column is a lookup site column that gets it's value from a list at the root site level. http://...
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 + "'"; ...
0
votes
1answer
46 views

SharePoint Rest API and Javascript Issue

I am using SharePoint 2013 Enterprise. I have 3 List. Now I am creating custom form which fully in jQuery and javascript. From the 3 list, 2 list works as detail so I have two tables where we can add ...
0
votes
1answer
130 views

Uploading File with rest api and HTML5 api

I am using SharePoint 2013 on premise. I am trying to upload file to the custom list from custom webpart purely jQuery and javascript. In my form I have hyperlink, when I click on it, it will open ...
3
votes
0answers
120 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 ...
3
votes
1answer
196 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. http://www.odata.org/getting-started/basic-...
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: http:mysitename/_api/web/lists/getByTitle('TaxTool')/items?$select=...
2
votes
1answer
55 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 ...
-1
votes
1answer
54 views

Cannot find resource for the request AppTiles

I am working with Office 365 and using below service to get details of all AppTiles https://<site>/_api/Web/AppTiles So to get details of specific tile i am using below url https://<site&...
3
votes
1answer
108 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, ...
1
vote
1answer
51 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 ...
0
votes
0answers
14 views

oData external content type - how to implement Item-level security?

Any implementation ideas? Do I need to us VS for this? I have SP 2013, and have an external content type pointing to a SQL Server table. I would love to security trim the results - as a user can ...
1
vote
1answer
290 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, ...
5
votes
1answer
2k 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: /_api/web/...
0
votes
0answers
85 views

Not able to order by subfolders in the document library using REST API/ODATA

I am trying to query subfolders in a document library in a SharePoint Online site. My ODATA "orderby" query URL was working fine when I try to order by ID column. But when I try to order by another ...
0
votes
0answers
18 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. _api/Web/Lists(guid'id')/items?$select=Id,Author/ID&$expand=Author/ID&$filter=(...
0
votes
0answers
11 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
33 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
45 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: $filter=substringof('...
2
votes
1answer
214 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
41 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
2answers
614 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
110 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 ...
1
vote
0answers
35 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
56 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
7k 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
57 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
52 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 ...
8
votes
3answers
6k 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
0answers
72 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 ...
8
votes
1answer
280 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
902 views

SharePoint 2013 Rest API OData Query

I am calling rest uri from jQuery ajax with filter string comparison startswith as below /_api/lists/getbytitle('Stations')/items?$select=Id,City_Code,City_Name_EN&$filter=startswith(City_Name_EN,...
0
votes
1answer
134 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
827 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
7k 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
99 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.