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
16 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) { ...
0
votes
0answers
21 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
1answer
193 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' ...
0
votes
0answers
41 views

Sharepoint 2013 Document Library Excel oData Data Retrive issue

I am trying to retrieve data from SharePoint Document library to excel using oData Data Feed. My Document library name is "2015" and it have one choice field. I am getting the following error when I ...
0
votes
0answers
26 views

SharePoint oData expand not working when Associated multiselect Item is in a folder

We have Event and it contains Meetings and below oData Query was working fine. _vti_bin/ListData.svc/Events(22)?$select=Meetings&$expand=Meetings As soon as we associate a Meetings that is ...
3
votes
1answer
63 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
27 views

Sharepoint 2010 listdata.svc returning HTTP status 403

I am attempting to connect to a Sharepoint site using the Data Service endpoint of the form http://sitepath/_vti_bin/listdata.svc. I always get an HTTP 403 status which I checked using Fiddler. Based ...
0
votes
0answers
183 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
117 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
0answers
45 views

Excel PowerQuery say “The User was not authorized” , when i am trying connect to a sharpoint list that I have full control permisson for it

When I am trying to connect to a sharpoint2010 list -that I have full control permisson for it-, with OData feed connection , Excel PowerQuery say "The User was not authorized" . I work in a windows ...
0
votes
0answers
16 views

Cannot see some SharePoint data feed because of user rights, that is wrong!

I try to see 2 list data feed with same user rights that are in same SharePoint 2010 site via browser by some url like this "http://SiteURL/_vti_bin/listdata.svc/ListName . One is ok but the another ...
0
votes
0answers
40 views

BCS OData navigation properties are not shown in SharePoint Hosted App external list

I have created a WCF Data Service that is hosted on Azure. I use this service as the data source for my SharePoint Hosted App's external lists. I noticed I was missing all navigation properties from ...
0
votes
0answers
32 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
114 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 ...
0
votes
0answers
14 views

Set App External Content Type Connection Settings to OData Service Endpoint During Deployment

Is there anyway I can set the connection settings for the apps external content type during deployment/activation. The OData endpoint is hardcoded in the ECT file to my dev environment. Is there a ...
0
votes
1answer
118 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 ...
0
votes
0answers
41 views

How to read Odata service(created for SAP LOB) response which is a entity query set and expects filter parameters, in SharePoint BCS code?

I am performing DUET development where in the requirement is to read collection of data(attachments in SAP) is published over OData service by Gateway development. It is filtering based on 3 ...
0
votes
2answers
339 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 + ...
2
votes
2answers
688 views

How to use jQuery and OData to expand multi user field in SharePoint 2013?

I am using jQuery to query a Sharepoint 2013 list and expanding the AssignedTo field (which is a Person or Group field type) in order to get the user id. I was able to get the code working when the ...
2
votes
1answer
589 views

External Data Refresh failed - Unable to refresh list data in Excel Web Access WebPart

I have created a PivotChart in Excel workbook that fetches data from a SharePoint list using "OData Data Feed". When refreshing the connection in Excel 2013, the updated data is displayed in ...
0
votes
1answer
776 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 + "'"; ...
4
votes
2answers
303 views

SharePoint 2013 REST display lookup fields?

I am using SharePoint 2013 REST to show data from my list, one of my field in announce list is AnnouncedBy which is a user packer field or is a lookup field how can I display it or get it using ...
1
vote
1answer
111 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" ...
1
vote
1answer
73 views

Sharepoint 2013 - OData Endpoint against External List - Supply Input Parameters

I have an external list in SharePoint 2013 that uses a filter (called idcode, say). I can supply the filter value in the "Modify View" UI of the site and it works as expected, but my ultimate aim ...
2
votes
0answers
67 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 ...
0
votes
2answers
200 views

How to use SharePoint 2013 REST service to retrieve data from lookup field

I have two lists: 'Company' and 'Customer'. In 'Customer', I have an auto look up field called 'parent'. Then I tried to use Rest to retrieve data from customer like this: ...
1
vote
1answer
125 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 ...
3
votes
0answers
100 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 ...
0
votes
0answers
31 views

How to retrieve Listdata from a View via listdata.svc?

I'm using (http://name_of_server/_vti_bin/listdata.svc/Name_of_list) to retrieve data via an ODATA connection. How can I set this up to select only the data displayed on a specific view from the ...
1
vote
1answer
470 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
375 views

Expand nested property in one Rest url call

Say you have a Site named https://beyondhard.sharepoint.com/sites/TestPrivate in the SharePoint Online. I tried the url ...
1
vote
1answer
443 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
1answer
171 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
72 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 ...
2
votes
1answer
299 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
3answers
2k 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
62 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
700 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
52 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 ...
4
votes
2answers
1k 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
164 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
41 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
3answers
4k 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
873 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
1answer
143 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
477 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 ...
5
votes
1answer
643 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
429 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
2k 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
1answer
2k 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 ...