ConnectingCData Python Connector for Office 365 2019 - Build 19.0.7416
Connecting with the cdata.office365 Module:
The connector's module is used directly to establish a connection with the data source. It is able to take a connection string as its argument, as in the below example:
import cdata.office365 as mod conn = mod.connect("InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;") cur = conn.cursor()
Once the connection is created, you can execute subsequent SQL queries using the connection's cursor object.