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.
272
questions
16
votes
3
answers
15k
views
Getting data from SharePoint Online with an App, service to service
I have registered an App in my SharePoint Online, and I can use it's ID and secret with the Office Dev PnP PowerShell library. Works like a charm. Now the issue is that we are trying to connect to the ...
- 7,372
14
votes
2
answers
8k
views
How to send a "like" or "unlike" command via REST API?
The structure of my REST-API Url is /_api/Web/Lists/GetByTitle('FAQ')/Items.
Each item can be liked by users (like in discussion boards).
How can I send a "Like" or "Unlike" command via REST?
- 261
11
votes
1
answer
4k
views
REST API Query Syntax
I'm trying to pull back all Projects that are Active and have a ProjectName="X". ProjectName is a lookup and Active is Yes/No. Here's what I have built:
http://<siteurl>/_api/lists/getbytitle('...
- 3,919
11
votes
2
answers
6k
views
The remote server returned an error: (403) Forbidden when accessing office365 site through external APIs
We have built a desktop app that import/exports SharePoint lists into/from Office 365 sites.
The app works perfectly, and we were able to do the import/export of Office 365 site pages for many clients ...
- 215
7
votes
3
answers
24k
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')/...
- 71
7
votes
1
answer
844
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 ...
6
votes
1
answer
2k
views
Using REST when colon appears in column name
I have a columns named 'Image:Thumbnail' and 'Image:Picture'. I am trying to refer to these columns using the REST API.
I have tried using '_x003a_' (as in 'Image_x003a_Thumbnail') instead of the ...
- 140
6
votes
1
answer
325
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
5
votes
3
answers
3k
views
$batch operations on SharePoint 2013 on-premise not working
I need to do bulk inserts and learned that there is the $batch operation in the REST API.
https://msdn.microsoft.com/en-us/library/office/dn903506.aspx
I read through this and following and explored ...
- 131
4
votes
1
answer
7k
views
How to do Microsoft Graph API Filter on Lookup Column in SharePoint List Items?
I am tried to apply Filter on Lookup column using Microsoft graph API filter. But it didn't filter. I have used below api to filter.
https://graph.microsoft.com/v1.0/sites/{sites}/lists/{listname}/...
- 880
4
votes
1
answer
8k
views
Download sharepoint document with REST as binary file not working for me
First of all, i am using node.js with provider hosted app with elevated rights to do this, no front-end at all.
I just want to download a file using the API and then save it. I can't save if the API ...
- 343
4
votes
1
answer
1k
views
Insert item in an external list via REST API
I'm trying to insert an item in an external list (a SQL server table linked to SP through BCS) via javascript...i thought it was simple but...
this is the function for insert
this.insertListItem = ...
- 71
4
votes
1
answer
825
views
Why do people prefer to use List Item Collection Enumeratror over the get_data method?
I wonder if anyone compared the two methods of handling ListItemCollection data in javascript:
var enumerator = collection.getEnumerator();
while(enumerator.moveNext()) {var current = enumerator....
- 2,750
4
votes
1
answer
3k
views
SOAP API to get site Collection Users
How can I get list of all users present in the SharePoint Site collection using SOAP API.
Is that possible? Please suggest something.
Because I have to use that URL in InfoPath form.
- 3,422
3
votes
2
answers
2k
views
sharepoint get list fields including dropdown options
I am trying to get the dropdown fields within a sharepoint list via the _api. See Image below:
https://one365dev1.sharepoint.com/sites/nieuwsportaal/_api/web/lists/getByTitle('Nieuwsberichten')/...
3
votes
1
answer
13k
views
Get CreatedBy using REST API SharePoint
How can I get CreatedBy field using REST API SharePoint? Below is the code
var Ownurl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('Listname')/items?$select=Author,ID&$filter=...
- 722
3
votes
2
answers
13k
views
SharePoint throttling: Receiving a 429 without any details
In an application I'm working, from time to time I see throttling related errors. In some cases I get a 429 error, like this:
429 TOO MANY REQUESTS.
However, I also get errors, with only the HTTP ...
3
votes
1
answer
6k
views
Get file data from REST
I am trying to find a way to combine two rest calls so that it gives me the correct files as well as the relevant data.
This call gives me the correct data
/_api/Lists/GetByTitle('Pages')/Items?$...
- 31
3
votes
1
answer
155
views
Weather api returns nothing in SP hosted app
I am building a SP hosted app in Office 365. The app is to get current weather, I am using api but it returns nothing. I have tried with the same code in ASP.Net Web Application and it worked. Why is ...
- 303
3
votes
1
answer
150
views
Create new item in sharepoint when a new record is created in salesforce
Newbie here to both Sharepoint and Salesforce. I have a customer that needs to get data automatically put into Sharepoint when a new order is created in Salesforce. Does anyone have an example of how ...
- 31
3
votes
1
answer
619
views
How to automatically update documents generated by another system as new versions?
We want to share documents in a SharePoint Document Library (SP 2013) which are automatically generated each week by another software system.
These documents are in PDF and RTF format (maybe also ...
- 1,021
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,385
3
votes
0
answers
53
views
Reaching subsites of SharePoint domain
I am writing an application that scrapes all the files from a given SharePoint site and all of its sub-sites.
This worked perfectly when I ran it locally however, now that it's running on a server ...
3
votes
0
answers
346
views
Update metadata w/2013 REST API in a Workflow
I am looking for an example of a REST PUT/MERGE method done from a workflow (no code) in SharePoint Designer to update a metadata field in a library. Specifically what the Build Dictionary and Call ...
2
votes
2
answers
15k
views
Update person or group field using REST API in Document Library
I want to update the Person or Group field in Document Library using REST API.
How can I achieve this.
Thanks.
- 722
2
votes
1
answer
442
views
Was -NoADLookup Removed from New-SPOMigrationPackage?
In the SharePoint migration API, you use the SharePoint Online Management Console, in 2015-June they added the -NoADLookup parameter to the New-SPOMigrationPackage command.
It appears as though the ...
- 725
2
votes
2
answers
3k
views
Start Workflow from Sharepoint Designer with REST call (Workflows 2013)
The following REST call:
https://{server}/{site}/_api/SP.WorkflowServices.WorkflowInstanceService.Current/StartWorkflowOnListItemBySubscriptionId(subscriptionId='caa09cae-3955-4c26-bb7e-24b4a95294b0',...
- 81
2
votes
2
answers
718
views
Access Graph API from localhost (SharePoint extension)
I'm developing a SharePoint extension (ListViewCommandSet extension).
I have no clue (can't find any docs about this) how to give permissions to access Graph API (even the /me call gives a 403 ...
- 135
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
2
votes
1
answer
663
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
2
votes
2
answers
10k
views
SharePoint REST API Document Library - filter by folder name
I'm running a JavaScript script that updates permissions on folders in lists and document libraries. To do this I need to get the ID of the item I want to update. The folders all have unique names ...
- 23
2
votes
1
answer
356
views
Is it possible to set a Person or Group field through the REST API when the user is not listed on /sites/mysite/_api/web/siteusers?
My goal is to set a Person or Group field value on a new record to a user who may not have logged into the subsite "mysite" (and does not exist at endpoint #2 below), but who does exist at root ...
- 23
2
votes
1
answer
2k
views
Limit and filter List
I have a list with more then 100 rows, so I added limit to the url.
I have two questions:
How can I set it to not limit with no write a specific number (like 1000)?
How can I add a filter to the ...
- 21
2
votes
1
answer
3k
views
Download multiple files at a time from using HTTP Rest API Calls
I am able to download a file from SharePoint using the API GetFolderByServerRelativeUrl.
However I'm looking to download selected files at once from SharePoint. Is there any possibility to do this?
- 21
2
votes
2
answers
229
views
Create SharePoint App that pulls data from multiple sites that are in different Site Collections
I'm working on a project at work where I am automating a process done in SharePoint 2013 that's currently done manually. The process involves uploading documents, applying properties of those ...
- 23
2
votes
1
answer
1k
views
Records Management CSOM API in SharePoint 2016
Does anyone know if with SharePoint 2016 (online) we finally get a CSOM interface to the records management functions?
- 1,057
2
votes
1
answer
2k
views
Execute crud operations using rest api outside SharePoint by .NET
I need to do CRUD operations on SharePoint online lists (intranet) using REST api from a standalone Asp.Net application which is hosted completely outside office 365 (on on-premise).
I know that it ...
- 2,086
2
votes
1
answer
481
views
Ajax call to SharePoint API returns '403 - Forbidden'
I need to access data on a SharePoint Online site from a php application. I'm using SharePoint API with JavaScript trying to achieve this. I already succeeded in accessing the SharePoint site with ...
2
votes
1
answer
343
views
why returned date from version history is different from actual date (triggerbody)
It seems the SP data repository and front-end SP list use two different timezones. when I get a date from version history it is different from what is actually shown in the SP list, how can I fix this?...
- 425
2
votes
1
answer
4k
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
2
votes
1
answer
578
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
2
votes
1
answer
8k
views
Sharepoint REST api search for a querytext in a site
I am having issue while searching using query text in a specific site. When I use following get query,
https://client.sharepoint.com/_api/search/query?querytext='vpn', I get results in the entire ...
- 21
2
votes
1
answer
450
views
Sharepoint Online 2016 - Send Email to External Users API
I need to know if there is a way, or if there is going to be a way, that its possible to send emails to external users from a Sharepoint 2016 Add-in.
I have found quite a few posts saying this was ...
- 153
2
votes
2
answers
130
views
Web API Content into a SharePoint list
Is it possible to post data retrieved via a Web API into a SharePoint list? my scenario is that I want to pull some data from a third product via its WEB API and post it if possible into a SharePoint ...
- 1,020
2
votes
1
answer
1k
views
Weather App Part for SharePoint Online
I need to implement weather widget on my SharePoint Online portal. Below are my basic requirement.
• Each user of the portal tagged to specific location worldwide. Every time user logged into ...
- 23
2
votes
0
answers
97
views
Programmatically grant app permissions to site collection?
Is there an API that let's me register an application (App ID) to a site collection like I would do in the below dialog?
2
votes
2
answers
2k
views
MS Graph presence - forbidden 403 error
I'm getting 403 forbidden error in my SPFx web part when trying to access Teams presence (mine and other users as well). I have set permissions in package-solution:
Permissions:
{
"resource": "...
- 51
2
votes
1
answer
269
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
0
answers
248
views
How do I monitor SharePoint Online API usage?
Our company stores projects in Office 365 SharePoint Online, creating one site per project utilizing site templates.
We then use SharePoint Workflows, PowerBI, Microsoft Flow, PowerApps, and custom C#...
- 21
2
votes
0
answers
902
views
Access-Control-Allow-Origin' not allowed access SharePoint Ajax call cross domain
I am trying to access cross domain service using ajax call in sharepoint.
getting below error
Failed to
"Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-...
