Questions tagged [odata]

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.

Filter by
Sorted by
Tagged with
3
votes
2answers
11k 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 + "'"; ...
6
votes
5answers
25k 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: http:mysitename/_api/web/lists/getByTitle('TaxTool')/items?$select=...
5
votes
1answer
17k 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' ...
13
votes
6answers
20k 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 ...
9
votes
4answers
11k 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 ...
22
votes
4answers
49k 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?
6
votes
2answers
8k 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 ...
2
votes
1answer
3k 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
3answers
12k 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 ...
2
votes
3answers
4k 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. _api/Web/Lists(guid'id')/items?$select=Id,Author/ID&$expand=Author/ID&$filter=(...
7
votes
2answers
9k 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 ...
6
votes
6answers
5k 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 ...
3
votes
1answer
10k views

REST API Getting Fields from an Lookup List

I have a REST query that looks like this /_api/lists/getbytitle('MainList')/items?$select=Title,LookupField/Id,LookupField/Title&$expand=LookupField That works fine. But when I try to pull ...
4
votes
2answers
965 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 ...
1
vote
1answer
1k 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 ...
0
votes
1answer
1k 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 ...
5
votes
1answer
3k 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-...
4
votes
3answers
5k views

Sharepoint REST api - Recursively fetch all folders in a document library -

I have a set of folders say Folder1 containing Folder2 and Folder3. Folder3 contains Folder4, Folder5 and Folder6. When i use the OData expand parameter - $expand=Folders/Folders i get only details ...
1
vote
2answers
1k 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) { ...