I’m working on a site where clients will upload multiple CSV files - could be 100 or more. For this, I’m using the Multi-File Uploader - Dropzone. I don’t how many files the client will drag/drop into the uploader.
Just as a proof of concept, I set up a page where I only upload 3 CSV files. I use the Upload Data as CSV against each of the instances of the three files. So, I have three Upload Data as CSV actions and three Make Changes to a List actions because I’m adding two more fields to the target Type. This process works fine. Each CSV file contains ten data rows and a header row. The elements in the CSV file match the data fields in the Type.
To take the process further, I wrote a page that first adds the three files to a list of files in a Log file. Then, I use the Upload Data as CSV against each of the three instances in the list of files in the Log File. When I do this, I get the error message: "The column <?xml version=“1 does not match with a field on the chosen type.” The CSV files are exactly the same the ones in the Multi-File Uploader. The CSV column headers match the Fields in the target type.
Why would the Upload Data as CSV work when I point to the Multi-File Uploader, but not when I point to the list of files in the Log file? The CSV files are exactly the same.
My end goal is to write a recursive API Workflow that uploads as many CSV files as the client drags/drops on the Multi-File Uploader. But, I can’t do that right now because I can’t pass the contents of the Multi-File Uploader to the Workflow. I can pass the Log File that has the files.
I appreciate any assistance. Thanks