Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [rest]

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.

0
votes
2answers
23 views

REST API filter/select

I have a list in SP 2013 with 4 Columns Date Created -- Country -- Price in US Dollars -- Modified After a bunch of help from the community I have created a Rest API for this list, but now i'm ...
0
votes
1answer
14 views

Successful API build, but now what [on hold]

So I am pretty much self taught on SharePoint and have just recently built a Rest API off one of my lists. Now say I wanted to ingest that API into a program like power BI? is that possible? I guess ...
2
votes
2answers
17 views

SharePoint Online getFileByServerRelativeUrl with Editor not working

I am trying to get the 'Editor/Name' using REST however this does not appear to be working. My current REST url is formed as follows: https://tenant.sharepoint.com/sites/sitecollection/_api/web/...
0
votes
2answers
30 views

SharePoint Custom Webpage/Part Not Consistently Loading

I hope this is the right place I have been in a role within my organization working with SharePoint for a couple of months now, so i'm a newb more or less. I have some experience (again a novice) ...
0
votes
0answers
15 views

Loading _Sys_Nav_HoverText with REST

I'm building a SharePoint 2016 app with a custom site map menu that utilizes the site's managed navigation. How do I retrieve the "Navigation Hover Text" value? I'm using the REST API to retrieve the ...
0
votes
2answers
19 views

SharePoint 2013 Rest API (targeting specific columns)

Very new to SharePoint Rest API's, I got the rest to work filtering the first Column but now I am running into issues with showing the multiple columns for example. I am trying to filter out the ...
0
votes
0answers
21 views

Correctly getting a Wiki Page's content with REST API

According to a reply in this post, I can get a Wiki page's content by extracting the WikiField field from the response of GET https://<site-url>/_api/Lists(guid'<list-id>')/Items(<item-...
0
votes
0answers
14 views

Fetching employee details from master list based on employee name selection

i have a small requirement which can be fulfilled by REST but i am not that good in REST. so i have List A (Master List) and List B (Vacation Form). List A contains Employee name , Managers Name , ...
0
votes
2answers
34 views

Access all files in different folders using REST API

