tDropbboxList - How to read all Excel Files in a Dropbox Directory?
Problem: I have a number of Excel Files in a Dropbox Directory and I wish to process them one at a time. I have been able to successfully read ONE file from Dropbox using tDropboxGet performing the following:
And then process it in another Job: However, when I need to process multiple files, how do I utilize the tDropboxList component to do that? I have the following for now: I would ideally like to transfer all the files from the Dropbox Directory to a local directory and then call my job that processes them for each file through a loop. Any recommendations for that? Thanks for your time.
Re: tDropbboxList - How to read all Excel Files in a Dropbox Directory?
Solved part of the problem - Successfully Fetched all the files from Dropbox to a local directory: Now, to solve the next part of the problem - Read the Excel Files one at a time and process them in a Job.