We want to process orders from our dealers and let them drop their JSON files on their own assigned folders, like the folder structure below:
- /Orders/Dealer01
- /Orders/Dealer02
- /Orders/Dealer03
- /Orders/Dealer99
On the source FTP connection, there is the option "Directory Path" under "Where would you like to transfer from?". If we set the directory path to just /Orders, Is there a way you can make the flow scan and process all the files on all the subfolders? This way we will only create one FTP connection source.
Would appreciate any advice or workarounds. Thanks!