shareplum | Pythonic SharePoint | Content Management System library

Like you mentioned there is MFA enabled for your account. Looks like you have not handled the same in your application.

There 2 ways to go about this.

1. Provide Interactive logon UI for handling the MFA.

2. Create a service account which has the MFA disabled. Thereby using this account to access the Sharepoint Online, you will not encounter the above issue.

3. Using App Only Authentication

What are Sharepoint app only ?

App only authentication - will not require user credentials but you can get the data by authenticating the App. And Also, app authentication will indirectly bypass MFA (App only authentication are not subjected to MFA).

More information : https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs

I was reading through the Shareplum Tutorials - Unfortunately, but could not get the way to do the App Only Authentication. But you could double check at your end.

If your goal is to use python, you can also use the below library :

https://pypi.org/project/Office365-REST-Python-Client/#Working-with-SharePoint-API

To perform the app only authentication :

It seems that you're trying to connect to SP online. Please specify Version parameter then try it again.

Idea 1

It's hard to tell what can go wrong without the error trace. But I suspect it's likely to do with malformed data that you are passing as the argument. See here from the documentation to know exactly what's expected.

Do also consider updating your question with relevant stack error traces.

Idea 2

JSONDecodeError: Extra data: line 1 column 5 (char 4)

This error simply means that the Json string is not a valid format. You can validate JSON strings by using this service. This often tells you the point of error which you can then use it to manually fix the problem.

This error could also be caused if the object that is being parsed is a python object. You can avoid this by jsonifying each line as you go

Found the answer. I went into SharePoint List Settings on Office 365 and changed it from Enhanced Rich Text to just Rich Text and it is showing properly now in my web app.

That was a good enough answer for my needs.

Sample demo to use Office365-REST-Python-Client to get SharePoint list data and output as excel.

Sample demo:

Please take a reference of below sample, i have tested it on my SPO environment.

Modify the code as below.

The simple answer: Cryptography has several different builds between what your production server would recognize and what you tried to grab from Github (As an example, Anaconda has several 2.7.x build options of cryptography, 15 to be precise https://anaconda.org/anaconda/cryptography/files) which makes sense because you are trying to use two different Python languages and forcing them to interact but they don't understand each other.

Think of your problem like this: Imagine trying to have a conversation in English (or any language for that matter) with someone from the 1800s - technically you two are speaking the same language but you wouldn't understand each other as over the course of two hundred years because the language has evolved in complexity and meaning. For reference, Python 2.7.0 was released in July 2010, Python 3.7 was released 2017.

There is a hard way and a easier way to resolve this problem.

The harder way is: Find the exact Python build of production server, download that 2.7.x version from Github or Anaconda. Then delete your current version of cryptography, install the compatible version of cryptography. Then make sure Anaconda recognizes the new branch, implement it your code and it should make it work on your production server. You will have to do some trial and error to get it right because other packages may have dependence issues with your older version of cryptography. Which given what you presented as your solution is what I believe you attempted.

However, to avoid your current frustration, there is an easier way: build a virtual environment for Python 2.7.x on your machine that matches the production server.

I would specifically use virtualenv, pip install your packages, then implement your code through it. That way your code and the production server use the same Python. I will add this small caveat: You may need to rewrite some of your code to make it work, because again, you built the code using the language of 2017, but you are conversing with the Python of 2010.

I'll get you started down the path with how to setup it up below, but I highly recommend reading the Python.org virtual environment page to educate yourself for future development (there are numerous articles and reference guides as well out there but start with the source): (https://docs.python.org/3/tutorial/venv.html)

To set up the virtual environment - pull up terminal and type the following below: