Office365-REST-Python-Client VS powershell

it depends, if you want script microsoft stuff like active directory powershell is the way to go, if you have to manage microsoft cloud stuff like exchange online or azure ad powershell is still probably better but you can also use python with graph api and if you need to write a more complex script python might be easier

I am trying to connect to SharePoint Online using Python using Certificate Authentication using https://github.com/vgrem/Office365-REST-Python-Client

I have tried https://github.com/vgrem/Office365-REST-Python-Client and I have tried Connect-SPOService via PowerShell.

Or not.. I started checking for SharePoint libraries in Python, and this is pretty much the only thing I could find: https://github.com/vgrem/Office365-REST-Python-Client. Which I guess it is fine, if it wasn't because it seems as if 2 of the authentication methods they support are kind of old, and the third one does not suit my company's security requirements (basically, anything that requires me to bypass conditional access won't be approved).

Interesting, would the SDK be an equivalent to, for example, the Office365-REST-Python-Client, except that it is being provided by Microsoft officially?

If Microsoft were to provide an official Python library, I would feel pretty safe and they don't seem to shy away from integration with Python, but I don't know how to narrow it down looking at their different examples. Other options developed by outside sources seem to be stuff like the Office365-REST-Python-Client, Microsoft Graph Core Python Client, etc. Is there any particular recommendation on a stable and easy-to-use library?

I wanted to create service principal as I read on https://github.com/vgrem/Office365-REST-Python-Client/issues/191 but it requires app domain, and I am not using one.

Couple google searches brought me to this GitHub page. https://github.com/vgrem/Office365-REST-Python-Client

Here is my Module that includes my functions on Azure Extension Properties. It uses the PnP.PowerShellmodule instead of the Graph SDK.

# Use system-assigned managed identity # https://mmsharepoint.wordpress.com/2023/05/04/authentication-in-azure-automation-with-managed-identity-on-sharepoint-and-microsoft-graph/ # https://pnp.github.io/powershell/articles/azureautomationrunbook.html # Connect to multiple sites # https://github.com/pnp/powershell/issues/1748 # https://robdy.io/multiple-pnp-connections/ # Prod $SourceStr = Get-AutomationVariable -Name 'SharePointSourceFolders' $Target = Get-AutomationVariable -Name 'SharePointTargetFolder' #$SourceList = $SourceStr.Split([System.Environment]::NewLine,[System.StringSplitOptions]::RemoveEmptyEntries) $SourceList = $SourceStr.Split("\n") # Commmon Foreach($Source in $SourceList){ Try{ Write-Output "Source Folder: $Source" #Dev #$SourceSiteConnection = Connect-PnPOnline -Url $SourceSiteURL -Interactive -ReturnConnection #Prod $SourceSiteConnection = Connect-PnPOnline -Url $SourceSiteURL -ManagedIdentity -ReturnConnection #Get the total Size of the folder - with versions $SourceFolder = Get-PnPFolder -Url $Source -Includes ListItemAllFields -Connection $SourceSiteConnection $SourceFolderSize = $([Math]::Round(($SourceFolder.ListItemAllFields.FieldValues.SMTotalSize.LookupId/1KB),2)) Write-Output "Source Folder Size: $Source : $SourceFolderSize" $job = Move-PnPFile -SourceUrl $Source -TargetUrl $Target -NoWait -Overwrite -AllowSchemaMismatch -AllowSmallerVersionLimitOnDestination -Force -Connection $SourceSiteConnection $jobStatus = Receive-PnPCopyMoveJobStatus -Job $job -Wait -Connection $SourceSiteConnection if($jobStatus.JobState -eq 0){ Write-Output "Job finished" $jobStatus.JobState $jobStatus.Logs $SourceFolder = Get-PnPFolder -Url $Source -Includes ListItemAllFields -Connection $SourceSiteConnection -ErrorAction SilentlyContinue if($SourceFolder){ Write-Output "Second Try because folder: $SourceFolder.Name remains" $SourceFolderSize = $([Math]::Round(($SourceFolder.ListItemAllFields.FieldValues.SMTotalSize.LookupId/1KB),2)) Write-Output "Second Try Source Folder Size: $Source : $SourceFolderSize" $job = Move-PnPFile -SourceUrl $Source -TargetUrl $Target -NoWait -Overwrite -AllowSchemaMismatch -AllowSmallerVersionLimitOnDestination -Force -Connection $SourceSiteConnection $jobStatus = Receive-PnPCopyMoveJobStatus -Job $job -Wait -Connection $SourceSiteConnection if($jobStatus.JobState -eq 0){ Write-Output "Second TryJob finished" $jobStatus.JobState $jobStatus.Logs } else{ Write-Error "Second Try Status: $jobStatus" } } } else{ Write-Error "$jobStatus" } } catch { Write-Error "An error occurred: ${Source}: $_" } # Dispose the connnection variables $SourceSiteConnection = $null Write-Output "Sleep for 2 seconds" Start-Sleep -Milliseconds 2000 }

Reading - https://github.com/pnp/powershell/issues/277

The PnP PowerShell module is the one I would recommend for accessing SharePoint: https://pnp.github.io/powershell/

PnP is the module - it is amazing. The SP cli is a painful (but powerful) nightmare. https://pnp.github.io/powershell/