Questions tagged [sharepoint-rest-api]
Using the Representational State Transfer (REST) interface provided by SharePoint
1,560
questions
0
votes
0answers
4 views
Invite external users to office 365 programmatically using "jsom"
I need to invite external users on office 365 using JSOM or REST API then as per requirements I need to get newly added user and will add that user into a SharePoint subsite's permission group.
I can ...
0
votes
0answers
11 views
List view treshold exceeded
I have a problem when getting list items.
When I want to filter them, I always get the error The attempted operation is prohibited because it exceeds the list view threshold. Event if I should not ...
0
votes
0answers
10 views
I am adding a file to the folder using SharePoint API showing content as base64string value
Does anyone have a link or document to make rest sharp SharePoint API to add a file to the folder with byte array payload?
Any help is great; thank you in advance.
GetFolderByServerRelativeUrl('list')...
0
votes
0answers
14 views
Get List item body content, format CanvasContent1
I'm own a website and I want to display on it Sharepoint data through the rest API.
I managed to get Lists and lists items. But the content of the list item is in the key CanvasContent1.
The ...
0
votes
1answer
17 views
Is it possible to dynamically add new choice field values/options if I check 'Allow fill in choice' to true (REST API)
Is it possible to dynamically add new choice field values/options while creating a new list item through rest API if I check 'Allow fill in choice' to true?
Example
The choice field 'ChoiceFieldName' ...
0
votes
0answers
10 views
SPO link pages as translated versions using REST API
Is it possible to link already existing page as translated version of another using REST API? I found a nice article about how translations are formed https://www.eliostruyf.com/multilingual-apis-...
1
vote
0answers
15 views
SharePoint Server 2019 on-premise REST API Authentication
I need to read list data from SharePoint 2019 on-premise server, from an external server. I have tried calling the REST API but I am having trouble authenticating.
Things I have tried:
Calling REST ...
0
votes
0answers
7 views
Get a list of all of the available members who have access to a specific list who are part of Forms Based Authentication
If possible I would like to create a PS script that will return a list of all the users who have access to a specific list, specifically the members that are also members of the Forms Based ...
0
votes
1answer
8 views
List all the members of SharePoint groups with Graph API
Is there any endpoint in the Microsoft Graph API fore SharePoint Online to list all the groups and members of SharePoint groups? It must also be possible to manage the users from those groups.
As ...
0
votes
0answers
27 views
Group by count of people picker column
Below is my rest call to get data from sharepoint now also want count value of each FunctionalManager to respect to his TeamMember so if I am FunctionalManager of 2 TeamMember will get count of 2
...
0
votes
1answer
25 views
Sharepoint Rest API, Get files from a list throwing unknown 500 errors only when a file is present
I've been setting up an app to query a Sharepoint Document list for files (amongst other things). Querying {{mainLink}}sites/{{subsite}}/_api/web/lists/Documents/Files on postman with the following ...
0
votes
0answers
10 views
Site Collection for a logged-in user or user specific
I am having a problem getting specific user sites. I want the logged-in user to have a list of sites that have access. To achieve this goal, I am using the following:
Site Address:
https://{Company}....
1
vote
1answer
16 views
Get a Document Set's description field via the REST API
I need to get the description field from my list of document sets. I have a for-loop set up with the titles of each of the document sets, I now just need to query the REST API to return a description ...
0
votes
0answers
33 views
Search REST search query with exact match, how?
We have a REST query to _api/search/postquery and it includes a query like this:
ParentLink="https://{site}/{library}/{folder name}"
Most of the time it is working correctly. But in some ...
0
votes
0answers
22 views
Use search rest api to search in SharePoint list items
I have to search through the SharePoint list item and the content of attachments of the SharePoint list item which is in SharePoint Site A.
I have used the below API
https://abcv.sharepoint.com//_api/...
1
vote
1answer
103 views
Org Chart not working for People pIcker
Reference of plugin
https://www.jqueryscript.net/demo/Fully-Customizable-Organisational-Chart-Plugin-With-jQuery-OrgChart/
I am using List schema as TeamMember(PeoplePicker),FunctionalManager(...
2
votes
1answer
17 views
Power Automate Reminder flow error
I am trying to create a flow that takes the Expiry date from the list and sends an email to outlook.
This is my list:
This is my flow:
I have added this string (Should send a reminder when 1 day is ...
0
votes
3answers
26 views
The data in API does not shown in the web part for User
I am very new to SPFx web part creation.
I have created simple SPFx web part using typescript.
Added package to app catalog then added in my page.
The issue that I am facing is user doesn't read the ...
0
votes
1answer
15 views
How to establish a real time connection to a list item using SharePoint Rest API
On my SharePoint home page I have a notification element that is ajax'd from a list item from the same site collection. I would like the user to always (or as often as possible) see the latest ...
0
votes
1answer
18 views
Adding a new item in the SharePoint list with multiple fields
My objective is to add a new item in a SharePoint list (Form) using REST API.
My current code is:
function AddData() {
var listName = "Form";
CreateListItemWithDetails(listName, ...
0
votes
0answers
9 views
Is there a difference between the /Files endpoint and the /Children endpoint with the Sharepoint Rest API
I'm currently working out how to iterate through files on a sharepoint using rest. Ultimately I'll have to get all files from a folder, do stuff, and then upload to another folder. From what I can ...
0
votes
1answer
22 views
SharePoint Rest API to select Url from File Version
I have used the following URL:
https://xyz.sharepoint.com/teams/Analytics/_api/web/GetFolderByServerRelativeUrl('/teams/Analytics/Shared%20Documents/DataMaster')/Files('Transaction.xlsx')/versions
...
1
vote
1answer
21 views
Remove user from site group using PnP-SP in JavaScript
I'm trying to find a way to remove a user from a group using PnP-SP. My code is as follows:
this.$pnp.sp.web.siteGroups.getById(this.selectedGroup.Id).users
.remove(user)
....
0
votes
1answer
26 views
Create navigation item using REST API with non-existing link in SharePoint Online
I've stumbled upon issue where I need to create a link in navigation from root site which points to site collections.
POST Request URL: https://contoso.sharepoint.com/_api/web/navigation/...
1
vote
2answers
26 views
SharePoint REST API ensureUser call returns 400 Bad Request
My API call to my SharePoint site returns a 400 Bad Request when querying certain Microsoft 365 groups with the ensureUser API call.
We have a requirement to use Microsoft 365 groups, so I'm trying to ...
1
vote
1answer
28 views
Where is the secret list of field types kept?
I was trying to update a property on an existing SharePoint site column using the REST API.
I found some tutorials like this Stack exchange post or this blog.
They both have a __metadata property for ...
0
votes
1answer
38 views
After file upload: modify properties
First: I am a noob and I use the REST API of SP server with Java, so no SDK involved here.
I uploaded a file to a Document set. Now I have to modify the ContentType and some other custom fields (...
0
votes
1answer
14 views
In SPFx is it possible to check if we're getting data from a List or a Document Library?
I use PnP in an SPFx web part. I'm wondering is it possible to know if its a Document Library or a List that's being access in getByTitle?
var colsToSelect = [
"Title"
];
console.log('...
0
votes
0answers
25 views
Sharepoint REST API - Search - Giving "Application does not have administrative permissions in tenant" error
I am trying to call SharePoint search API using an APP registered on my SharePoint site. We are using SharePoint Online.
The App has permissions like:
<AppPermissionRequests AllowAppOnlyPolicy=&...
0
votes
1answer
14 views
How to know if Lookup column is deferred or not using REST API
I'm trying to use the REST APi to get data from a sharepoint list.
I first get the information about the columns: _api/Web/List<guid'some-id')/Fields.
Then with this information I query the data ...
0
votes
0answers
17 views
Change the selected view of calendar web part using REST or JSOM
I have a requirement where employees from different departments will book for work from office, but only 30% employees can book for a day.
Here I am using a content editor and calendar web part on a ...
0
votes
1answer
42 views
SharePoint REST API List View Threshold
I have a SharePoint List with over 5000 records created by me. The below query when using ID in filter works. But when I Filter With CreatedBy me it gives me List View Threshold Error.
Error:
_api/...
1
vote
1answer
17 views
SharePoint clear roles to a folder error
I try to clear assignment to a SharePoint folder. When I test it is not showing any error but appears this:
"BreakRoleInheritance": null
And the folder maintain the same permissions.
The ...
0
votes
0answers
15 views
Find files accessible by everybody using the API
I'm trying to find sensitive information stored in files that are readable by all users on the SharePoint tennant (such that it can be removed). If I have a specific file, I can classify it, but the ...
0
votes
0answers
18 views
_LikeCount and _CommentCount field is missing on CAM Query Request
Hi i am creating spfx webpart to display most liked and commented news however _LikeCount and _CommentCount not appearing on the result.
See below code:
props.topCount = props.topCount === undefined ? ...
0
votes
1answer
96 views
SPFx - How to get the URL and description from a hyperlink?
I'm trying to create a React SPFx web part which can render items from a SPO list.
I am having difficulty if the column is a Hyperlink. (I can get the value if it is a string).
Does anyone know how to ...
0
votes
0answers
56 views
Setting Author/Editor via REST ValidateUpdateListItem - Works Online but not OnPrem
So I have been using the ValidateUpdateListItem endpoint to set the created and modified dates with no problems in both 2013/2019 and Online and now need to do the same for Author/Editor fields.
I ...
0
votes
0answers
10 views
Set boolean in JSON using if statement
I am building a flow to copy all items in one SharePoint list to another SharePoint list in the same site. The target list varies, so I am creating the list name as a variable. I can't use the Create ...
0
votes
0answers
10 views
A provided field name ("_LikeCount"and "_CommentCount") is not recognized Graph Explorer
Hi i am trying to sort the result of my query by _LikeCount or _CommentCount of the Site Pages however i always got "A Provided field is not recognize" , any help is appreciated why it ...
1
vote
1answer
135 views
/_api/web/sitegroups/GetByName('GroupName')
We want to have a form in which a site member can request to add a team member, which is then automated.
In power automate we need the ID of the group:
/_api/web/sitegroups/GetByName('Test IRE Site ...
0
votes
0answers
11 views
How to show column item having with same value in sharepoint list count as one in selectpicker dropdown with dynamic id
I am trying to build a function that will show repeated column item of sharepoint list in selectpicker dropdown having dynamic id . It shows repeated column value instead count as one.
Below is the ...
0
votes
1answer
14 views
Not able to get Publish Start Date metadata using REST call from SharePoint Site Pages library
I am trying to get the News Post metadata using REST call. I am getting all the fields value but not Publish Start Date. This field is being added when I have turned scheduled option for the library. ...
0
votes
1answer
100 views
The property '__metadata' does not exist on type 'SP.Field'
I'm working on a flow that needs to create a column in a SharePoint library. I'm using the SP REST API for this. When I send start the I send the API request I get the following error:"
The ...
0
votes
1answer
22 views
How to get notified when a new list or library has been created?
We need to react to new document libraries and/or lists being created in SharePoint sites. Is there a way to get notified when this happens?
Graph change notifications currently only seem to exist for ...
1
vote
0answers
64 views
Rest API - Term Store - Unexpected response from the service
I followed this video https://www.youtube.com/watch?v=zIVmvFcQYmk&lc=UgyU12jRh89gXivRyMx4AaABAg.9O6kluxXSIp9O7pmC8uffx, in order to get terms by name from Term Store in SharePoint, but I got this ...
0
votes
1answer
19 views
Why using this REST API /_api/web/lists/GetByTitle('Mobile Device Request Form')/items(1473) will not retrieve all the fields
I have the following columns inside a SharePoint Online list:
But when I tried to query an item using HTTP request, using this URL:
https://****.sharepoint.com/sites/HomeOffice/en-ca/Forms/_api/web/...
0
votes
1answer
45 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
26 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
25 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
25 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 ...
