Questions tagged [api]
Application Programming Interface (API) is a set of functions and procedures allowing the creation of applications that access the features or data of an operating system, application, or other service. When used as a question tag, please be sure to describe in your question which APIs are being used.
265
questions
0
votes
1
answer
285
views
I want to get a user property using API REST
I am planning to get a user property (any information like email, id, title ... etc) using API REST,
https://m365x873105.sharepoint.com/sites/BBS-support/_api/web/siteusers(@v)?@v='c:0t.c|tenant|...
- 1,236
0
votes
2
answers
313
views
What is the API, given a user ID, to tell me permissions for a user of a list item ID?
I have an application that needs to be able to use my SharePoint API to check if a user AD\USERNAME has access to see a list item. I have the server relative URL of the list item, and the object ...
1
vote
1
answer
61
views
Unable to approve API permissions from API Management page
I created a custom web part that calls a web API I created. When I deployed the web part, I went to approve the required permissions and received the following errors:
[HTTP]:500 - [CorrelationId]:...
- 141
0
votes
1
answer
58
views
People / Group column looping through nested data
I am using Javascript / Jquery to pull list data. One of the fields is Author, which is a group / people field that allows for multiple users. I get the data, and I test if there is data in the ...
0
votes
3
answers
910
views
How to insert selected Checkboxes via Sharepoint 2016 API
I've been able to piece together the following code that "builds" a checkbox list in Sharepoint 2016. That was step one. Now, I'm trying to figure out how to loop thru the whole list of Departments ...
- 141
0
votes
2
answers
1k
views
How to save the value of a Yes/No Checkbox via Sharepoint 2016 REST API onPrem?
How do you save checked/unchecked for sharepoint 2016 on-prem via the REST api? I have a couple input text boxes saving text, but I'm can't save yes/no for cbAttending, I can't seem to get the value ...
- 141
3
votes
1
answer
1k
views
Handling The SharePoint REST API Search Threshold Limit In powershell
We are using SharePoint Online. I would like to search in all sitecollections for the word "passport". I make it working with the REST api in powershell. But I have now only the problem that it ...
- 4,395
0
votes
1
answer
130
views
Difference of two files using SharePoint
How do I get the diff of file1.csv and file2.csv from SharePoint (maybe using API calls, if possible)?
diff : Compare the contents of file1 and file2 and produce the list of changes necessary to ...
0
votes
1
answer
27
views
Adding request limit to Sharepoint/Office 365 API List search
I have a url I am using to query a list in Sharepoint formatted as below.
http://sites/sites/site/_api/web/lists/getbytitle%example%/items?$select=Email/EMail&$expand=Email
Because my list has ...
- 1
2
votes
2
answers
1k
views
Allow Sharepoint REST API app access to a singular list and nothing else
By default the permissions of a sharepoint app seem limited to read/write/full control over the entire site.
I'm looking for a way to grant a supplier access to a list but do not want them to be able ...
- 131
1
vote
1
answer
2k
views
Sharepoint Online Rest API - VBA - 401 unauthorized - SPOIDCRL token
I'm trying to use the rest api to get info about a doc library but keep getting 401 unauthorized - the code below worked for a bit for me but not other users now it doesn't work for me either...
I ...
- 11
1
vote
0
answers
30
views
C# api upload to SharePoint [closed]
I want to read and upload on SharePoint, anyone can help me ?
I use C# api. I try by Cloudinay and Api works.
- 11
1
vote
0
answers
232
views
SP.Utilities.Utility.SendEmail Anonymous User
I have a public website made with on premise sharepoint. Can I use rest api (SP.Utilities.Utility.SendEmail) to send email with anonymous user? I am trying but didn't work.
0
votes
0
answers
85
views
How to get the content of a specific document version
I am trying to retrieve the content of a specific version with Sharepoint API.
I can get metadata like this :
{
"d": {
"results": [
{
"__metadata": {
"id": "...
- 3
1
vote
1
answer
1k
views
The query to field 'list/ChoiceField' is not valid."
I have a lookup list that contains a choice field.
I'm trying to retrieve it's values using rest
Expand= "list"
Select= "list/ChoiceField"
I get
The query to field 'list/ChoiceField' is not ...
- 1,448
0
votes
1
answer
439
views
PWA Workflow gets Access Denied for API Call to get Assignments
I have a SPD 2013 Workflow on our PWA site that has been working fine for 6 months.
My colleague has left the business and Admin have disabled his 365 account.
Suddenly, the Workflow is failing and ...
0
votes
1
answer
66
views
how to know in which folder my file is
How can i Know, using my item metadatas, the folder it is stored in? For example, I do this Get Request :
https://sharepoint.com/sites/SPSample/_api/web/lists/GetByTitle('Documents')/items(2)/...
- 3
0
votes
1
answer
217
views
Log out SharePoint 2013 API
I am working on SharePoint API, and i have a login method which looks like that :
public void login(String configFileName) {
CredentialsProvider credsProvider = new BasicCredentialsProvider(...
- 3
0
votes
2
answers
2k
views
SharePoint 2013 Rest API (targeting specific columns)
Very new to SharePoint Rest API's, I got the rest to work filtering the first Column but now I am running into issues with showing the multiple columns for example. I am trying to filter out the ...
- 81
2
votes
1
answer
3k
views
Microsoft Graph/Sharepoint API search
The Graph API isn't well documented about a few things, and so I was wondering if anyone had some insight, or direct answers to the following problem:
Background
I am attempting to create a RESTful ...
- 121
0
votes
2
answers
202
views
Azure Sharepoint Application API Key generation
Introduction
I'm not a Sharepoint developer. I'm attempting to build an API from a php application to talk to the file storage within a Sharepoint site. From what I can The RESTful API makes the most ...
- 121
1
vote
0
answers
294
views
How to use RowsPerPage in the REST API
Whenever I send a request with RowsPerPage set, either via GET or POST, more rows than the RowsPerPage value are returned. RowLimit works though.
/_api/search/query?querytext='sharepoint'&...
- 131
0
votes
1
answer
164
views
Index all the rights
I have been trying to see the rights on folders within a sharepoint list. I haven't been able to do so with Powershell.
Is there a way to do it with Python? I need all the rights on all folders. So ...
- 1
0
votes
1
answer
145
views
Unable to update InformationRightsManagementSettings using REST
The following request returns Status 204, indicating it was a success but the informationrights settings hasn't become updated when I take a look the IRM-settings in the web gui for the list.
The ...
- 103
6
votes
3
answers
21k
views
How to get version history of item using REST
Very new to SharePoint so I am sure this is a newbie question... I did look at the forums. Here is the command I am using:
https://Server/Site/_api/lists/getbytitle('Equipment%20and%20Inventory')/...
- 61
2
votes
1
answer
643
views
SharePoint 2013 rest API get the average of calculated column
I have a calculated column for ticket response time
Want to get the average response time for all tickets
average response time = (sum of #response time)/ #of tickets
call: https://siteurl/_api/web/...
- 171
1
vote
0
answers
84
views
Yahoo Weather API stopped working in JQuery [closed]
I'm using the Yahoo API code to retrieve the weather information since last 5-6 years but it is stopped working since last couple of months automatically
var URL ='https://query.yahooapis.com/v1/...
- 31
0
votes
1
answer
469
views
Search SiteGroups API not working when case sensitive
I'm using the API to search for sitegroups as below:
"/_api/web/SiteGroups?$orderby 'Title'&$select=Id,Title,LoginName" + skiptop + "&$filter=startswith(Title,'" + value + "')"
However, I ...
- 1
1
vote
0
answers
682
views
How to use external API in sharepoint online or in SPFX?
I am trying to integrate the Microsoft Translator Text API to a SharePoint online site, and the method that I am using is with sharepoint framework webpart. but when I press the button to do the API ...
0
votes
1
answer
430
views
Sharepoint api search by properties
I am trying to see if I am able to search sharepoint from a given string
https://myShrp_URL/My%20Document/_api/search/query?querytext='Node: 592832'&selectproperties='Node'
I notice it is not ...
- 101
1
vote
2
answers
487
views
Rest Search API SharePoint
I am trying to retrieve images using REST SEARCH API from multiple Picture Libraries distributed across sub-sites(sub-sites are all under a single site collection https://xyz/site/*) .I also need to ...
1
vote
1
answer
3k
views
Rest queries on ProjectOnline should use _API/ProjectData or _API/ProjectServer?
I've been trying to identify what is the correct way to get data from Project Online for some time now (I just want to get data, not update it).
I can find documentation on ProjectData and a lot of ...
1
vote
1
answer
3k
views
How can we get the list items from multiple lists using Batch REST API?
I need to load all master data from multiple lists and bind it to from in form dropdown. For that I need to call every list separately.
Is there any option to call all the list in one query using ...
0
votes
1
answer
1k
views
Sync a Sharepoint list from GCP
Is it possible to create a Sharepoint that has APIs to synchronise the data with data stored on Google Cloud Platform?
I would ideally like to implement an API to keep the data in the Sharepoint list ...
- 101
0
votes
1
answer
976
views
Getting objects with today's date in Rest API
I need to fetch task objects which are completing today using Rest API , Can anyone please suggest how can we use today option to filer the data?
I am using below query:
/api/Objects/Task?$filter=...
7
votes
1
answer
714
views
Given a set of file URLs from sharepoint, what is the fastest way to download them all?
I have a list of SharePoint list item URLs and list item attachment urls. I need to download all the files from each one.
Overall:
I have over 50 000 000 files to download over 200 farms.
These ...
2
votes
1
answer
260
views
SharePoint 2013 REST API filters
As part of our requirement, i created one BCS connection which retrieves data from a SQL stored procedure which acceppts two input paramaters. I was able to create a external list out of it. But when ...
- 31
2
votes
1
answer
557
views
Sharepoint 2013 rest api group subtask with respective main task?
Want to display Task and sub-task using the rest api jquery. My query string displays task and sub-task as individual unrelated task.
- 171
0
votes
0
answers
285
views
401 - Unauthorized: Access is denied due to invalid credentials
I have a simple mvc api which saves a url to SQL and retrieves it. For some people it works just fine, but some of them do not have access.
Error: {"readyState":4,"responseText":"
Server Error
...
- 1,318
0
votes
1
answer
128
views
How to Authenticate Sharepoint User in Public Restful Service
we going to create a web application on sharepoint online with app parts. One of the app part will call the public restful service to get payroll information from SAP(ERP).
We have created a web ...
1
vote
2
answers
3k
views
Sharepoint REST API: Get filtered results of files in a document library subfolder and sub-subfolders
Let’s say I have a Document Library “Documents” with structured folders like this:
- Folder1(ID1)
- SubfolderA(ID3)
file-1-in-SubFolderA(ID4).txt
file-2-in-SubFolderA(ID5)...
- 11
0
votes
1
answer
22
views
How do I make Cross Site Scripting from External Content work
Currently using SP2013 on-prem and need to pull information from and in house application and display it on a page. Not using an iframe how can I pull specific information from a database and feed it ...
- 3
6
votes
1
answer
323
views
PNP JS in SharePoint
Till date we are coding custom solutions in SharePoint using JavaScript/jQuery/REST API, I need to know if there are any downfalls of using PNP JS as an alternate to REST? My company is pushing all ...
- 3,650
0
votes
2
answers
237
views
sharepoint API rest custom column http 400
I have a list in sharepoint, where I have put the totals of the columns I am interested in.
ID
Count=50
Certification
Count=9
I want to display these counts on another page. I have found a code to ...
- 1
1
vote
1
answer
1k
views
SP Online REST API Durable Document Link
My google searches have all led to dead ends.
Is there a way to retrieve the durable link code for a document using the REST API?
When you copy a link in the GUI, it takes the form of:-
https://...
- 45
0
votes
1
answer
342
views
jQuery and REST API to list all subsites and users in those subsites with full control
I'm looking to display on a web part in SharePoint online a list of all sub-sites and all users with full control to that particular site i.e.
Team Site Site Owners
https://ab/...
- 11
1
vote
3
answers
3k
views
Rest Api Filter on Number Field Starts with
On SharePoint 2013 On Premise, I need rest api filter where I can search some numbers in list starts with. Since records are around 100,000 I can not display all. Hence need a kind of search function.
- 766
1
vote
2
answers
1k
views
SharePoint REST API - update metadata Document Library Item when value string includes apostrophe (single quote) character
I want to update a metadata column for an item (document set) in a SharePoint document library using REST API (via VBA).
The below (vba) code extract/simplification works fine for simple cases, for ...
- 11
1
vote
2
answers
717
views
Get subfolders if folder name contains # (hash)
I am experiencing difficulties with getting the subfolders and files inside the folder that contains #.
API URL was: http://site url/_api/web/GetFolderByServerRelativeUrl('/#2')')/folders
API ...
- 13
0
votes
1
answer
308
views
App API Access to Single Site Collection
Is it possible to setup Azure based App permissions to only a single Site Collection? We are putting together a small application which will scrape external documents from various sites and dump them ...
