Questions tagged [sharepoint-rest-api]
Using the Representational State Transfer (REST) interface provided by SharePoint
1,287
questions
0
votes
1answer
13 views
Work e-mail edit/delete of a user in SharePoint 2016
I Want to delete a particular email address using REST API for a user as the owner have left the org and the email is bouncing with delivery failed error message.
Cant delete entire user as used in ...
0
votes
0answers
3 views
REST or ADODB? What provides the best performance of creating an Excel VBA tool?
I’m creating a small Excel VBA tool that performs basic CRUD operations to SharePoint lists. Ha-ha, I know, probably a terrible solution but it’s all we have or allowed to work with at the moment. I’...
1
vote
2answers
32 views
Javascript : Retrieve an item value from SP List
Before explaining my problem, I give you the context.
I've made an first page that will display a "Marquee" message (message that will scroll horizontally).
I would like to make possible to ...
0
votes
1answer
25 views
Sharepoint Online search REST api - filtering news pages on select sites
Using the search api to pull content into a mobile app, what's the right way to filter the results to get news from 2 select sites? Is there a way to use the actual site name in the filter or does it ...
0
votes
1answer
20 views
How can I delete sharing links using Power Automate?
I have created a flow with the following steps:
Get all document sets in a library
For each document set (all steps using Send an HTTP Request to SharePoint)
Reset Role inheritance
Break Role ...
0
votes
0answers
16 views
Multiple refinement filters in SharePoint Search API
I am making a Post call to the SharePoint Search API. I would like that call to only search two locations, a document library and the Site Pages library. I have tried all sorts of different syntax to ...
1
vote
1answer
23 views
Update or set value in people picker field using API
I am trying to set value in people picker field. I want to pass an Email address of the employee instead of employee ID in the API.
Any help is highly appreciated.
Using API endpoint: _api/web/lists/...
0
votes
1answer
31 views
How to detect by SP REST API whether it's SP online or SP on-premise server?
I know how to do it from SPFX extension but I need to detect SP type from desktop application interacting with SP by REST API.
0
votes
1answer
20 views
400 error when making POST request (adding item to SP list)
I have a form that contains check boxes and input fields, and hitting the Submit button should ideally add the content values to a SP list.
When I run the debugger I can see that each input (checked ...
0
votes
1answer
17 views
How can I get the orphaned (deleted) info from User Information List using web api?
I have a list called "Employees" where I store an employee's name in the Resource field using the people picker. The people picker allow single values only (no groups). I have other fields ...
0
votes
1answer
40 views
Sharepoint REST API get item parent folder (if exists)
I'm looking for a way how to get list (document library) item with property on its parent folder, for that API call : GET https://{site_url}/_api/web/lists/GetByTitle('Test')/items({item_id}). I know ...
0
votes
1answer
24 views
Redirect to Different library using content organizer rules in SharePoint online
I uploaded a document & its metadata using Rest API to the "Drop OFF" library with content organizer rules which is set to redirect document from Drop off to different library.
Document ...
0
votes
1answer
20 views
How can i get the task id of a workflow?
How can i get the task Id of a workflow task?
I tried to get it by using paralel blocks, like this
With the parallel block, I do two things:
Create the task
Get the task ID with Rest API
To get the ...
0
votes
1answer
27 views
Updating managed metadata field in sharepoint online document library using SPFx
I need to update the some columns(EmpId,DocumentDate,PRType,Commnunity) in my document library.Out of which PRType & Community is managed metadata column.
All works file and updated when I update ...
0
votes
1answer
28 views
FormDigestValue empty in Sharepoint Site using PowerShell
So, I was originally trying to create an item in a Sharepoint site, but as I took a 403 as response, and searched, I needed to put the X-RequestDigest header to work. I tried to fetch it using the &...
0
votes
0answers
22 views
Sharepoint REST API to retrieve discussion replies
I used below URL to retrieve list of replies for a discussion in SharePoint.
/_api/web/Lists/GetByTitle('DiscussionBoard')/GetItems(query=@v1)?@v1={"ViewXml":"<View Scope='Recursive'&...
0
votes
0answers
15 views
Unable to select nested array in JSON object with Microsoft Graph
Given the following Graph call response of https://graph.microsoft.com/beta/sites/root:/sites/[siteTitle]:/lists/[listId]/Columns, how can I only return/select down to the array "choices" ...
0
votes
1answer
21 views
Getting 403 error when calling REST API from HTML/JS in sharepoint online
As from now you cannot create custom aspx files in SharePoint Online nor edit them with SharePoint designer.
I'm trying to launch an html with some js (angularJs and jquery) from the same site in ...
0
votes
2answers
21 views
Get content of news posts using REST api
The goal is to use REST to pull content into a homegrown mobile app. I'm able to run simple API calls like this and get results:
https://xxx.sharepoint.com/sites/xxx/_api/web/lists/getbytitle('Site ...
0
votes
3answers
39 views
Send email using Rest not working
function processSendEmails() {
var from = _spPageContextInfo.userLoginName,
to = _spPageContextInfo.userLoginName,
body = '<b>Dear xyz ',
subject = '...
0
votes
5answers
46 views
How to Create item in SharePoint Online using REST api? If list name contains underscore(_)
I am easily able to create record in other lists using rest API.
But with this one list, api failed.
Listname: Project_List
Can anyone please help me.
Thanks
Code:
function GetItemTypeForListName(...
1
vote
3answers
54 views
Is it possible to change the owner of a group using Rest API?
I am creating Sp groups and the Owner gets set to whoever runs the script. I am trying to set the owner to another group or user and it is not working. The SP.Group documentation says it should work ...
1
vote
1answer
29 views
How to get storage size of a sharepoint site using API?
Is there a Graph or SharePoint API which returns storage size information of a site. I have checked:
SP.Site.usage property (sp.js)
But it is not a recommended version. Also I don’t want to use ...
1
vote
1answer
41 views
How to get list of all personal sites using SharePoint API?
Is there a way to get a list of all personal sites using SharePoint API's?
I referred to this answer to get all the personal sites and used:
https://abc.sharepoint.com/_api/search/query?querytext='...
0
votes
1answer
28 views
Multi level filter sharepoint rest api
I have a multi Folder/UniqueId column. I need to apply rest API filter on this column.
_api/Web/Lists/getbytitle('testList')/items?$filter=(Folder/UniqueId eq 'abctest')
Getting below exception.
{
...
0
votes
2answers
25 views
Sharepoint REST query returning 100 results no matter what filter I use
I am trying to execute a REST query on a Sharepoint 2013 list with Powershell, but I'm always getting back more results than I want.
Even if I filter the query to only get back 1 list item, the query ...
1
vote
1answer
26 views
How to search for all sites on sharepoint but exclude all personal sites using rest api
I am using the REST API to search through SharePoint using the call:
_api/search/query?querytext='contentclass:sts_site'&rowlimit=1000&startrow=0
but I am also getting all the personal sites ...
0
votes
0answers
9 views
Sharepoint online Rest API with JQuery exercise makes Google Chrome become unresponsive
i have a scenario where in i am checking permissions for a given user. I.e user will select a site collection based on that it will fetch his permissions in sites and subsites. I was successful but ...
1
vote
1answer
24 views
How to get the “sharepoint group” of the user who has modified a list item using REST API in a single call
I tried this:
_api/web/lists/getByTitle('listname')/items?$select=Editor/group,Editor/EMail&$expand=Editor/group,Editor/EMail
But this does not seem to work.
How to get the SharePoint groups ...
0
votes
0answers
15 views
RESTAPI to retrieve replies to a particular discussion
To get the list of replies from a SP 2013 Distribution list, using Below REST API:
/_api/lists/getByTitle("listname")/items?$filter=FSObjType eq 0
But this is retrieving list of all discussion ...
0
votes
0answers
24 views
REST API to create alerts
I tried creating an custom alert using _api/web/alerts/add. But getting unknown error.
I referred this Create list alert using REST for creating an alert.
Does the the alert functionality exposed ...
0
votes
2answers
38 views
How can I delete SharePoint site groups using Power Automate?
I am trying to use Power Automate to delete a bunch of SharePoint site groups but it does not seem to be working. My flow is successful but the group(s) are not removed. Google results seem to be more ...
0
votes
2answers
36 views
What are the exposed REST api in Discussion board?
I am trying to utilize REST api to get/set discussion list fields. I am facing issue for following fields,
I am able to set below fields using CSOM but I want to set it using REST api because I am ...
0
votes
1answer
35 views
Reading site contents using rest API
I am able to read the Site Contents. But the redirecting link is not working. To get the hyperlink what can I do in my code.
Below is my code:
<script src=""></script>
<div id="...
0
votes
0answers
13 views
System.UnauthorizedAccessException while trying through rest api.I am trying to get list of files in the folder
I have a sharepoint url access from front end and i am trying to access it through REST API in python
url = "mysharepoint_url/_api/web/GetFolderByServerRelativeUrl('" + folder + "')/Files"
header = {'...
0
votes
1answer
37 views
How to get list of all deleted sites using Microsoft API?
Is there a way to get a list of all deleted sites in sharePoint using Microsoft Graph or SharePoint API? I don’t want to use powershell. I want a api. Thanks in advance
0
votes
1answer
27 views
Flow to get all site collections in a tenant
Created a Flow by using the below REST call and stored the title and Urls in another list
/_api/web/lists/getbytitle('DO_NOT_DELETE_SPLIST_TENANTADMIN_ALL_
SITES_AGGREGATED_SITECOLLECTIONS')/items?$...
0
votes
2answers
74 views
REST API to get all site collections in sharepoint tenant [duplicate]
Can we use REST API to get all site collections in sharepoint tenant.? I don't want powershell script basically i want to bind all asite collections to a dropdown.
my code looks like bleow.
0
votes
1answer
22 views
Move tree view as a web part
I have enabled tree view in navigation. The tree view displays site content in a physical manner in left side. I want that same hierarchy way of site contents structure as a web part or custom app ...
0
votes
2answers
20 views
Get every sites in a tenant using SharePoint API
I am developing a SharePoint solution using Django.
How can I make the user login in my app using SharePoint login and list out all the available sites inside that particular tenant?
I have seen ...
0
votes
1answer
31 views
Update Document Library Title Using REST
I am trying to update the Title of an existing document library using REST but getting this error
The parameter __metadata does not exist in method GetByTitle.
my REST endpoint is
/_api/web/lists/...
0
votes
1answer
30 views
How to get version history in SharePoint 2013?
I made a comments column, enabled "Append changes to existing text", and enabled "Create a version each time you edit an item in this list?". How can I retrieve all versions so I can get all comments ...
0
votes
1answer
29 views
SharePoint ReST API: Getting 403 while getting subsites of root site
We are trying to perform GET http://<site url>/_api/web/webs using SAML Authentication.
User can access subsites through UI. But still getting 403 while accessing above API using ReST.
Kindly ...
0
votes
1answer
27 views
How to fetch all data associated with a SharePoint web part using Microsoft Graph API?
I am wanting to fetch all of the associated data for the web parts of a SharePoint Page using the Microsoft Graph API. Is this possible through the beta or v1.0 API? I can't seem to find any ...
2
votes
2answers
33 views
How do I get sharepoint list items by passing ID as the parameter dynamically using rest api
I have to fetch values for particular Id's by passing ID in URL.
Ex: if I write ?ID=2, it should give me the values corresponding to the id in the list.
0
votes
0answers
27 views
Using SharePoint's REST API to $expand a folder's people field
I can't quite remember how to expand a field of a folder or file. Example: I can do something like Folders/ListItemAllFields/RoleAssignments/Member to expand the role assignments, but I cannot do ...
1
vote
1answer
31 views
Add Lookup column to SharePoint list using Flow/Power Automate and Rest API
I am trying to add a Lookup column from a SharePoint list using Microsoft Flow(Power automate). The flow retries once and says "Bad Gateway". I'm not sure why the below is not working given that I ...
0
votes
0answers
22 views
REST API - Get document library properties that are in a folder of that library
When getting properties from a document library with the SharePoint API, I'm using the following call
var httpRequest = new HttpRequestMessage(HttpMethod.Get, spPath + spSubSite + "/_api/web/lists(\'"...
1
vote
0answers
18 views
How to Get Parent Term from child term using TaxCatchAll?
Suppose a SharePoint list has managed metadata column "A". List contains the item with the child term tagged to that "A" column.
Now when I try to fetch the term using rest API like this:
/_api/web/...
0
votes
0answers
16 views
filter subsites if current user is member of owners group using REST API?
The following code returns all the subsites where the user has access:
"/_api/Web/GetSubwebsFilteredForCurrentUser(nWebTemplateFilter=-1)?$filter=WebTemplate ne 'APP'"
However, I would like to ...
