Questions tagged [sharepoint-rest-api]

Using the Representational State Transfer (REST) interface provided by SharePoint

Filter by
Sorted by
Tagged with
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, "...
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 ...
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 ...
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 ...
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 ...
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('...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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('...
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 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&...
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....
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 ...
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

1
2 3 4 5
33