I’m trying to access our sharepoint via python, I’ve almost tried all the tutorials in the internet but nothnig seems to work because our sharepoint uses a SSO. I always get an Access denied message when using the script but I can access the web api using my browser.
Here is my only code so far because I’m still trying making a connection to the sharepoint.
<code><span class="kwd">import</span><span class="pln"> requests
</span><span class="kwd">from</span><span class="pln"> requests</span><span class="pun">.</span><span class="pln">auth </span><span class="kwd">import</span> <span class="typ">HTTPBasicAuth</span><span class="pln">
headers </span><span class="pun">=</span> <span class="pun">{</span><span class="str">'accept'</span><span class="pun">:</span> <span class="str">'application/json;odata=verbose'</span><span class="pun">}</span><span class="pln">
r </span><span class="pun">=</span><span class="pln"> requests</span><span class="pun">.</span><span class="pln">get</span><span class="pun">(</span><span class="str">"https://sharepoint.com/sites/mysharepoint/_api/web"</span><span class="pun">,</span><span class="pln"> auth</span><span class="pun">=</span><span class="typ">HTTPBasicAuth</span><span class="pun">(</span><span class="str">'dir\user'</span><span class="pun">,</span> <span class="str">'password'</span><span class="pun">),</span><span class="pln"> headers</span><span class="pun">=</span><span class="pln">headers</span><span class="pun">)</span>
<span class="kwd">print</span><span class="pln"> r</span><span class="pun">.</span><span class="pln">json</span><span class="pun">()</span></code>
I always get this error code.
<code><span class="pun">{</span><span class="pln">u</span><span class="str">'error'</span><span class="pun">:</span> <span class="pun">{</span><span class="pln">u</span><span class="str">'message'</span><span class="pun">:</span> <span class="pun">{</span><span class="pln">u</span><span class="str">'lang'</span><span class="pun">:</span><span class="pln"> u</span><span class="str">'en-US'</span><span class="pun">,</span><span class="pln"> u</span><span class="str">'value'</span><span class="pun">:</span><span class="pln"> u</span><span class="str">'Access denied. You do not have permission to perform this action or access this resource.'</span><span class="pun">},</span><span class="pln"> u</span><span class="str">'code'</span><span class="pun">:</span><span class="pln"> u</span><span class="str">'-2147024891, System.UnauthorizedAccessException'</span><span class="pun">}}</span></code>
(Visited 771 times, 1 visits today)
if you are trying to execute against sharepoint, you will need to create a client context using CSOM, and passing in the current user’s credentials.
Unfortunately there is no ootb CSOM library for python. But there are a couple on Github.
https://github.com/vgrem/Office365-REST-Python-Client
(Visited 1 times, 1 visits today)
