MS SharePoint Online

[KevR_F1]

 Hi, 

I'm looking for some help with authenticating from LabVIEW to Microsoft SharePoint using a client_id and client_secret

I have a snippet of Python code that seems to do the trick, but I am looking to do this all in LabVIEW as my solution needs to be compatible back to LV2011. Initially I tired using the RESTful API but hit a dead end as it would only give me a username and password (I'm not an expert in Python).

Here is the python:

from office365.sharepoint.client_context import ClientContext
from office365.runtime.auth.client_credential import ClientCredential

site_url = '<myURL>'

app_principal = {
'client_id': '<myClientId>',
'client_secret': '<myClientSecret>',
}

credentials = ClientCredential(app_principal['client_id'], app_principal['client_secret'])

ctx = ClientContext(site_url).with_credentials(credentials)

web = ctx.web

ctx.load(web)

ctx.execute_query()

print("Web site title: {0}".format(web.properties['Title']))

Again through google search I came across a MS article doing something similar with the SharePoint Client dll. However I get stuck at the context.load(web) function as it does not appear to be part of the property node.

Complete basic operations using SharePoint client library code | Microsoft Docs

Any help would be greatly appreciated, or advice with how to do this a better way through LabVIEW. Ideally I would want to use the RESTful API as this is well documented across the web with doing various tasks on Sharepoint.

Thanks

Kev

[Jay14159265]

---

@KevR_F1 wrote:

 Hi, 

I'm looking for some help with authenticating from LabVIEW to Microsoft SharePoint using a client_id and client_secret

I have a snippet of Python code that seems to do the trick, but I am looking to do this all in LabVIEW as my solution needs to be compatible back to LV2011. Initially I tired using the RESTful API but hit a dead end as it would only give me a username and password (I'm not an expert in Python).

Here is the python:

from office365.sharepoint.client_context import ClientContext
from office365.runtime.auth.client_credential import ClientCredential

site_url = '<myURL>'

app_principal = {
'client_id': '<myClientId>',
'client_secret': '<myClientSecret>',
}

credentials = ClientCredential(app_principal['client_id'], app_principal['client_secret'])

ctx = ClientContext(site_url).with_credentials(credentials)

web = ctx.web

ctx.load(web)

ctx.execute_query()

print("Web site title: {0}".format(web.properties['Title']))

If you have python that works, try using a LabVIEW python node. see this (or google it): 

https://blog.sasworkshops.com/python-node-basics/

Once you open a handle in python you may need to keep calling the python session to interact with it. 

[KevR_F1]

Hi, 

Thanks for your reply. I wish it was as simple as that. My code needs to be backward compatible with LV2011 which the python node is only support as far back as LV2018, unless I am misinformed (Link). 

Many thanks

Kev