Moving zip file data

[ISBS_ROBOT]

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.

[mkankatala (Mahesh Kankatala)]

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!!

[Shiva_Nikhil]

@ISBS_ROBOT

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

[neha.upase]

Hi,

Try this

Directory.GetFiles(“C:\Users\Trainer\Downloads\20008414.zip”, “*.xls”).
OrderByDescending(Function(d) New FileInfo(d).CreationTime).
FirstOrDefault()

[ISBS_ROBOT]

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

[neha.upase]

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:

[Shiva_Nikhil]

@ISBS_ROBOT

use this syntax after extract/Unzip Files activity

system.io.Directory.GetFiles(“DestinationFolder",”*.csv”).OrderByDescending(Function(d) New
FileInfo(d).CreationTime).first