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