Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx saving to sharepoint

oneillp111
9 - Comet

I have a workflow that I downloaded from a SharePoint site.  The file saves in my downloads and opens automatically.  When I hit run, it takes a file from the C:\ drive and saves a copy of it to the SharePoint site. 

 

workflow.png

 

First it adds a column to the end which has the filename to save as, file name is like:

 

link.png

 

The output takes the file name from the field and changes the entire path

 export.png

 

When I run it I get the following error:

 

 

 

 

 

 

 

Error: Output Data (120): Unable to Open archive for zipping: C:\Users\username\Downloads\https:\\sites.inside-share2.company.com\sites\105630\Documents\Reports\2019\September-2019\September-2019.xlsx Error Opening file: C:\Users\username\Downloads\https:\\sites.inside-share2.company.com\sites\105630\Documents\Reports\2019\September-2019\September-2019.xlsx
: The filename, directory name, or volume label syntax is incorrect. (123)

 

 

 

 

 

 

It is adding the workflow file location to the [ExportName] field, "C:\Users\username\Downloads\".  I cannot figure out why.... Can anyone help?

2 REPLIES 2
BrandonB
Alteryx
Alteryx

See danilang's post below

danilang
19 - Altair
19 - Altair

hi @oneillp111 

 

Put a Browse tool after your second formula and check what the value of the fields [filename] and [file] are and compare them to what you think ExportName should be. 

 

Even once you get this fixed, Alteryx can't write directly to SharePoint libraries without using WebDAV, so your URL 

https:\\sites.inside-share2.company.com\sites\105630\Documents\Reports\2019\September-2019\September-2019.xlsx

won't work  

 

You can find details of how to work with WebDAV here

 

Dan

Labels