Questions tagged [sharepoint-rest-api]
Using the Representational State Transfer (REST) interface provided by SharePoint
1,456
questions
1
vote
1answer
17 views
How do I error handle a REST API call with no results?
I have a PowerQuery function o retrieve the contents of a SharePoint list.
let
Source = (url as any) =>
let
aSource = OData.Feed(url, null, [Implementation="2.0"]),
...
0
votes
0answers
7 views
add current user's AD group to item permissions using REST API
Scenario:
I have active directory groups added to Sharepoint Groups. Then via the workflow, using rest api, I am trying to set the permissions of an item.
I am using this example: https://www.c-...
0
votes
1answer
14 views
Base64 files corrupt upon upload via SP rest in Power Automate
I am trying to use a SharePoint request action in Power Automate to upload a file to a library. I'm running into an issue that I've seen many others who have attempted this either using the SP JSOM ...
1
vote
1answer
20 views
DevExpress Custom Store to get data from REST API
I'm trying to create a drop down menu using DexExpress in jQuery with SharePoint REST API. I get the values from the REST call in the console, but I'm having issues trying to display these values in ...
0
votes
0answers
25 views
Why do I have to download all SharePoint content to get just a piece of data?
In my environment we have thousands of SharePoint sites. Something as "simple" as Project Online creates a separate SharePoint site for every project. So when I want to find some information ...
1
vote
1answer
19 views
How do I use wildcards in REST AP /_api/web/Lists/getbytitle?
I want to retrieve all lists from the SharePoint site that start with "ABC".
This doesn't work
https://......sharepoint.com/sites/...../_api/web/lists/getbytitle('ABC*')/items
Just to be ...
0
votes
0answers
7 views
Get file contents of previous 'Versions' in sharepoint library
My end goal is to attach historical versions of a file to an email using Power Automate. I.E. The last three months of test results which are stored on SharePoint with the same file name, which ...
0
votes
2answers
14 views
Azure Data Factory 401 error when calling GET request on SharePoint online API
I am trying to move files between Azure Data Factory and SharePoint Online.
I have some test data files in a SharePoint location and I have a pipeline in Data factory containing a Web Activity and a ...
0
votes
2answers
24 views
How to create a SP List from a SP List template with Power Automate?
How can I create a Sharepoint list from a Sharepoint list template with Power Automate?
This below is what I got so far. But how can I specify the list template?
0
votes
0answers
27 views
SharePoint HTTP request works in browser, but in script “File does not exist”
I'm trying to download a given file on a schedule to be used in a python script, using the requests module for the POST and GET requests. I went through the steps to register an app-only account (...
0
votes
2answers
45 views
Sharepoint Rest API, retrieve more than 5000 files in folder
I am trying to get the list of all files contained in a sharepoint folder, however, because there is more than 5000 files I cannot get any results.
I understand that I cannot query more than 5000 ...
0
votes
2answers
22 views
How to filter list and Document library in java-script [closed]
How to filter the list and document library from SharePoint using base-type?
0
votes
1answer
25 views
Sharepoint Restrict duplicate entry in List
Guys Required support for below scenario. I have one list for booking with date and time. I want to restrict the duplicate entry by date and time.
I have tried the REST API code but it's not working. ...
0
votes
1answer
16 views
Uploaded file does not have same SHA-256 checksum as local copy
I have used SharePoint for a month or so now and have recently noticed the following behaviour:
If I upload, say, a pdf file to SharePoint and then download it again the SHA-256 checksum of the two ...
0
votes
1answer
18 views
Change SharepointOnline site description with api call to Sharepoint
I need to change the description of a SharePoint site with a Power Automate flow. It is a really easy task with SharePoint online, it is kind of a nightmare with api call action "Send an HTTP ...
0
votes
0answers
18 views
Collect list of all sites, lists and items with unique permission based on user by rest api?
Is there any api to get all lists of subsites, documents, items which have unique permission on specific user?
The following rest api to get details about sites, lists with unique permission
The ...
0
votes
0answers
33 views
NodeRed POST request to Sharepoint REST API
I want to upload files on Sharepoint and I'm using Node Red for communicate with REST Sharepoint API.
As far as I know, first of all I need to request a diggest token for the POST communication: so, ...
0
votes
0answers
17 views
Update SharePoint LikedBy column without changing approval status
I have a list where i've enabled ratings field, I'm using setLike.js to show and update the likes on list items. The problem I have though is the list also has "content approval" enabled. So ...
0
votes
0answers
12 views
I have a SP list A with lookup column from list B. I want the lookup from list A to auto-populate input text fields from B
$("select[title='Shipping POC']").change(function () {
var shipPOCID = $(this).val();
var shipPOCID = getURLParameter("Shipping_x0020_POC");
console.log(...
0
votes
0answers
7 views
AD user having contribute permission to SharePoint via SharePoint group but workflow says unauthorized
The user A having Contribute permission through AD group(which is mapped to SharePoint Group).
User could/can access the site and upload file without any issue.
Issues:
Workflow Rest API - result: ...
0
votes
0answers
12 views
How to get an auth token and upload files via the SharePoint REST API?
A client shared a folder with me: I got a link looking like
https://clientname-my.sharepoint.com/personal...?originalPath=(long string of k23jlkj2342)&id=(something looking like path to the folder)...
0
votes
1answer
27 views
filter column with last 4 digits using restapi
We have a column where the values are stored as '1002859817' and the Field Type is single line of text.
The end goal here is to filter the column based on the last 4 digits i.e. '9817'
Tried the ...
0
votes
1answer
26 views
Batch Update for 16K Items failing
We are trying to copy contents from one column to the other , However we get request digest error after 6K Items.
Below is the code
$(document).ready(function () {
$("#btnSubmit").click(...
0
votes
0answers
12 views
get videos from Sharepoint 2019 online, video gallery and add show all those on page using jsom
I am trying to get all videos from SharePoint 2019 online video gallery and show them on a .aspx page using content editor web part.
First issue is I am getting more items in the array where I only ...
0
votes
1answer
33 views
How to set field as hidden in list content type using API?
I need to set field as hidden (not visible on list form) using REST API. I don't know how to setup command.
I found location of this parameter in xml but I don't know how to refer and update them, you ...
0
votes
2answers
34 views
Sharepoint /$value returns Gibberish / strange encoding
I am trying to access a word file from a sharepoint site with the $value which returns the content in unknown format.
GET url is
https://site.sharepoint.com/_api/Web/GetFileByServerRelativePath(...
0
votes
0answers
14 views
How to check if user belongs to a sharepoint AD group nested within a SPO group using REST/Javascript only?
I need to know if a user belongs to a specific SPO group using REST/Javascript. If the user has been added individually I can but if the user has been added to that SPO group via an AD group I can't ...
0
votes
1answer
13 views
PWA/Project Online - Setting Project ID dynamically with REST
I am trying to dynamically set the Project UID in an Angular app which is deployed to every subsite throughout my PWA. I need to be able to ideally, store the Project UID in a global variable which I ...
0
votes
0answers
6 views
Download file from SP in custom web part without <a></a> tag
I have a custom web part it needs to download a file from SharePoint document lib. I was using the tag combined with the file path, but this seems to break SharePoint. Is there another way to do it? ...
0
votes
1answer
27 views
How to get SharePoint users from list by Rest API
I have written my app, in SharePoint Framework, but in link I have got only name of list. How can I get user name and Surname of editor and creator?
I want to have all user data. How can I get it by ...
0
votes
0answers
18 views
Get UPN or Azure AD User Id from SharePoint People or Group LookUp field
I'm using PnP JS to get the the values of a Person or Group field.
Is there a way to retrieve the UPN or Azure AD User Id, using the SP Rest API?
I have looked everywhere and I can't find an answer to ...
0
votes
1answer
16 views
List Dates Off by One Day
I am having issues with dates in a SharePoint 2013 list.
At a high level I am archiving the dates of the selected item in List1, storing them in List 2. The dates in the selected item are updated to ...
1
vote
0answers
18 views
409 'Conflict' Changing ContentType property of Document Library
I have about 600 items in a document library. The library has 9 content types defined in it, which is part of a reorganization to take items out of folders and make it folderless. The library is a ...
0
votes
1answer
31 views
How to login using API to get delegated permissions for registered app
I managed to get the access token in postman (After registering the app on Azure on following the required steps), but the permission for the app is set to only allow logged in users to read from ...
0
votes
1answer
15 views
Getting all shared files and folders from a given site
Is it possible to get all files or folders that has been shared from a site in one batch, or do you need to iterate each single file and folder on the site?
0
votes
0answers
32 views
Rest api caml query not returning field in ViewFields
I have a CAML query that I am running through the REST api, the simple example below requests 2 fields - FileLeafRef and CustomField. Custom field is simple a text field, nothing special.
CustomField ...
0
votes
1answer
57 views
Batch Update for 700+ items failing
I have written a code that gets all the URLs from the URL column in a document library , converts them into base64 and stores the resultant string in the respective column.
The code works fine on a ...
0
votes
1answer
11 views
Returning REST response to calling function
Is it possible to return the value from a REST response back to the calling function?
In the code below returneddata is always undefined. In the GetMyData function I can see the REST response and ...
0
votes
0answers
9 views
How to update workbook's named cell from rest API
I want to read and update a named cell from an excel workbook.
If I reach the cell using graph api endpoint, it works:
GET https://graph.microsoft.com/v1.0/sites/{siteid}/drives/{driveid}/items/{...
0
votes
1answer
30 views
Remove Role Definitions From SPO Group - Power Automate - MS Flow
I'm trying to remove full control role definitions from Site Owner Group, because I have added another permission level through Power Automate/MS Flow.
From Microsoft docs - Below is the syntax for ...
0
votes
1answer
42 views
How to update list item using id in Sharepoint 2016 using rest api
I have two lists 'a' and 'b' with same titles but different ids. I retrieve the title from 'a' list to a html page. And, there is a 'b' list. Here, both the lists have different ids but has same ...
0
votes
1answer
22 views
Unable to store the list item value using session storage in Sharepoint 2016
I click on a link then it's updating the count column value in the list. But after reloading the site, the count column value becomes 0 in the list. I am updating the count value using count variable ...
1
vote
1answer
32 views
Unable to update the list item in list using REST API Sharepoint 2016
I've been working with this problem from one month but unable to solve this. I'm able to retrieve the list using GET method REST API. But I'm not able to update the items in the list using POST method ...
0
votes
1answer
11 views
SharePoint REST and DataTables.net (SP2013) Select Items
I had opened this thread in an other area of StackExchange, but then I found the SharePoint area, sorry for the duplicates.
I am fairly new to SP and we are still using an old version, so looking for ...
0
votes
1answer
21 views
Unable to match a subtasks to its parent tasks REST API
I am able to get the tasks and subtasks from a SharePoint list using the REST API. How can I match a subtask with its parent task? The following JS inside an AngularJS controller returns two lists, ...
0
votes
0answers
16 views
Filter lookup field of multiple values using REST API 'getitems'
I am trying to retrieve items from a List, using CAML+RESTApi but when I try to $filter for a lookup column with multiple values it shows me:
{"error":{"code":"-1, Microsoft....
1
vote
2answers
89 views
Retrieve SharePoint file with API using document ID from any document library
In site collection features there is an option to enable Document ID Service. After doing this, whenever a document is uploaded to a document library, a unique document id that is a link to the doc is ...
1
vote
3answers
23 views
Make html page with Sharepoint REST result
I'm new with javascript and HTML, so please be patient.
I'm trying to make very simple HTML page displaying text with value stored in sharepoint 2013 list.
I've made REST query in which I've item with ...
0
votes
1answer
43 views
Is there any API to retrieve data from Popularity Trends in Sharepoint Server 2016
I'm using SharePoint Server 2016 and as we know there is a feature called "Popularity Trends" which gives a report on number of hits and unique users with the graphs for the library.
So, ...
0
votes
1answer
25 views
SharePoint REST API - Fetching folders from subsite
I am new to using SharePoint online REST API's. I started with basics by connecting to SharePoint online via Postman and list folders in a subsite. So I have achieved the first step of connecting to ...
