I have one workflow that pulls lots of data that I need to use and writes a CSV output into sharepoint – works great.
Then my next workflow takes that sharepoint CSV file and joins it with a mapping file(also in sharepoint). The workflow has no trouble reading the excel files in sharepoint but will not read the CSV file. It apparently can get through the same first three steps as the other sharepoint tools: 1. Plug in initialized 2. SharePointInput tool started 3. Plugin class successfully loaded, but then when it gets to the next step to “Read” the records in the file, it gets stuck.
I have tried configuring the input tool to read it the same way that the output tool is configured and it didn’t work. Alteryx community suggested I try “Double Quote” as the quote character and that didn’t work. I also tried to do a custom delimiter of quotation marks which didn’t work.
I have the most updated Alteryx Designer and Sharepoint add on tools so that is not a solution.
Are you able to Sync your Sharepoint to OneDrive? You can forgo the Sharepoint connector all together and use a regular input tool with your OneDrive folder path should be have permission to Sync that site to it.