The REST (Representational State Transfer) interface in provides access to lists and libraries as a relational data service. A core concept of any RESTful interface is the resource, and in SharePoint Foundation, lists and items are represented as HTTP resources that can be addressed by remote URLs.

learn more… | top users | synonyms (1)

9
votes
3answers
2k views

How to avoid _metadata in a REST response (listData.svc)

I am pulling data from a SharePoint list with listData.svc, and _metadata represent more than half of the response content. Is there a way to return list fields only, without the metadata? Below an ...
6
votes
2answers
9k views

How to get lookup value only via REST (listdata.svc)

I am trying to retrieve a list of items including lookup fields via listdata.svc. My lookup points to a list of companies which has the following fields: Title, Address, Phone. By default, listdata ...
6
votes
3answers
4k views

Updating a Property w/ 2013 REST Api

I have a SharePoint Hosted App that is successfully able to add Read and Create files on the Host site (using the REST API and SP.RequestExecutor). Now I am trying to figure out how to update ...
14
votes
2answers
1k views

REST and CSOM much slower than List Web Service

lists.asmx = Web Service listdata.svc = REST API client.svc = CSOM Using JavaScript to query a list using the 3 available APIs, I'm finding lists.asmx responds much faster than listdata.svc or client....
8
votes
3answers
5k views

SharePoint 2013 Call the REST API from SharePoint hosted app

I've successfully deployed a SharePoint Hosted App to Office 365 and my local on premise installation. All the app aims to do is call the REST API for the user profile manager to get the profile ...
0
votes
1answer
49 views

Passing function argument in $.getScript() giving SP.RequestExecutor is not a constructor console error

Here is my code 'use strict'; var hostweburl; var appweburl; // Get the URLs for the app web the host web URL from the query string. $(document).ready(function () { //Get the URI decoded URLs....
0
votes
0answers
30 views

REST query not able to filter by FileRef, works in on-premise but not online

I have a REST query which works as it should in SharePoint 2013 on-premise, but not in SharePoint Online. The query is as follows (after encoding): https://<tenant>.sharepoint.com/projects/1/...
9
votes
2answers
8k views

SharePoint 2013 REST - Create list item with user field and lookup field

I'm trying to add an SPListItem to an SPList via REST, but have a problem with User or Group and Lookup (information already on this site). function adddullitem() { var item = { "...
0
votes
1answer
32 views

SharePoint Designer Workflow Create Subsite and Use Parent Top Navigation

We have a 2013 Designer Workflow for creating subsites which works fine. However we want to make it use the top navigation of the parent site. We're wondering if we can just include a keyword on the ...
1
vote
1answer
20 views

Edit permission using REST - get principalID?

I'm trying to update permissions on some items using REST in a workflow. I have that working perfectly fine, but I have one issue I didn't foresee when I started planning this setup. To set the ...
0
votes
0answers
20 views

Get image column as file using SharePoint REST Web API

I have one SharePoint 2013 custom list which contains one Image Upload column. Now I need to read all it's items using Rest Web API in web-services to display other place than SharePoint. Now when I ...
3
votes
1answer
52 views

call SharePoint 2013 REST WebServices from tsql stored procedure?

Can i call REST Web Service of SharePoint 2013 from tsql stored procedure ? All examples in web are for GET method, But i want create item in SharePoint list and i need to use POST method. this is ...
0
votes
2answers
39 views

CSOM or JSOM or REST for new SPS developers

