Questions tagged [sharepoint-rest-api]
Using the Representational State Transfer (REST) interface provided by SharePoint
1,529
questions
0
votes
1answer
25 views
Creating Pages and adding webpart to sections of page (SharePoint Online)
When a List Item is created, I wish to automate the provisioning of a SharePoint Site and add pages with webparts to sections of the page (webparts pre-loaded onto tenant). Because Modern Sites do not ...
0
votes
1answer
23 views
How to find the user who has created a draft item in a SharePoint list
I am trying to find out the name of a user who has changed something in an SP list. I am calling this API:
https://tenant.sharepoint.com/sites/sitename/_api/web/lists/getbytitle('listname')/Items(ID)/...
1
vote
0answers
18 views
Manipulate sharepoint group membership using REST API from external app
I have an application that is secured via OpenID Connect / Azure AD.
It is a webapp that is not running as part of the Sharepoint Framework.
However, the app does need to interact with SharePoint in ...
0
votes
1answer
16 views
How to insert multiple URLs with a title for each URL in an SharePoint List Column?
I am trying to know if there is a way to insert multiple URLs and give a title to each URL in a column. For reference, please have a look at this below image.
In this list, we have Title, Name and ...
0
votes
0answers
23 views
Difference between MS Graph API and SharePoint REST API in filtering
While working with MS Graph I noticed that if I need to filter list items by custom fields, I had to make this field indexed, or work with header attribute:
Prefer: allowthrottleablequeries
or
Prefer: ...
0
votes
0answers
21 views
Sharepoint online APIs, how to get all the users, the list they have access to, and the group they belong to
Is there any rest API or a set up of rest APIs that allow us to get all the users, the list they have access to, and the group they belong to,
The output can be something like the below table:
Users , ...
1
vote
1answer
29 views
Get all site collections listed in SharePoint Admin center using Rest / Search / Graph api
Does anyone know how to fetch all site collections from my SharePoint admin center by using rest api / search api / graph api?
I have tired using search and graph api :
let query = SearchQueryBuilder(&...
1
vote
1answer
22 views
Is there a client API to manage user's alerts for document libraries/files?
In SharePoint users can use the "Alert me" function to get notified of file changes in a document library (or single files):
Is there a client API to set those alerts? E.g. from a ...
0
votes
0answers
15 views
EnableQueryRules on REST Postquery
I trying to use Sp2013 query rules base of search terms get specific page.
I created a query rule then tried to receive it on my browser using GET request.
_api/search/query?querytext="blah"...
0
votes
1answer
25 views
How To Get All Columns From a Document Library
I have a document library which contains folders and document sets. I am trying to decide which to use for this case, is there a better option??
So I have the library known as 'TestTracking', which ...
1
vote
1answer
19 views
jQuery Ajax Unauthorized error on POST
Trying to create my first web part for SharePoint online that writes to a list. But when I do a post using jQuery ajax I receive an Unauthorized error. Any help you be greatly appreciated.
I am ...
2
votes
0answers
15 views
How to use paging SharePoint lists along with sorting and filtering
I am trying to apply paging in a SharePoint list. Everything works fine with the following query:
const queryUrl = `${context.pageContext.web.absoluteUrl}`
+ `/_api/web/lists/GetByTitle('...
0
votes
2answers
20 views
AJAX Data From SharePoint List Not Carrying Over to Next Function
I have created fiddle with mock sample data that is formatted the same way as the AJAX response data.
When I try to implement my script into a SharePoint script editor and debug it, it tells me that ...
1
vote
1answer
21 views
SharePoint rest API for updating a site pages library item
I need to update a filed in the Site pages library using rest API. I tried with axios and spHttpClient & spHttpResponse, but it's not working. Is there any sharepoint rest API for updating an item ...
0
votes
0answers
8 views
currentUser.get_Title() is not working for all users to update the list in Sharepoint 2019 On PremSite
I have a created a list for tracking users who have visited the SharePoint Landing Page. This list should contain visited users details like Name, E-Mail and visited time. But the problem here is, The ...
0
votes
0answers
18 views
How can i upload file to document library without using jquery?
I visit a lot of site and they all using jQuery to handle the Ajax action.
but in my project i required to not using jQuery, just using XMLHttpRequest to connect the RESTAPI.
those jQuery code as ...
0
votes
1answer
16 views
Add a people value to a SharePoint Online list using the email address
Using SOAP Services, we used to be able to add multiple items in a list that contains a people field just using the email address and without knowing the user id. In that case the value to provide was ...
0
votes
1answer
40 views
Help with starting point for sharepoint online authenticator requests via VBA
I'm a user who maintains low-level VBA tools for myself and some colleagues.
Some of the tools download or upload files from SharePoint online, treating the URLs as filepaths.
I'm not familiar with ...
0
votes
0answers
31 views
Can you add sorting and filtering to SharePoint List views using the send http to sharepoint/rest api
I am trying to create a list view with sorting and filtering on using the SP rest API and send http to SharePoint action.
I have added a CAML query to the View Query parameter in the body of the send ...
0
votes
0answers
26 views
SPO Rest API call resulting in Empty Array
I am trying to get all the files in a Document Library placed in a subsite. The Document Library is called WorkInstructions.
I am currently using Bearer access token.
https://tenant.sharepoint.com/...
0
votes
1answer
28 views
Error List 'listName01' does not exist at site with URL https://xxxxx.sharepoint.com'. in Postman
I have been trying to use Postman to see list items using Postman and I am getting following error:
List 'listName01' does not exist at site with URL https://xxxxx.sharepoint.com'
When I log in ...
1
vote
1answer
29 views
Unable to upload file to specific SharePoint drive,
I am trying to upload a file to SharePoint drive using graph API. I am doing OAuth using the below-mentioned link:
GET https://login.microsoftonline.com/{TENANT_ID}/oauth2/v2.0/authorize?client_id={...
2
votes
1answer
57 views
I am trying to get the choice type field value in select tag from SharePoint list
I am trying to get the choice field value in select tag from SharePoint list.
Here, the code is given below:
function GetphysicalVertual() {
var defPG = $.Deferred();
var inputElement;
$....
0
votes
2answers
27 views
How to fetch only Site Pages and not page templates from Site Pages library using REST call?
I am trying to fetch only the site pages and not the page templates using REST call, but using below REST endpoint I am getting all the site pages including page templates.
How to filter out only the ...
0
votes
1answer
23 views
How to create Asset Library (BaseTemplate = 851) in Sharepoint Online?
Been searching through the internet for a couple of days to no avail but how do you create Asset Library with BaseTemplate = 851 in modern sites for Sharepoint Online via the REST API V1.0 endpoint? I ...
0
votes
0answers
61 views
AADSTS70000: Provided grant is invalid or malformed
I am new to SharePoint world.
I have created an app on SharePoint online.
I have been trying to use Postman to get access token using Sharepoint online API but I am getting this error
AADSTS70000: ...
0
votes
1answer
14 views
What's the difference between the fields "owshiddenversion" and "OData__UIVersion"?
Query is something like .../_api/web/Lists/GetByTitle('Documents')/items?$select=File,File/ServerRelativeUrl,OData__UIVersion,owshiddenversion,FileRef
This worked in a SP Root site: OData__UIVersion ...
0
votes
0answers
21 views
Get SharePoint subsite permissions groups/user list
I would like to know who has the access to my SharePoint site using MS flow.
It can be granted the permission to a person or to a group.
How do I get all information by using flow? any API?
0
votes
1answer
18 views
Removing a siteuser from a site collection using REST API
I am posting this information in case anyone else is trying to build a process like this.
I was trying to manage the users of my site collections and make sure that only active accounts have access. I ...
1
vote
1answer
27 views
How to add users to a list by REST API before they are added to a list manually
I'm using SharePoint Online and SharePoint REST API v1.
I realize that after a user is added to people column of a list manually, I can get user ID and add this user to a column by the API.
But I need ...
0
votes
1answer
24 views
How to get list of folders data from SharePoint List using Javascript?
Can anyone please help me with that?
Suppose my list name is: Country in which I created 5 folders with different country names, then inside that folder I created their state names.
So scenario is ...
0
votes
0answers
8 views
Sharepoint API - 401 while authenticating ANT account with full control
We are trying to achieve programmatic access from a Python3 script, to a Sharepoint site that we own.
On our SP site, we have given full control to a ANT\robot-system-account system account.
The ...
0
votes
1answer
81 views
In a REST call to '/_api/web/Lists/GetByTitle('title')/items?$select=... , what are the allowed fields?
Where could I find a list with these allowed values ?
I could use, for example, FileLeafRef, File, *.
But I could not find these values documented somewhere.
Can anybody help?
0
votes
1answer
20 views
REST call (HTTP) to RECURSIVELY get ALL files starting from (filtering by) a certain SharePoint Path
I need to write the HTTP query (will call it from a Python script) to get ALL the files (including from all sub-folders of sub-folders) starting from a specific SharePoint Path. I need to run this on ...
0
votes
0answers
18 views
SharePoint Rest API(add file) request returning http 500 when using Transfer-Encoding chunked
I'm hitting my SharePoint online site, to add files to the 'Shared Documents' list.
Trying from postman, I can get the access token (https://accounts.accesscontrol.windows.net/xxxxxxx-xxxx-xxxxx-xxxxx-...
0
votes
1answer
30 views
File Downloaded From SharePoint Online using PowerShell is not Formatted Correctly
When using Powershell to download a file from SharePoint Online, the file is not encoded or formatted properly.
With the below code, I am able to successfully authenticate to the site and download a ...
1
vote
0answers
20 views
Can I set up a custom permission level that permits CRUD operations through the REST API only?
I have JavaScript applications that use group memberships to control access to items in lists. I only want users to be able to interact with the data using these JavaScript applications. I want to ...
1
vote
1answer
29 views
Rest apis in SharePoint
I am new to SharePoint but not having any luck. Please correct me if I am wrong on the process so far.
I am using react and need to create a CRUD app in react for SharePoint, so to do this I need to ...
0
votes
0answers
33 views
Issue uploading file to sharepoint using postman
I'm trying to upload a file to Sharepoint site using REST API in Postman but getting 'Bad Request - Invalid URL' error.
I'm calling API https://mysite.sharepoint.com/sites/<site_name>/_api/web/...
0
votes
0answers
18 views
SharePoint 2013 API / versions on files. Extract version history of custom SharePoint file properties
I'm trying to iterate through the file versions of documents on our SharePoint document library. The goal is to extract what some custom properties were at a given point in time.
However, I'm having ...
0
votes
0answers
19 views
Graph API using JSON BATCH request t to get recent files for a specific document library
Is there a way to get recent files from a specific document libraries in a site collection?
I tried
https://graph.microsoft.com/beta/me/insights/used
But I wasn't able to use filter to get the ...
1
vote
1answer
31 views
Update Version for Multi-line text field
I have a SharePoint list with a multi-line text field. I have the option to "append changes to existing text" turned on. This option will show the version history for each change.
Is there ...
0
votes
1answer
52 views
Permissions for CSOM & SharePoint Online?
I'm working to upgrade an existing on-premises SharePoint site to a SharePoint Online site. The existing site uses a lot of code (both JS and .NET code) talking to the on-premises site via JSOM, CSOM,...
0
votes
1answer
24 views
SharePoint Online - Search API call using filters
I am trying to call SharePoint search API through JavaScript but cannot get it working.
I need to get all documents in a SharePoint site where Title='Test'. I am using SharePoint online.
Can someone ...
1
vote
1answer
64 views
Indexed column throws threshold error while filtering based on range
We have a list with over 1M items. The end goal is to filter the column InvDate based on date range.
The InvDate is an indexed single line of text column , However it throws the List View Threshold ...
0
votes
1answer
53 views
Form Digest expires while copying 1M List Items
We are copying more than 1M+ list items with 27 columns from List A to B.
Got to the point where all the items are fetched from List A.
The code throws form digest error after copying around 2K Items.
...
1
vote
0answers
14 views
Edit and Delete options for each sharepoint list item using query Datatables?
How to use jquery Datatables to add - Edit and Delete options for each sharepoint list item. Please help me with an example.
1
vote
1answer
180 views
Sharepoint REST api - post a like on a site page comment
I can like a page using:
POST
/_api/web/lists/getByTitle('SitePages')/GetItemById(722)/like
Modern pages also allow users to like a comment but this api call doesn't work:
/_api/web/lists/getByTitle('...
0
votes
0answers
12 views
Web pack with SharePoint on-premise 2013 aspx pages
I'm looking for information, to see if anyone else has experience using web pack within a SharePoint environment, and was hopeful one of you helpful people my have some advice.
My use case may be a ...
1
vote
1answer
36 views
How can I create a new list item in SharePoint with attachments without using jQuery
I am trying to create a SharePoint list item from a HTML file loaded into a SharePoint page.
The issue that I am facing is that the business will not allow any external CDN's meaning that any .js code ...
