Questions tagged [sharepoint-rest-api]
Using the Representational State Transfer (REST) interface provided by SharePoint
1,630
questions
0
votes
2
answers
18
views
how to retrieve lookup fields from files
I am trying to expand the following lookup fields, but I am finding it hard:
/_api/web/GetFolderByServerRelativeUrl('/sites/Acts/Shared Documents/2022_1')/Files?$expand=ListItemAllFields
{
"...
- 1,316
0
votes
1
answer
13
views
Send HTTP Request CopyTo File to different document library - Power Automate
I am receiving a 400 Status error with my Power Automate app. I am unsure as to why, it seems there's an issue with my current code but unfortunately, I am unable to find it.
For Convert to PDF, the ...
0
votes
0
answers
13
views
Rest API Search output schema issue - change in the order
We have noticed below changes in the Search Rest API output schema (JSON Output), earlier these default columns (Rank, DocId) used to come as the first two nodes
"RowCount": 1,
"...
- 324
0
votes
1
answer
15
views
Users with contribute permission can call REST API to Break Role Inheritance , but can not make a REST API call to get all role assignments
I have a power automate flow which runs under a user who have Contribute permission on a list item, the flow consists of 2 actions:-
First action is to break role inheritance, while the second flow ...
- 984
0
votes
1
answer
22
views
Sharepoint REST ValidateUpdateListItem return error response
any help would be appreciated
Thank you
SharePoint 2019 on-premise
I'm making a REST request using ValidateUpdateListItem to update Author and Editor; however, I'm getting an error message: Multiple ...
- 101
0
votes
1
answer
11
views
Getting a file by serverrealtive url is raising this error "Server relative urls must start with SPWeb.ServerRelativeUrl"
We have a SharePoint onpremsies 2019, and inside it we have a site collection as follow:-
https://ourcompany.com/sites/ABC
so we are trying to get the details of attachment inside a list named ...
- 57
0
votes
1
answer
22
views
Filter Query with Rest API (Internal Name or New Name)
I am making a fetch to retrieve information from a SharePoint list that meet a certain criteria.
I need the EndDate to be greater than or equal to todays date. I also need to other columns to equal a ...
- 107
0
votes
1
answer
29
views
too many lookup fields in the Rest API URL exceed the size limit
I have too many lookup fields which are like 40+. Using the URL format below exceeds the URL limit which I believe it is 2084.
/_api/Web/Lists/GetByTitle('DepartmentWing')/Items?$select= ../Id,../...
- 1,316
0
votes
1
answer
14
views
Get user properties from active directory based on user Id when user does not exist in the site using REST API
Using the following rest api resource /_api/web/getuserbyid(1), I can get only the users who already have access to the site.
My problem is that I would like to get the user properties for all users ...
- 1,316
0
votes
0
answers
21
views
PNP/SP not working in team context
I have created the SPFX tab webpart with crud Operation in sharepoint list
Not working in Microsoft teams app
but this webpart working in sharepoint page because its getting SharePoint context
I am ...
- 37
0
votes
1
answer
12
views
Explain SP authentication please
I operate in an environment that has thousands of SharePoint sites. And I need to get a list of all the site "Titles".
My approach has been to use PowerQuery in an Excel workbook calling ...
- 193
0
votes
1
answer
18
views
Schema/structure of objects returned from RenderListDataAsStream and List/fields
Modified RenderListDataAsStream request:
curl --request POST \
--url 'https://XXX.sharepoint.com/sites/pilotTeamSite/_api/web/GetList(@listUrl)/RenderListDataAsStream?%40listUrl='\''%252Fsites%...
- 11
0
votes
0
answers
16
views
Sharepoint API PictureThumbnailURL returns unauthenticated
I use the sharepoint search API to get the latest newsarticles from sharepoint.
This works for me
https://tentant.sharepoint.com/_api/search/query?querytext='PromotedState:2'
I also get returned an ...
- 101
0
votes
0
answers
12
views
Sharepoint HTTP request Search API - receive only Title value
I`m trying to use HTTP request to Sharepoint. I want to search specified list and receive few column values from that request.
My URI looks like that:
_api/search/query?querytext='@{replace(variables('...
- 1
0
votes
1
answer
50
views
How to get more than 100 rows from REST API through curl call
I am using top=500 to display the items from SharePoint using below curl command, but still am getting only 100 rows in the out file:
curl -D ~/header_test.txt --ntlm --request GET --netrc "http:/...
2
votes
1
answer
58
views
Seeing different values between modern and classic list views
I have a SPO site with a modern experience list of about 4,000 items. I used "Edit in grid view" from the modern experience to make a lot (almost all the items) changes to values in one of ...
- 2,879
1
vote
1
answer
40
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 ...
- 582
1
vote
2
answers
22
views
CSOM API how to find claims accounts unassociated with a site
I'm trying to find claims accounts that are not associated with a site. These would be "{SiteName} Owners" and "{Site Name} Members" users that are automatically created in ...
- 13
0
votes
2
answers
18
views
How can I get reporting managers of all the employees in my organization from SharePoint
How can I get reporting managers of all the employees in my organization from SharePoint in a single API call?
- 76
0
votes
2
answers
41
views
Dynamic Site Address in HTTP request to SharePoint
I'm working on app that is giving SharePoint Users Groups as a result. Finally I finished almost everything - the last condition I have to complete is dynamic site address, so my app and flow could be ...
- 25
0
votes
0
answers
19
views
Copy folders between SharePoint sites with Python?
I want to copy a folder and its contents from one SharePoint site to another. The folder class has a method copy_to() but as far as I can tell it can only copy to a folder within the same SharePoint ...
- 1
1
vote
2
answers
47
views
How to connect SharePoint online list to insert data from out side the SharePoint platform using
We have a requirement to push data from the external application into the SharePoint online list.
Please guide me on the steps and specifically the how the authentication should happen from external ...
- 347
1
vote
1
answer
39
views
How to display result of HTTP Request as list
So finally I know how to get users groups using HTTP request to SharePoint in This question.
Now I need to display these groups as list in Power App. (Or it can be organized text).
The raw output ...
- 25
0
votes
1
answer
98
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
79
views
the security validation for this page is invalid and might be corrupted. Please use your web browser's Back button to try your operation again
I am making a POST request to Sharepoint List and in that I have to add items more than 150 which takes my like 45-50 mins to add all the Line details. And once I have added I click on submit and then ...
- 1
0
votes
1
answer
79
views
SharePoint Online: Rest API not working with people filter for list with more than 5000 items
I'm trying to use SharePoint rest API to get items from a SPO list. It has around 15K items. But I'm using filters and expecting less than 30 items in the result. It works fine when normal columns are ...
- 17
1
vote
1
answer
73
views
Getting SharePoint Groups of User using HTTP Request in Power Automate
So currently I'm working on task, that will return all groups that user triggering the flow is member of.
I stuck on this:
My teammate gave me a hint, that this way is proper, but I need something ...
- 25
0
votes
1
answer
58
views
Filtering question with using Modified column when is equal to todays date - Power Automate
I'm trying to filter a list using Get Items in power automate.
Something like this: Modified eq 'TodaysDate'
But the modified field date has got a date and time and my TodaysDate filed has only date.
...
- 4,122
0
votes
1
answer
11
views
Update default value of site column and update lists with REST
I want to change the default value of a site column and update all lists that contains that site column, with the new default value.
I already found how to change the default value with REST API, but ...
- 1
0
votes
2
answers
31
views
Unable to update list item using POST and REST, but able to preform other POST tasks. Using Python Requests and Sharepy
I'm able to authenticate and run GET and POST commands. But I am unable to update a list item. Or create a new list item.
I'm using Python Requests and Sharepy(handles authentication). What am I ...
0
votes
1
answer
24
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
1
vote
2
answers
35
views
SharePoint API get items in Document Library does not return .xlsx or .docx items
I am trying to retrieve a list of documents in our document library using the API. I do a GET call to https://mysite.sharepoint.com/sites/RapidMachiningSolutionsLLC/_api/Web/Lists/getbytitle('...
- 11
0
votes
0
answers
13
views
User with Full Control access to a site collection is not able to add users to group (System.UnauthorizedAccessException)
I am a Site collection admin and I am able to add users to groups via Rest API. But another user who isn't an admin, but has 'Full Control' access tries, he gets this "Access denied" message....
- 1
1
vote
1
answer
33
views
How to Remove the Current User email from a dropdown list [closed]
const getDropdownDataFromMaster
= ():
void =>
{
let UserEamilArray = [];
let userEmail = props.context.pageContext.user.email;
console.log(userEmail);
console.log("heyyy&...
- 21
0
votes
0
answers
29
views
SharePoint rest api not bringing items but ItemCount is over 300
http://sitename/_api/web/lists/getbytitle('List Name')?$select=ItemCount
gave me a ItemCount of 320 but when I send a Request on
http://sitename/_api/web/lists/getbytitle('List Name')/items
The JSON ...
0
votes
1
answer
41
views
Sharepoint Rest API: Create Folder Columns and set values for items
I am looking for documentation to manage folder columns and ability to create the columns if not exists on the folder and set the values of these columns on the item using SharePoint REST APIs.
_api/...
0
votes
0
answers
16
views
How do you add metadata when uploading a photo through the REST API?
I would like to add some metadata to my uploaded image to a Photo Library in SharePoint 2013, for example I have added the photo by making the following jQuery ajax request:
{
url: http://example....
- 35
0
votes
1
answer
31
views
Error Posting to Person or Group Field
When I submit the info to the list, I was getting the following error (which I assume is due to
trying to incorrectly post to a Person or Group column:
A 'PrimitiveValue' node with non-null value was ...
- 107
0
votes
1
answer
19
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
66
views
The security validation for this page is invalid and might be corrupted. X-RequestDigest
I have an HTML form that I am trying to send (POST). And I keep getting the following 403 error: The security validation for this page is invalid and might be corrupted. Please use your web browser's ...
- 107
0
votes
1
answer
27
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 ...
- 35
0
votes
2
answers
75
views
Links in Site Pages Library: Get using Rest API
I am working on SharePoint Online. Inside the 'Site Pages' library, I have created a few site Pages and I also create a 'Link' item using the New > Links option. I use the 'Link' to connect to a ...
- 101
0
votes
0
answers
66
views
Get Excel data via rest API from a spreadsheet in a SharePoint (gov) site
I'm trying to get data from a SharePoint site using the rest API but I'm not sure I'm doing it in the right way. This is what I have been trying in Postman.
I have successfully generated the access ...
- 101
1
vote
1
answer
17
views
SP 2016 Lookup Field with Rest API returning Value does not fall within the expected range
I have a lookup field that works with the .js file isn't hooked up to the form. When the .js is hooked up to the form, which I click "Save" the Promotion Name field errors with "Value ...
- 21
0
votes
1
answer
20
views
What is the REST URI that does the same as the CAML Query shown here
What is the REST URI that does the same as the CAML Query shown here
This CAML Query (works great):
CamlBuilder().View().RowLimit(5000).Query().Where().TextField('ItemDescription').Contains('laptop')....
- 3
0
votes
0
answers
29
views
POST request for Upload File doesn't work
I have a running program that has been working for 6month + on production.
It suddenly doesn't work with returning 403 error, but the request is working for update metadata, and get file.
The client ...
- 1
0
votes
1
answer
101
views
SharePoint content type based metadata column is not updating in Document library
I have created a site column that is a metadata type column. From that site column, I have created a content type that content type is assigned to the Document library. Now I have tried to update that ...
0
votes
1
answer
124
views
SharePoint Rest API Post Request fail
I try to fetch items from list in SharePoint 2019 using Rest API
but the request fail with the following response Message:
"could not be resolved by the model. When a model is available, each ...
1
vote
1
answer
355
views
Power Automate HTTP request to filter list by a column other than Title never halts
I'm using the "Send an HTTP request to SharePoint" action in a Power Automate flow. If I set the URI to be:
_api/web/lists/getByTitle('myListTitle')/items?$filter=Title eq 'Example'
It ...
- 13
0
votes
0
answers
62
views
Filter "User Information List" to get active user
Can I get list of user using "User Information List" hidden list with following criteria:
Only Active Users
Excluded SharePoint Groups
http://siteUrl/_api/web/lists/getbytitle('User ...
- 1