# Node-RED to sharepoint (Solved)

**URL:** <https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564>\
**Category:** FAQs\
**Created:** [7 December 2018 13:53 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564 "2018-12-07T13:53:07Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![weky](https://avatars.discourse-cdn.com/v4/letter/w/94ad74/32.png) [@weky](https://discourse.nodered.org/u/weky)\
**Post date:** [7 December 2018 13:53 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/1 "2018-12-07T13:53:07Z")

</div>

Hello Every one!  
I am try to save data to sharepoint list, but gets this error. any solution or ideas  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/9/96c36f0722f0240ddb1fe27d77950d65e206f21f.png)  
has any one done something like this.  
thanks in advance

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [7 December 2018 13:57 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/2 "2018-12-07T13:57:04Z")

</div>

Hi @weky - I'm not sure anyone here can say anything more than the error message does - `You do not have permission to perform this action or access this resource`

Have you checked your credentials etc?

---

<div class="post-metadata">

**Author:** ![weky](https://avatars.discourse-cdn.com/v4/letter/w/94ad74/32.png) [@weky](https://discourse.nodered.org/u/weky)\
**Post date:** [7 December 2018 14:01 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/3 "2018-12-07T14:01:40Z")

</div>

@knolleary  
Hi thanks, but i have checked my credentials and permissions. every thing is good on that side.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [7 December 2018 14:08 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/4 "2018-12-07T14:08:53Z")

</div>

Try googling sharepoint error code and the number...

---

<div class="post-metadata">

**Author:** ![dustinw](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dustinw/32/3426_2.png) [@dustinw](https://discourse.nodered.org/u/dustinw)\
**Post date:** [7 December 2018 17:16 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/5 "2018-12-07T17:16:59Z")

</div>

@weky what connection method are you using (i.e. rss, odata or the soap api) and what authentication are you using?

I haven't used SharePoint with Node-Red in particular, but getting SharePoint authentication to work with out the Sharepoint client libraries can be tricky.

---

<div class="post-metadata">

**Author:** ![weky](https://avatars.discourse-cdn.com/v4/letter/w/94ad74/32.png) [@weky](https://discourse.nodered.org/u/weky)\
**Post date:** [7 December 2018 17:24 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/6 "2018-12-07T17:24:58Z")

</div>

i was using basic auth but it was not working  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/7/7d05c4f15ec17dbf15df203eb0550af14192d0d6.png)  
but I have solved it by registering an app on SharePoint tenant. and then used app ID and secret to get access token. then sent access token in the header.

---

<div class="post-metadata">

**Author:** ![dustinw](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dustinw/32/3426_2.png) [@dustinw](https://discourse.nodered.org/u/dustinw)\
**Post date:** [7 December 2018 20:02 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/7 "2018-12-07T20:02:06Z")

</div>

Nice work!

The SharePoint API doesn't support Basic Authentication by default (you can force it on Premise by hacking IIS, but I don't think there's anyway to make it work with SharePoint Online).

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [8 December 2018 14:09 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/8 "2018-12-08T14:09:03Z")

</div>

> [@weky](#):
>
> but I have solved it by registering an app on SharePoint tenant. and then used app ID and secret to get access token. then sent access token in the header.

Correct, sorry I missed this so couldn't respond in time. SharePoint Online requires "modern authentication" generally OAuth.

I would be very interested in a working example (without the authentication details of course) since SharePoint Online is something we use a lot at work. Having a working example to update a list from Node-RED could be quite handy.

---

<div class="post-metadata">

**Author:** ![olab](https://avatars.discourse-cdn.com/v4/letter/o/d07c76/32.png) [@olab](https://discourse.nodered.org/u/olab)\
**Post date:** [18 April 2019 07:29 UTC](https://discourse.nodered.org/t/node-red-to-sharepoint-solved/5564/9 "2019-04-18T07:29:03Z")

</div>

I have not checked this myself, but there is an api to ms online called ms graph. I just descovered there is a node called node-red-contrib-viseo-ms-graph that can use this api to i.e sharepoint (OAuth2 Authentication). I think you then can insert/read data from a sharepoint list (or any other ms online application)

Data is sent recived as JSON

Ola