Skip to main content
  • EN

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!

Hi ​@jomaura great question! I would have to test this to confirm, but I believe we can only “create” folders when the Data Source > Upload = Folder. If the Data Source > Upload = File it will expect the folder path to already exist. There should be two workarounds to this:

  1. Have the folder structure already created before upload (like you suggested)
  2. if you know beforehand which folders do not exist you could:
    1. Create your folder structure from the BoxConnector
    2. Test for this condition (with/without existing folders)
    3. Send to two different SharePointOnlineConnector
    4. Set this new SharePointOnlineConnector to Upload > Folder (with the new folder structure) 

I’m not sure what you have set in the BoxConnector, if you are downloading to an attribute then this second workaround would probably be a lot to set up. Let me know if this works for you or if it sparks any ideas. 

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.