Hello All,
I’m facing an issue with a website. after clicking on download button file is getting downloaded in zip folder. I want to move the file inside the folder to another location so in move file activity I gave it as “Directory.GetFiles(“C:\Users\Trainer\Downloads\20008414.zip",”*.xls”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).ToList(0).ToString" but I’m getting an error like parameter is incorrect. Please help me with this.
Hi @ISBS_ROBOT
You have provided the File path in the Directory.getfiles you have to provide the folder path there.
If the folder is in zip it not able to fetch the files in the folder.
Hope it helps!!
first you need to extract all the files in the Zip folder.
use this activity and later use your syntax it will work
system.io.Directory.GetFiles(“C:\Users\Trainer\Downloads",”*.xls”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).first
cheers
Hi,
Try this
Directory.GetFiles(“C:\Users\Trainer\Downloads\20008414.zip”, “*.xls”).
OrderByDescending(Function(d) New FileInfo(d).CreationTime).
FirstOrDefault()
Hello,
Downloaded file is zip folder but file inside the zip folder is CSV format.
If I use read csv activity its saying couldn’t find the path. how to proceed further
Hi, first you need to unzip the folder and extract all files then use read csv
After extracting the zip contents, you can retrieve the path of the extracted CSV file using the Directory.GetFiles method:
Directory.GetFiles(“DestinationFolderPath”, “*.csv”).
OrderByDescending(Function(d) New FileInfo(d).CreationTime).
FirstOrDefault()
Example:
use this syntax after extract/Unzip Files activity
system.io.Directory.GetFiles(“DestinationFolder",”*.csv”).OrderByDescending(Function(d) New
FileInfo(d).CreationTime).first
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
