I am encountering difficulties when using the SharePointOnlineConnector transformer.
The flow is as follows:
-
I have an Excel file listing a series of files to download from the BOX service.
-
If the file is not yet downloaded locally, I download it to
G:\workspace\tmp
. -
I then modify the relative path by removing the filename: Example:
/xxx/xxx/xxx.zip
becomes/xxx/xxx
-
I upload the locally downloaded file to the target SharePoint site, using the modified path as the destination.
I successfully managed to upload around 700 files out of 3600 because facertains numbers of folders already exist into the sharpeoint site.However, I am now consistently getting errors such as:
UPLOAD_ERROR Could not find the folder.
It seems that I might need to create the subfolders first.
What would be the best way to proceed from now?

Thank you in advance for your help!