Calling PnP from within Python

[aefruswg]

Hey all,

Me again. The information provided in my last question was helpful, but we're still stuck. We're currently trying to write a Python script that will call Connect-PnPOnline and then run Set-PnPDefaultColumnValue as needed. However, we're running into the error below when trying to connect.

import subprocess
certPath = r"C:\Users\user\PnP.Device.pfx"
clientId = '12345'
command = [
    "pwsh", "-Command",
    f"""
    Connect-PnPOnline "https://tenant.sharepoint.com/sites/sharepointsite" -ClientId "{clientID}" -Tenant "tenant.onmicrosoft.com" -CertificatePath "{certPath}"
    Set-PnPDefaultColumnValues -List "Library" -Folder "Folder" -Field "Field" -Value "12345"
    """

The specified certificate at 'C:\Users\user\PnP.Device.pfx' could not be read. The certificate could be corrupt or it may require a password which has not been provided or is incorrect

This also happens if the variable values are hardcoded in the Connect-PnPOnline command instead of passing Python variables. The code above is only set to modify a field on a specific folder for testing purposes rather than iterating through data as we intend. We're able to connect using the same PFX file on any machine we've tried from and it does not require a password. This only happens in this specific scenario of calling from within Python. We also still can't figure out how to set the default value within Python which is frustrating, so we're trying to make this process work.

Thanks in advance.