クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

How do I pull the latest file from a table?

回答済み
デモをリクエスト

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

コメント

3件のコメント

日付 投票
  • 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

サインインしてコメントを残してください。