I want to get in to SPS development space and currently I`m more of a person who uses OOTB and aware of SharePoint Administration side. Therefore would like which is the Programming model that I ...
0
votes
2answers
53 views

Filter Conditon in Rest API query Not Working

Here ESI_ProjectSeqNoLookup/Id is a Lookup Column so expand used and filter ESI_AFENo type is Hyperlink or Picture. This query is not working. query.RestQuery = "getbytitle('RFA')/Items?$select=ID,...
0
votes
1answer
30 views

Filter Condition in Rest API query with passing textbox value

The below mentioned query is correct or not because i am not getting the textbox values. #txtAFENo. It is textbox id , passing directly the textbox value. query.RestQuery = "getbytitle('RFA')/Items?$...
0
votes
0answers
16 views

Sharepoint List REST API - How to include original results with lookup data?

I recently constructed an AJAX call to a list within a SharePoint site which used the following REST end point. (Sensitive information stripped.) (site)/_api/web/lists/getbytitle('orgList')/items?$...
0
votes
2answers
46 views

SharePoint 2013 get full file name including extension

Wondering if anyone can help me please, I have a media library with a number of videos in and I want to get the full file name including the extension out of the library, I have so far tried using ...
0
votes
1answer
35 views

Issue in Get List named With contains # using Rest Service API [duplicate]

I have a List named 'KKR Jobs #'. And I am try to Get that list in my Sharepoint Hosted App Using Rest Service Call Like var lName = 'KKR Jobs #'; executor.executeAsync( { url: ...
1
vote
1answer
40 views

Filter conditions in rest api query SPO

The below REST-URL I used to get the data from lists using filter isn't working. Any ideas? query.RestQuery = "getbytitle('RFA')/Items?$select=ESI_ProjectSeqNoLookupId&$filter=...
0
votes
1answer
72 views

REST Service API executor.executeAsync Call Ends in Failure Function in Sharepoint Hosted App

Any Answers Will Help me to Forward and Gain Knowledge in SharePoint Development While i am Trying to get the list Items Using Rest API Calls in SharePoint Hosted App Using Below Function function ...
0
votes
2answers
20 views

How to connect non-sharepoint site to create items in SharePoint (both on same machine)

Scenario: I've created a custom list 'TestList' in SharePoint On this same server, I created a simple (non-SharePoint) website in pure HTML Please how can I connect the form on this (non-...
1
vote
1answer
100 views

Sharepoint REST API calls returning 404 not found

We are trying to access SharePoint REST APIs, each call to them returns with 404 NOT Found error. We tried to check https://sitename/_api/contextInfo, there was again 404 error in response. We are ...
4
votes
1answer
11k views

Properties when uploading Files using REST in SP 2013

After a lot of research I finally got uploads via REST working in SharePoint 2013. But I would like to provide additional properties to the Add Function like Title. This code works so far but the only ...
0
votes
2answers
59 views

Display Profile Image, Can't Select Picture Url

I am attempting to retrieve some profile properties for the current user, and am having a hard time with the profile picture Url specifically. Version is Sharepoint Foundation 2013. When I open the ...
1
vote
2answers
124 views

Getting the List from Sharepoint online using Rest Api in java

I want to use the REST API for getting the list as mentioned in Complete basic operations using SharePoint 2013 REST endpoints When I am trying to call https://siteurl/_api/web/lists in the rest ...
0
votes
1answer
41 views

Adding blog post item category with REST API Sharepoint 2013

I want to insert a billet item list with related category ID in REST API Sharepoint. I proceeded as follows: POST /_api/lists/getbytitle('Billets')/items { "__metadata": { "type": "SP.Data....
0
votes
0answers
55 views

Copy list item value to another in SharePoint using REST API

I am trying to auto increment a value for a specific column in SharePoint list. How to copy list item ID value to another column of of a SharePoint list (e.g ProjectID). I tried this code '...
2
votes
4answers
16k views

How to select and filter list items lookup column with Sharepoint 2013 REST Feature?

I am using SharePoint 2013 REST. I have list which contains many look up columns, I can get list items through list if they are not look up columns but I can't select and also filter based on look up ...
1
vote
1answer
45 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
36 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
2answers
98 views

Sharepoint 2010 Rest api can not get RichTextField content

I am using the Sharepoint 2010 rest api to get data of a custom content type item in "Pages" folder. The data is returned but I can not find the content of a custom RichTextField column. Is there any ...
0
votes
1answer
697 views

Update metadata column using Java REST

As I understand, you have to make a 3 steps to update the metadata on the file. I have uploaded a file to my document library using POST and after that made a GET and took out the metadata i need to ...
0
votes
0answers
38 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://...
0
votes
1answer
31 views

SharePoint Rest API Problem

I am using Rest API in an a web application using JavaScript, JQuery, and HTML and I'm having issues with pulling phone numbers. I have 3 phone number fields and they all show similar to this <d:...
-2
votes
3answers
1k views

Why not use Sharepoint 2013 as just a backend for REST / CSOM clients?

This might sound a bit extreme, but now that REST / CSOM API's are more fully featured, why not just write web apps in whatever framework you're comfortable with and utilize the REST / CSOM API's ...
0
votes
1answer
61 views

SharePoint Online REST: Get User Profile Properties in 2013 Workflow

I'm looking for some help with a REST call I'm attempting to make in SharePoint Designer 2013 Workflow. The site is on SharePoint Online. The call is to get info related to a specific user account. ...
3
votes
1answer
91 views

How to associate an existing site column to a list using the REST API

In SharePoint 2013, I have a site column that already exists and I'm trying to associate it to an existing list using the REST API. I found examples on adding a new column to a list using the REST API ...
0
votes
2answers
136 views

Access Sharepoint 2013 List using REST Web Api

We have Intranet in our organization in which we have one list called announcement which also consist one custom column. Now I want to read that list data using rest api for mobile app of our ...
0
votes
0answers
21 views

Unable to get property 'results' of undefined or null reference [duplicate]

function onSuccess(data){ var title, department = null; $.each(data.d.results, function(index, item){ try{ title = item.Title; ...
0
votes
1answer
43 views

Sharepoint 2013 REST Retrieve list info presave items

I have successfully retrieved a specific item using REST with SP2013. Issue is that value is populated AFTER page load hence I cannot do a comparison on PreSave event. It shows as undefined and later ...
0
votes
1answer
49 views

Can't get filename of document with REST api/CAML query

Using the rest api to retrieve information about my documents. The documents use managed metadata which isn't expanded correctly when using the stand REST api. So I found this fix which uses REST with ...
1
vote
2answers
1k views

REST - get custom user profile property - on premise - Infopath

I want to retrieve a custom field from the user profile property with rest. The property is searchable in search. Name of the custom properties "CompanyNumber" But when I try to use http://...
4
votes
2answers
2k views

How to get custom user profile properties in sharepoint 2013 restful api?

In my Sp2013, I tried this link http://mysite/_api/SP.UserProfiles.PeopleManager/GetMyProperties and it gets all properties including the custom managed ones from crawling. And one of them is ...
0
votes
0answers
13 views

Workflow Loop not running through whole array

I'm having trouble with looping through an array (dictionary) in my SP 2013 Workflow. The workflow calls the HTTP web service to get an item from a list. THis list has a people column with multiple ...
0
votes
0answers
52 views

Sharepoint REST Api in Java: Unable to access site documents

I am trying to access sharepoint site documents using SP REST API in java. I am able to authenticate and get a response for the below URL http://sharepoint_server_url/_api/lists/getbytitle('Documents'...
2
votes
1answer
61 views

How do you create a new document in a Sharepoint Document library based on an existing content type using REST?

I have a document library with a content type called 'Letter' attached to it. The 'Letter' content type has a MS Word document template attached to it. I would like to know how, using REST, to create ...
3
votes
0answers
33 views

Get REST RequestDigest on new (First Release) Library View page

There is hardly anything left in the new (First Release) Document Library View, No SP Object, NO JSOM and no more DOM element with the FormDigest we need to do REST, so all code with: document....
0
votes
0answers
42 views

Why “The property '__deferred' does not exist on type 'SP.SecurableObject'” message appears when trying to update a sharepoint list item?

I know that updating an item in sharepoint list by using REST API should be very easy, but for some reason, I have not been able to do it. I keep getting "400 Bad Request: The property '__deferred' ...
0
votes
0answers
24 views

How do I get the linked to title field in a rest call?

How do I get the linked to title field in a rest call? Also, will there be an additional step if this field is on another list? I've already expanded and included the specific field in my current ...
0
votes
2answers
45 views

How to retrieve image description using REST API to use in a webpart?

I want to create a Webpart as image slider which contains the images from an image gallery. I want to show each image's description under it in the image slider. But have some problems regarding that: ...