|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

How do I pull the latest file from a table?

Répondu
Demande de démonstration

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

Commentaires

3 commentaires

Date Votes
  • 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

Vous devez vous connecter pour laisser un commentaire.