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
28 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
1answer
21 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!
1
vote
2answers
38 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 ...
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
25 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
51 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
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
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
138 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
1answer
202 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
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 ...
2
votes
1answer
57 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
57 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
53 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 ...
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
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('...
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 ...
0
votes
0answers
113 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
58 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
58 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
54 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
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 ...
0
votes
1answer
136 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 ...
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
100 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
106 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
143 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
538 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: /_api/web/lists/getbytitle('Sponsors')/items?$...
0
votes
2answers
733 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
212 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 Path:http:/...
0
votes
0answers
123 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
572 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 ...
3
votes
1answer
216 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
2answers
109 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 http://PC:2010/site/_vti_bin/listdata.svc/listName?$select=ThumbnailImage,Created,...
0
votes
1answer
284 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) { ...
1
vote
0answers
161 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 ...
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' ...
2
votes
1answer
153 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 ...
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
1answer
764 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 ...
0
votes
0answers
83 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
2k 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
378 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 ...