Downloaded Excel Files not being moved with no data to Shared Drive

Help Studio
, ,
1

Hey all- I have an automation that runs through a 3rd party website that tasked with downloading and then moving an excel file to a specified location in a shared folder.

The issue I am running into is, when the file is downloaded and tried to move to a shared drive it will have no data and will be a blank file saying it cannot be located. The automation runs and works for PDF’s, it just does not work on the excel file. I have made sure the browser settings only downloads the file and does not open. This process in studio follows the same steps as the other PDF’s it successfully downloaded.

2

Hi!

If the file is big you might need to wait for the file to fully download.
You could create a while-loop with a delay and a check if file exists.

Expressed as a flowchart:

image
image559×610 6.36 KB

3

Thank you! The delay actually seemed to work I am curious though, the file size is generally only around 400-500 KB’s. Is it really just the delay that causes it to convert from a webpage to .xlsx?

4

Glad I could help!

It really is just the delay, a download or file transfer doesn’t happen instantaneous :slight_smile:

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.