I have four folders, is it possible to access them and get all the files? I already tried this: jQuery.ajax({ url: "https://test.sharepoint.com/sites/test/Negocio/Precario/_api/Web/...
0
votes
0answers
21 views

Microsoft Graph/Sharepoint API search

The Graph API isn't well documented about a few things, and so I was wondering if anyone had some insight, or direct answers to the following problem: Background I am attempting to create a RESTful ...
0
votes
0answers
8 views

How to save to a richtext column using TinyMCE

I'm trying to make a custom form using js and TinyMCE, and the problem I have is that all of the rich text is saved, except the images, when I check the list, the html is saved like this <img alt=...
0
votes
1answer
23 views

Can I use elevated permissions using JSOM, CSOM, or REST?

I am working with an On-Premise SharePoint 2016 farm and I am looking for some way to elevate permissions, so I don't use the logged-in user's credentials but another set of permissions that the ...
0
votes
1answer
52 views

403 FORBIDDEN error while trying to insert an item in a SharePoint list

Hi I am trying to insert a list item in a SharePoint list by using REST api. I am getting an error as: { "readyState": 4, "responseText": "{\"error\":{\"code\":\"-2130575251, Microsoft....
0
votes
2answers
34 views

Get value from Column and cut the duplicates using SharePoint Rest API

I've multiple folders inside the pages library Within each folder I have pages Grupo de produtos is of type taxonomy. I run the function GetPagesProd and for each item I get the value from Grupo de ...
0
votes
1answer
19 views

Getting link from lookup document library

I have created a Lookup field linked to the document library which allows multiple files. I am able to get the Title of the linked documents, but I can't find a way to get the url? How can this be ...
0
votes
0answers
19 views

Replacing the SSIS Sharepoint List Source

Hi I've been trying at this now for a day or so but it's proving really difficult. I've got a basic SSIS package which essentially queries some sharepoint lists (lists with files) and drags out the ...
0
votes
1answer
18 views

Azure Sharepoint Application API Key generation

Introduction I'm not a Sharepoint developer. I'm attempting to build an API from a php application to talk to the file storage within a Sharepoint site. From what I can The RESTful API makes the most ...
0
votes
1answer
44 views

Authentication to SharePoint using secure authentication and CSOM in a .NET application

I'm using CSOM for making REST API calls to a SharePoint list from a C# application. This needs credentials (of course), however I've found that it needs a username and a password in plain text. ...
1
vote
1answer
28 views

PnPjs alternatives for .NET

For developing with the SharePoint REST APIs using JavaScript I always use PnPjs because it's an easy way of getting data from SP. PnPjs is a collection of fluent libraries for consuming SharePoint,...
0
votes
0answers
18 views

Sharepoint Multilookup Empty Field

I'm facing an issue with a multi lookup field while doing a REST API call using pnp-js. So I have this list (let's call it A) that looks up into another list (let's call it B) using a lookup field (...
0
votes
0answers
12 views

Unmodifiable list properties for specific list templates (ex: EnableVersioning for survey lists)

Although the REST API documents says that EnableVersioning is readable and writable, I was unable to set a survey list's EnableVersioning by POSTing or PATCHing it, and according to this stackoverflow ...
0
votes
2answers
39 views

Get folders from list using SharePoint Rest API

I allowed the creation of folders in the list, and the content type "DinamicoFolder" is of type folder. I have multiple folders inside the folder "Contas à Ordem" URL: https://test.sharepoint.com/...
0
votes
0answers
24 views

Date shifted one day when creating all day event with the REST API

When creating an all day event by POSTing a new item: { "odata.type": "<odata-type>", "FileSystemObjectType": 0, "Title": "alldayevent", "EventDate": "2019-02-25T00:00:00Z", ...
0
votes
0answers
20 views

Get user properties of external / guest user in sharepoint online using REST

is there any way to get user properties of external / guest user in SharePoint online with REST? I am using the _api/SP.UserProfiles.PeopleManager/GetMyProperties endpoint to retrieve the user ...
0
votes
1answer
13 views

Sort by RefinableInt using SharePoint Rest API

I've this code below: https://test.sharepoint.com/sites/test/Negocio/OfertaParticulares/_api/web/folders('Dinamico')/folders('55')/folders('Contas%20%C3%A0%20Ordem')/folders?$select=ID,Title,Created,...
0
votes
0answers
17 views

Create a folder with custom content type

I manage to create a folder with in sharepoint online using REST API but the problem is I need to use a custom content type for the folder. I saw this article How to create folder with custom Content ...
0
votes
1answer
13 views

Rest API Documentation - getChanges query options

Where can I find all available query options for getChanges? /_api/site/getchanges(@qry)?@qry={} I know I can query using {"Add":true,"Web":true} but I'd like to know all properties I can specify.
0
votes
1answer
28 views

Accessing Terms in Folder using SharePoint Rest API

I created a content type of type folder and I added two taxonomy fields, as you can see. I'm trying to access the fields Tag and Grupo de produtos, I already tried this code below: https://test....
0
votes
1answer
20 views

Unable to update InformationRightsManagementSettings using REST

The following request returns Status 204, indicating it was a success but the informationrights settings hasn't become updated when I take a look the IRM-settings in the web gui for the list. The ...
0
votes
2answers
43 views

Sharepoint Server 2013 REST API returns 401 by calling 'FieldValuesAsHtml' in anonymous access

I've followed the steps from the following answer: sharepoint 2013 anonymous 401 UNAUTHORIZED1 However, it works partially for me. The REST calls works when I try to access basic information from any ...
0
votes
2answers
44 views

Export SharePoint online list to Excel

I know there is an OOTB functionality to export list into .iqy file that can be opened in Excel. But here we want to export the list using JSOM/REST to a file which has .xls format. I have gone ...
0
votes
1answer
72 views

Updating a list item via Invoke-RestMethod

I am at my wits end with this one. I am unable to modify an list item remotely via a REST request. Can anyone see what I am doing wrong here? I am getting at 403 Forbidden response from SharePoint ...
0
votes
0answers
18 views

build a test sharepoint server 2013 which mimic the live server

I am working on a new project for our customer who have sharepoint 2013 Enterprise server. and our customer has only a live server. so i want as a first step to do the following:- create a new VM ...
0
votes
0answers
19 views

Filter File types from Folders/Files

I am able to pull in the data I need with using part of this sEndPoint Main folder I'm pulling from: https://company.sharepoint/sites/Site/_api/Web/GetFolderByServerRelativeUrl('Folder Name')? ...
1
vote
1answer
54 views

Export multiple lists into a single CSV file

I have a requirement to fetch 2 large lists and merge data into a single CSV file. Suppose Lists are as below : List A Column1 Data1 Data2 List B Column2 Data3 Data4 Then Data should be displayed ...
0
votes
0answers
27 views

Sharepoint Online REST: Automatic Index Management

Is it possible to get and/or set if a list's Automatic Index Management is enabled with the REST API? I don't see it in the REST and CSOM APIs' SP.List documents, and I don't see it in a list's root ...
0
votes
0answers
24 views

Retrieve a SharePoint List with Angular JS

I have created an Angular JS application which would output a list of data in a Share Point list. I am trying to make a rest API call to my Share Point List to get the data, however I am unable to do ...
0
votes
2answers
51 views

Column permission to edit the data for a specific SharePoint group

We have one list in SharePoint Online in which there are certain records. There is one column whose data should be visible to all users,but should not be edited by all the users, it should be enabled ...
0
votes
2answers
116 views

How to get version history of item using REST

Very new to SharePoint so I am sure this is a newbie question... I did look at the forums. Here is the command I am using: https://Server/Site/_api/lists/getbytitle('Equipment%20and%20Inventory')/...
0
votes
1answer
46 views

Sharepoint Online REST: Lists' Enable audience targeting setting

Is it possible to get and/or set the List Settings > Audience targeting settings > Enable audience targeting on or off with the Sharepoint REST API? I've tried checking the GET <web-url>/...
2
votes
1answer
50 views

SharePoint 2013 rest API get the average of calculated column

I have a calculated column for ticket response time Want to get the average response time for all tickets average response time = (sum of #response time)/ #of tickets call: https://siteurl/_api/web/...
0
votes
1answer
32 views

REST API filter by a “BusinessData” field

I have a query that brings the contents of a list based on a query like this: https://myserver.com/LibraryABC/_api/lists/getbytitle('MyList')/items?$select=*,FileLeafRef&$filter=(MyField eq '...
0
votes
1answer
38 views

Search/REST API only showing all results to Farm admin

I want to retrieve all the library items of a content type "Prod Request". I am using REST API. Here is my query: $.ajax({ url: https://mysite.domain.com/_api/search/query?...
0
votes
0answers
36 views

Starting SharePoint 2013 workflow using REST from another workflow fails the first time but works on retry

I have two SP 2013 workflows. One (WF1) does a number of things, but at the end of WF1, I'm calling another SP 2013 workflow (WF2) using REST. WF1 runs both on create and change and conditionally ...
1
vote
1answer
41 views

How to get all checked out files and when they were checked out

Trying to figure out a way to use REST or JSOM to find all checkedout files in a library. I can use a list view to show which files are checked out and by whom, but there is no way to see how long ago ...
1
vote
0answers
30 views

SharePoint form digest response 404 using java REST api

I am Using apache Http Client for connecting sharepoint using rest api. code snippet is as below: HttpClient client = HttpClientBuilder.create().build(); String baseurl = messages.getString("baseurl"...
2
votes
1answer
55 views

Update Excel/CSV file from List

I have a requirement in which suppose if someone adds an item in List, item details should be automatically updated to Excel/Csv file which has same column names as list. This Excel/csv file can be ...
1
vote
0answers
109 views

How to use external API in sharepoint online or in SPFX?

I am trying to integrate the Microsoft Translator Text API to a SharePoint online site, and the method that I am using is with sharepoint framework webpart. but when I press the button to do the API ...
1
vote
0answers
40 views

How to extract metadata including whole file content in sharepoint REST api

Now, I want to extract file content using sharepoint REST api. My goal is: extract file metadata and entire file content (just pure content, no structures). After searching online, I notice I can use ...
0
votes
1answer
26 views

Change approval status after insert item via Sharepoint REST API

I recently noticed that by modifying the column of an item in a list with active versioning, however much the item is approved, it changes the status to draft. When faced with this problem I decided ...