Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [api]

The tag has no usage guidance.

13
votes
2answers
3k 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 ...
12
votes
2answers
4k 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?
10
votes
1answer
3k 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 ...
8
votes
1answer
3k 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('...
7
votes
1answer
168 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. ...
5
votes
1answer
661 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 ...
5
votes
1answer
204 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 ...
4
votes
1answer
2k 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 ...
4
votes
1answer
707 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 = ...
4
votes
3answers
2k 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 ...
4
votes
1answer
1k 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
votes
2answers
3k 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
1answer
141 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 ...
3
votes
1answer
62 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 ...
3
votes
1answer
274 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 ...
3
votes
1answer
275 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....
3
votes
0answers
41 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
0answers
327 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
2answers
856 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')/...
2
votes
1answer
5k 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=...
2
votes
1answer
1k 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}/...
2
votes
1answer
371 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 ...
2
votes
1answer
51 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/...
2
votes
2answers
2k 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 ...
2
votes
1answer
124 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
2k 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?$...
2
votes
2answers
41 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 ...
2
votes
1answer
3k views

How to post value in multiple user field via SharePoint REST API

I am new to SharePoint 2013 app develpoment, so I'm having trouble with some easy (I think it should be easy) REST Call. I got a list for issue tickets, which contains a user field column. In my SP ...
2
votes
1answer
824 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?
2
votes
1answer
879 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
votes
1answer
63 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 ...
2
votes
1answer
105 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.
2
votes
1answer
322 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 ...
2
votes
2answers
86 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 ...
2
votes
1answer
878 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 ...
2
votes
1answer
54 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 ...
2
votes
0answers
498 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-...
2
votes
1answer
2k 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 ...
2
votes
0answers
514 views

is on-premise Sharepoint 2016 REST API possible with oauth?

I have a Sharepoint 2016 server and a python web server. I would like to read data from Sharepoint with my python server. I was able to do this on Office 365 on the cloud but did not find much ...
2
votes
0answers
32 views

Unable to get all worksheets ranges with REST API

Maybe I am doing something wrong or I didn't get the way to get my data. I tried to call: curl -k --ntlm --user user:pwd https://sharepoint.server/dept/_vti_bin/ExcelRest.aspx/Department/mydoc/...
2
votes
1answer
414 views

How to get SharePoint survey graphical view results using API call?

I have create the survey list in SharePoint 2013.i have added some questions in it.i need to get the graphical response view using API call or programmatically. I need to display my own view in ...
2
votes
0answers
52 views

Add .aspx file via REST

I'm able to add a .txt file to my Sharepoint library by posting to this URL: https://my_subdomain.sharepoint.com/sites/my_path/_api/web/GetFolderByServerRelativeUrl('/sites/my_path/Pages')/Files/add(...
2
votes
0answers
352 views

SharePoint Online : Using REST API for getting list items return null

I am trying to create a Sharepoint hosted add-ins to get data list items. My code are below var hostweburl; var appweburl; //The SharePoint site where the App is installed hostweburl = ...
2
votes
2answers
588 views

Upload files with REST or alternatives

I need some help with Server to Server upload. (not from the browser) Has anyone uploaded files to sharepoint 2013, using REST, or other methods from a server (java/coldfusion/other). I am getting a ...
2
votes
1answer
858 views

Using html2Canvas API to generate images of custom aspx pages

So I have an html table I'd like to convert to an image and I found a pretty neat API to do exactly this. It's called html2canvas. I have been able to use it pretty easily using HTML pages in my ...
2
votes
2answers
3k views

Create an item with REST API from workflow - SharePoint 2013

The main idea of this is to create an item from workflow in another list which is located on different site collection. So I thought is it possible to create an item in list with REST API through the ...
1
vote
1answer
602 views

How get multiples users by id with REST API?

I need get multiple users by ID with REST API. I looked this question: How to get multiple users with REST API But is not answered. I've the ID's in an array: var people = [426, 352, 155]; I've ...
1
vote
1answer
2k views

Problem with workflow REST

I seem to be having a problem making a rest call to create a list or add a user to a SharePoint group. Both give me the same error - Response: {"error":{"code":"-1, Microsoft.SharePoint.Client....
1
vote
1answer
593 views

SharePoint 2013 REST API $expand issues

I'm new to using the SP API's and I am having an issue getting the required result using $expand on list lookup columns. I have 3 lists named ProjectList, SiteList, RegionList with relating lookup's ...