i have been downloading files from the webpage and extracting data from it but inbetween sometimes an empty file gets downloaded with random file name and the extraction process stops there itself because it couldnt read from it and i have no idea from where it gets downloaded automatically, i have also checked manually with it. so, if anybody has idea about this, please do share here
actually, i am trying to download multiple files from webpage and extracting data from it but inbetween a empty file gets downloaded and the process stops there itself
After getting filesize, if it empty, it would be 0 (i assume), in that case using validation condition, u can continue ur process
another way is to use try catch activity, since u are reading an empty excel file, may be there would error at that time, u catch block and handle error properly
this is the error i am getting since it is an empty file @NIVED_NAMBIAR all my file name contains po number in it and this file name is random and has nthg in it
Put the whole activities used inside the ForEach row activity under Try-Catch.
Incatch section, put exception type as System.Exception and the corresponding actions as Continue,
so in case of any error, when it goes to catch section, continue activity will helps to continue to next iteration even if the current iteration got failed,