One Star

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.
1 REPLY
One Star

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.