Anaplan Connect Batch Script - States Operation is Successful yet no data loaded to list
I'm having issues where an anaplan connect import batch script, runs stating "The operational was successful. Name of List: 3515 <0/3515> rows successful, 0 ignored. (It always uses 3515, even thought there may be 90 records in the load file.)
I've reviewed the Anaplan Connect document which outlines some possible reasons for the file to not load and tried out the suggestions quotes, escape characters, to no avail. The file does get loaded to the Anaplan server as I can see it as a source.
Here is the source operation variable I'm using: set SourceOperation= -certificate %certificatepath% -file "%InputFile%" -put "%put%" -import "Action Name" -execute
When I review the command during run time, the values are %certificatepath%, %InputFile%, and %put% are appropriately filling in. I've tried using -debug and -output, and am not seeing anything obvious in the output.
The input file is a .csv file that is semi-colon separated (semi-colon is designated in the file to list mapping).
When I choose a file to import manually in Anaplan (throught the action the script is calling), there are no issues loading the data into the list.
Any other thoughts, as to why the script runs, the file is uploaded to Anaplan but not into the list.
Thank you, Robin