How do I pull the latest file from a table?
BeantwoordTask is to pull the latest file from a table, and upload it on a sftp server in .csv format.
List File command lists the different files present in the table (imported or staged) but the task is to pull that latest file with data and then upload it on the SFTP server intact
-
Hi Arpit,
When you say pull the latest file from a table, are you talking about a Wdata table or from an RDBMS like SQL Server, Oracle, etc?
Tony
0Hi Tony,
Pull the latest file from Wdata table.
0The List Files response gives you the Last Updated Time. So you can loop over the response and use Dynamic Variables to store the latest date and file ID. Once you have the latest date, then you can use the file ID to download the file and load to the SFTP site. Conversely, you could use JSON to CSV to convert the List Files response to CSV and then use advanced query to find the max date.
This tutorial on the OneCloud Knowledge Base illustrates how to use the Dynamic Variables in a loop (iteration) to show you the concept. This isn't the exact solution you need but it certainly shows you how to attack the problem.
Hope that helps.
0U moet u aanmelden om een opmerking te plaatsen.
Opmerkingen
3 opmerkingen