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
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
2answers
446 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 ...
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 ...
2
votes
1answer
654 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 ...
1
vote
1answer
36 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
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
1answer
544 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" ...
0
votes
1answer
27 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
1answer
507 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
655 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
429 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) ...
3
votes
0answers
95 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
0answers
172 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
234 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
16 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
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
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
0answers
376 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
201 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
24 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 ...
0
votes
0answers
26 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. ...
0
votes
0answers
13 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 ...
0
votes
0answers
63 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
17 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
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
25 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
34 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: ...
0
votes
0answers
36 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 ...
0
votes
0answers
84 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 ...
0
votes
0answers
38 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
0answers
51 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
44 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 ...
0
votes
0answers
62 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 ...
0
votes
0answers
88 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
118 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
162 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
113 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
1k 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
80 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 ...