I have used 'arcpy.conversion.TableToExcel' to successfully write a spreadsheet to a location on MS OneDrive.
However, when I try to open the spreadsheet (using subprocess.Popen) it tells me the file does not exist. I think this is because the OneDrive file is synchronised to the local disk.
I think I can use the python MS Graph library to get a token for the file and then somehow synchronise it, but this python library is not present in the ESRI Python library set.
I can copy the file from OneDrive to my local disk using shutil, but I only want to do that for files on OneDrive.
Does anyone know of a way to identify OneDrive data and then synchronise it to the local disk using available ESRI Python libraries?