|
A partire da gennaio 2021, i tipi di file classici non potranno più essere utilizzati. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

How do I pull the latest file from a table?

Con risposta
Richiedi una demo

Task 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

0

Commenti

3 commenti

Data Voti
  • Tony Scalese

    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

    0
  • Arpit Srivastava

    Hi Tony,

    Pull the latest file from Wdata table.

    0
  • Tony Scalese

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

    0

Accedi per aggiungere un commento.