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

2
votes
1answer
642 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
613 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 ...
1
vote
0answers
13 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
16 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. ...
1
vote
1answer
27 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
2answers
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 + "'"; ...
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
43 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
65 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
81 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
84 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
4answers
9k 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: ...
2
votes
1answer
34 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
19 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 ...
3
votes
1answer
77 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
32 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
11 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
281 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
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: ...
0
votes
0answers
47 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
16 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. ...
0
votes
0answers
10 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
24 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
27 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
141 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
34 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
518 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
73 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
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 ...
0
votes
0answers
35 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
6k 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
46 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
39 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 ...
6
votes
3answers
4k 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
2answers
355 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
61 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
248 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
846 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
83 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
802 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
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' ...
1
vote
1answer
83 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
81 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
113 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
371 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
149 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
110 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 ...