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
9 views

Error while connecting client.svc

I am trying to connect client.svc and getting below error "The server encountered an error processing the request. See server logs for more details." ULS is giving below two error, ...
0
votes
0answers
25 views

Can't create list item on Sharepoint Online (Office 365) from localhost

I created sharepoint hosted app in Office 365 and I use localhost HTML files to execute some Odata REST queries (I'm logged into Sharepoint online during execution). Read queries working fine, but ...
1
vote
1answer
68 views

Need help retrieving site column names using REST service call in SP 2013

I need to retrieve content types and accompanying site column names and fields. Does anyone know how to construct the REST notation to accomplish this? I have tried variations of: /lists/sitecontents ...
0
votes
1answer
164 views

Can local SQL Server data be made available in SharePoint Online

We have a SharePoint Online account and local data in a SQL Server instance. The data from the SQL Server is available as an OData feed in SharePoint and can be worked with in Excel Power Query. We ...
0
votes
0answers
48 views

Sharepoint 2010 OData query User Name and Group Name instead of User ID and Group ID

please help, how it is possible to query OData list to retrieve User Name and Group Name instead of User ID and Group ID through Microsoft Data Feed Provider for Power Pivot? What property should be ...
0
votes
1answer
53 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
2answers
43 views

SharePoint 2010 REST URI won't return data for only some lists, why?

When creating lists in SharePoint, do you have to enable the REST service feature per list or something similar? I have one SharePoint list that returns data fine using REST, the URI is loosely as ...
3
votes
2answers
380 views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
2
votes
1answer
94 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 ...
0
votes
1answer
31 views

where are foreign lists and how to query them?

I use REST/JSON to query Sharepoint 2013 where "expand" helps me to retrieve the authors name from a foreign list. .../_api/lists/getbytitle('list1')/items?$select=*,Author/Title&$expand=Author ...
0
votes
2answers
937 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: ...
0
votes
2answers
274 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
69 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 ...
1
vote
2answers
173 views

Get survey questions via Rest API

I am able to get all the fields in a survey using the web api url : _api/Web/Lists(guid'cecxc8b4-bbvc-472c-ae3f-d648bd0bb025')/Fields How ever I am not able to distinguish questions from the ...
0
votes
0answers
100 views

Using $expand with BCS External List via REST call

Is it possible to use the $expand odata keyword to expand a child (associated) entity from BCS within an external list using the REST API. Eg to get the country name from querying the customers list ...
3
votes
0answers
203 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: ...
1
vote
1answer
144 views

OData query in SPD workflow HTTP GET request

I'm building a 2013 workflow that uses an OData query in an HTTP GET request that is intended to return a list of items with titles that begin with a certain string (which has previously been recorded ...
2
votes
1answer
717 views

SharepointOnlineCredentials not working in an app

I want to authenticate against sharepoint online site using SharepointOnlineCredentials class. Below code works fine in a console application. But the same code is generating error when written in wcf ...
0
votes
0answers
58 views

REST/OData SharePoint 2013 Security

I wanted to know is ODATA API is secure from injection. I am asking this question as I am using ODATA extensively on my Internet facing website. Kindly give me experience answer and also give me some ...
0
votes
1answer
1k views

How do I update a list item using REST and Data.js?

I want to write a simple SP hosted app that edits a single list item in a list in the app web. Getting the list item collection is fine. Then I want to pass the result to a function that changes the ...
1
vote
0answers
124 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
1answer
119 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, ...
0
votes
0answers
30 views

how to use association when creating a new item using BCS Object Model and OData

I have an odata service that exposes two collections: customer and orders. So I have this example: http://spabcd.net/customer('1')/Orders How can I create a new customer and associate new orders to ...
0
votes
1answer
193 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) ...
1
vote
0answers
110 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
1answer
114 views

SPO CSOM Development without installing SharePoint 2013 on my Development Client or even On-Prem

We have this simple requirement. Using Data in an existing SharePoint Custom List on SPO 2013. We need to develop a simple wildcard/partial string search across mutiple columns and display matching ...
2
votes
1answer
1k views

How do I query the OData/REST API in 2013 effectively using JavaScript?

I want to use the improved OData/REST API in Sharepoint 2013 but it's hard to find good examples. As I see it, the OData-endpoint is of little use without a dedicated OData client library. With plain ...
0
votes
3answers
2k 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 ...
2
votes
4answers
768 views

Folder creation in Document library using listdata.svc

Do you have any tips how can I create a new folder in a document library using listdata.svc (OData REST interface of SharePoint 2010) from JavaScript? SP creates a new file instead of a folder. I can ...
2
votes
1answer
480 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). ...
7
votes
2answers
3k views

SharePoint 2013 and anonymous access problem

We run into following problem: We have application, that makes authenticated calls to sharepoint 2013 REST services (PUT and GET). Everything works well, when anonymous access is turned off. But we ...
2
votes
0answers
113 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 ...
0
votes
1answer
534 views

403 Error connecting to ODATA via External Content Type with SharePoint

I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at ...
0
votes
1answer
304 views

External content type based on OData is invisible in SPD2013 (but visible in a web browser)

I am trying to connect external list based on OData to Outlook, I could create it, but can't map its fields to Office Item type because it is invisible in SPD2013. I made screenshots of all the steps ...
0
votes
1answer
595 views

External content type based on OData is invisible in SPD2013 (but visible in a web browser)

I am trying to connect external list based on OData to Outlook, I could create it, but can't map its fields to Office Item type because it is invisible in SPD2013. I made screenshots of all the steps ...
1
vote
1answer
255 views

How can I check files In using OData for SharePoint 2010?

I am uploading files to SharePoint 2010 following the answer here: Uploading files to Document Libraries using the REST API The issue is that all of the files are set as checked out due to some ...
0
votes
2answers
2k views

Public facing website with SharePoint 2013

I'm just getting started with Sharepoint and my assignment is to create a public facing website based on Sharepoint 2013. If I get it correctly, the new way of buildning things in 2013 is the app ...
2
votes
3answers
2k 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 ...
2
votes
1answer
359 views

SP2010, Odata, anonymous access

Is anonymous access to listdata.svc possible? I'm trying to just simply get list items and display them using json but I either get asked to login or a 401 unauthorized. It's a claims based site ...
3
votes
1answer
1k views

REST API + Expand Recurring Calendar Events?

Is there a way using the REST API (through javascript) to expand recurring calendar items? Or is there a helpful client side utility to assist with this?
4
votes
2answers
2k 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 ...