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.
2,321
questions
0
votes
0
answers
4
views
API does not return updated date for calendar event
Situation
A user creates calendar events in SPO. We use PowerAutomate to send an email once a week with a listing of the events that will take place in the next two weeks.
Problem
Sometimes, the date ...
- 101
0
votes
0
answers
13
views
Programmatically downloading all files from a folder
I need to create a script to download all files from a certain folder on my Sharepoint, or alternatively download using a wildcard (there will only be one file in this folder but its filename changes.
...
- 1
0
votes
0
answers
22
views
Sharepoint Online - REST Call takes almost one minute to complete
API Call to get all documents to display them in custom list takes about 55 sec to complete and it's irritating to customer that everytime they have to wait such period.
I'm interested into why and ...
- 123
1
vote
0
answers
22
views
Calling HTTP endpoints via On-premises data gateway
I have a requirement to get information from an old legacy system thats on premise.
If they have an API that is exposed can I use data gateway and a custom connector?
I need to use Power Automate to ...
- 4,226
0
votes
0
answers
13
views
Is there a way to create subsite based on another one, copying lists and workflows for them,..?
In Sharepoint Online, I'm trying to create a button that will trigger creating subsite and have all the lists and workflows based on one main list in root site.
E.g. there is two lists in root that ...
- 123
0
votes
0
answers
28
views
REST filtering large list by lookup field value
Is it possible to search in large list by lookup filed value with 'substringof'
like:
_api/web/lists/getbytitle('Obchodné Prípady')/items?$select=*,Investor/Title&$expand=Investor/ID&$top=100&...
- 341
0
votes
0
answers
30
views
Download File Using URL using NodeJS
So I implemented google drive url download feature recently and It starts downloading the publicly shared file directly without any authentication.
When I tried the same with SharePoint, I got 403 ...
- 1
0
votes
2
answers
38
views
Get a list of files in a sub folder in the Documents Library of Sharepoint site
I am trying to find the best way to get files inside a specific sub folder in the sharepoint website, but the only links I find relate to the root folders.
I have a Sharepoint site which is really ...
- 1
0
votes
0
answers
31
views
Querying, analyzing, and displaying data from external API in SharePoint
I am a new SharePoint developer and I am tasked with displaying trends in data from Zendesk in SharePoint. I have been reading the Microsoft documentations and from what I have been reading the ...
0
votes
2
answers
479
views
How to get file metadata by REST API?
I have a video file named simpleVideo2 (360p).mp4 in folder Video Assets(It's document library), and I want to know if it's possible to fetch file metadata through the REST API to get the video's ...
- 23
1
vote
1
answer
194
views
Read Data from SharePoint Online using REST Api for Specific Item
I am successfully connected with SharePoint Online and successfully Updated the List using Rest Api.
Now I am trying to Get item details using ItemID using the following C# Code:
try
{
Uri uri = ...
- 185
0
votes
0
answers
29
views
What roles needed for App Registration to be able to remove Compliance Tag
I'm trying to remove a compliance tag from an item in SharePoint with the following REST call:
{
"uri": "https://xxxxx/sites/xxxxxx/_api/Web/Lists(guid'xxxx')/Items(xxx)/...
- 1
0
votes
0
answers
18
views
List item's custom workflow instance id
Is there any way to get list item's workflow instance id? (SharePoint 2016)
I can get for list association with REST Api https://[server]/[sitecollection]/[site]/_api/web/lists/getByTitle('[ListTitle]'...
- 13
1
vote
1
answer
50
views
How to get SharePoint Custom Workflow Status With REST
I have a SharePoint document library and I've created two custom workflow. Then i attached those workflows to a document library. What i'm trying to do is getting workflow status and URL with single ...
- 13
0
votes
1
answer
249
views
Update SharePoint List item using Rest API in C#
I am writing an API in Web API 2.0 on C# to perform various Actions with SharePoint List items.
I have tried the following code to update the Status Column of a List item:
HttpWebRequest ...
- 185
0
votes
1
answer
91
views
Get a List View via REST API with custom formatting and display it
I have a List with a View on it that has custom formatting. I am trying to pull the list via REST API and display the items according to that view within a SPFX-webpart with the custom formatting ...
1
vote
0
answers
163
views
Accessing the recycle bin with the SharePoint REST API results in an error "Access is denied."
I would like to access the recycle bin via the SharePoint REST API, but I get the following error.
{
error: {
code: '-2147024891, System.UnauthorizedAccessException',
message: {
lang:...
- 23
0
votes
0
answers
21
views
Project Web App - get project related site from Project ID via REST
My question is the exact opposite of Project Web App - get Project ID from project related site via REST.
In that question, the user asked
Is there a way to get the Project ID of the published project ...
0
votes
1
answer
31
views
Accessing External Rest API from Sharepoint Modern site in Sharepoint Server 2019
I want to access external API through sharepoint server 2019 modern teams/communication site hosted on-premises. Is there any out-of-the-box web part that enables the access to the external API?
- 31
1
vote
1
answer
64
views
Hide a content type via REST for Power Automate
Trying to hide content types in a SharePoint library using REST in Power Automate but it doesn't seem to be changing the value, however, I get no errors.
I found this for the REST endpoint
https://...
- 427
0
votes
1
answer
404
views
Read large lists with Office365-REST-Python-Client
I am currently trying to read only the last week's entries of a few lists, and I accomplish this by using filter("Modified gt datetime{date_in_isoformat}') or order_by("Modified desc")....
- 13
0
votes
2
answers
45
views
Recycled item missing Name in Recycle bin
I made REST API call to recycle the item, which works successfully:
var requestDigestValue = $("#__REQUESTDIGEST").val();
if (requestDigestValue) {
$.ajax({
type: "POST",
...
- 123
0
votes
1
answer
223
views
Retrieve Site Assets library from SharePoint Team Site through REST API
I'd like a Power Automate flow to configure read permissions on the Site Assets library for a SharePoint group that contains external users.
However, I'm having a hard time retrieving the Site Assets ...
0
votes
1
answer
212
views
Is it safer to use "ge" and "le" to get items created on specific dates using the REST API, rather than using "eq"
I have a custom list with field of type DateOnly named ExpiryDate:-
Here is the site regional settings:-
now i have noted if we change the ExpiryDate to accept Date-&-time then we change it back ...
0
votes
1
answer
342
views
How Retrieve all the files and folders recursively in a specific folder using SPFX REST API post method
How Retrieve all the files and folders recursively in a specific folder using SPFx REST API post method?
private _spApi(): void {
this.context.spHttpClient
.post(`${this.context.pageContext....
0
votes
0
answers
74
views
How to select custom template on site collection creation
I'm trying to create a new site collection in sharepoint 2019 with the api _api/SPSiteManager/create. The only template i can choose are STS#3 and SITEPUBLISHING#0. If I choose any other template it ...
- 1
0
votes
1
answer
161
views
SPFX Form Customizer extension, how to prevent edits via REST etc
SPFX runs in context of the user, user has to have Write permissions to the list.
If user has write permissions, the REST API will reflect that, so the user could just bypass and form customizations ...
- 23
0
votes
0
answers
152
views
Why do I get empty lists when listing files/folders in a folder using API?
I've just created a folder "import" in sharepoint, where I've created :
1 emtpy folder "testdir"
2 emtpy files "test1.csv" and "test2.csv".
When I query this &...
- 101
0
votes
0
answers
172
views
In JavaScript, how do I create a SharePoint 2019 (on Premise) publishing page?
I am trying to find a way to create (and later update) a SharePoint 2019 publishing page via JavaScript. There seems to be a lack of documentation specifically directed at SP 2019, but plenty of SP ...
0
votes
0
answers
59
views
401 Unauthorize error when making POST requests
I'm using SharePoint's REST APIs to build a simple application that displays all items of a list and includes a form to create a new list item. All users are able to view the items, but only a few ...
- 111
0
votes
1
answer
126
views
Is there anyway to Disable or remove Shared Link for particular user in SharePoint Online using Rest API, CSOM or PNP
I am looking for some mechanism to remove a specific user from a ShareLink in SharePoint Online via Rest API, CSOM or PNP, whilst leaving the ShareLink active and available for other users.
I want to ...
- 1
0
votes
1
answer
951
views
403 Forbidden when uploading file to sharepoint using REST API. Permission issue or missing header?
I am new to Sharepoint and REST APIs and am currently having an issue uploading a file using REST API. I am getting error System.UnauthorizedAccessException","message":{"lang":...
- 1
0
votes
1
answer
420
views
SharePoint Online - Issue with REST API call on a List exceeded the threshold limit
I have a List in a SharePoint Online site collection which has exceeded 5000 items. I have indexed the columns that are needed in the REST API filter query during list creation itself.
Below is the ...
- 1,817
0
votes
1
answer
2k
views
Trying to upload files to sharepoint using REST API ,Python using Postman
import requests
url = "https://xxxxxx.sharepoint.com/sites/QE/Shared%20Documents/_api/GetFolderByServerRelativeUrl('product-xxxxx-metrics/xxxxx-dashboard-automation')/Files/add(url='test.csv',...
- 21
0
votes
1
answer
197
views
Authentication for custom REST API invoked from SharePoint online pages
I have a modern UI web part in SharePoint Online. This component needs to invoke a custom REST API that will be hosted in an Azure web app (not SharePoint REST API). I may also call this API directly ...
- 666
0
votes
0
answers
42
views
How do I set a person or group field via the API V1 using Rails with Faraday?
I've seen several similar questions and the crux of the answer seems to be that I should add "Id" to the field name and pass the user's id. Here for instance:
How to update "Person or ...
0
votes
1
answer
177
views
SharePoint Online Managed Path
Does anyone know how to get this information through rest API or PowerShell? I wanted to know if the tenant I am working with is using "/teams/" or "/sites/". I am creating an ...
- 236
0
votes
3
answers
191
views
Error Gibberish download file from sharepoint using rest api
I need to download a file from a sharepoint list using the rest api, the endpoint I use is the following:
https://mysite.sharepoint.com/sites/testsite/_api/web/GetFolderByServerRelativeUrl('/sites/...
0
votes
1
answer
216
views
Help with SPFx and Dataverse
I'm trying to do CRUD functionality on a Dataverse table from an SPFx app. I keep getting the same error:
To view the information on this page, ask a Global or SharePoint Administrator in your ...
- 21
1
vote
1
answer
2k
views
SPONLINE - How to generate a sharing link via REST?
I have a big need from a customer :
An external application needs to create folders and documents in a SharePoint Site.
Then, it will need to generate external links to share those documents to a ...
- 592
0
votes
1
answer
436
views
Office365-REST-Python-Client copy between two sites
I am struggeling to copy a file from one sharepoint site to another. Lets say i want to copy from: https://test.sharepoint.com/Site1/A/
to : https://test.sharepoint.com/Site2/B/
i have not yet found a ...
- 1
0
votes
1
answer
1k
views
Is there a way to export a list as a csv file with the Rest API?
Via the user interface in Sharepoint there is the possibility to export a list as .csv. Unfortunately, you can only load the items from the list via the Rest API, but not download the entire list as a ...
0
votes
1
answer
125
views
How to select/create a custom field in the REST API
We currently use the following format to retrieve a list of data from SharePoint Online and it works fine, but how can I do a similar query that returns a different field "as" the Id field?
...
- 101
0
votes
1
answer
145
views
Is it possible to make batch requests on different sites? And what about the same site but different subsites?
I'm trying to get itens from different subsites but in the same site (it would be nice to know the method to different sites too, if possible) and when I try to do the same way when I do in same site ...
- 1
0
votes
1
answer
125
views
Issues creating a SharePoint REST api POST request to upload an image and metadata
I am trying to upload an image to a photo document library, currently I seem to get authorization errors when trying to post data but my user account has read and write access to the library, would ...
- 47
0
votes
1
answer
348
views
adding approved domains into white list via rest and flow
i have a flow that runs and it adds domains into the white list for a given site. The flow runs fine and the domain is added into the list. Issue is, when the user for a given domain logs in with the ...
- 17.8k
0
votes
1
answer
411
views
Proxy to get data from SharePoint REST APIs
We have a react frontend application. The data source for this app is SharePoint Online list and libraries.
We found a solution in node js that serves our purpose, to call REST APIs from react front-...
- 774
0
votes
1
answer
2k
views
getFileByServerRelativeURL fails when the filename contains a pound(#)
I'm using the SharePoint online REST API. Things generally work fine, but I'm failing to figure out how to get information about a file (document) that contains a pound in its name. Here's my REST ...
- 1
1
vote
2
answers
2k
views
Getting the Graph ID for a SharePoint document using the CSOM or REST api?
If we are crawling sharepoint online, we can access these data from API using:
MS graph API
or
SharePoint REST API (CSOM, ODATA)
All of our code uses the CSOM rest API for SharePoint.
But, for each ...
0
votes
1
answer
105
views
Listing all sub-sites that you have access to in a site collection
In my situation, I have a site collection
`/sites/mysitecol` - site collection
- `/sites/mysitecol/test1` - sub-site - my user has access to this site.
- `/sites/mysitecol/test2` - sub-site - my ...