|
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

SFTP Get Destination

Répondu
Demande de démonstration

I have a chain connecting to an SFTP doing a "list directory" and then looping through each file to download and put it in a different SFTP server. This works, but it takes too long to loop through the 100+ files on the source SFTP. 

I'm looking to use the SFTP "Get" to get all the files in one go instead but I'm unclear on how to configure the "Destination" for this. It only allows for one connector so that obviously needs to be the source SFTP. I'm fine with doing multiple steps if I need to "get" the files somewhere and a separate step to then "put" them to the second SFTP location but where do they land in the interim? This is using a CloudRunner. Do I need to use the "Make Directory" File Utility to create a landing spot for them on the cloudrunner? How do I then reference that path as the Destination in the SFTP Get?

Everything I have tried so far as returned: ERROR: 4: Copying multiple files, but destination is missing or a file. from the Get.

0

Commentaires

3 commentaires

Date Votes
  • Jeff Hickey

    Hello Hanna,

    You could use the SFTP Get Command to download one or more files. If you would like to load them to a different directory or SFTP server, you could do so using the SFTP Put Command. This command allows you to Put multiple files or folders. Using these Commands may help to speed up the overall process you described above.

    During a Chain run, files exist temporarily during the life of the execution of the Chain at the level of the Runner. At the completion of the Chain run, the files the Chain used/created are cleaned from the Runner server.

    0
  • Wade Bouley
    • Modifié

    Hi Jeff, I'm unsure on how to upload a file retrieved by the Get command to a workiva directory in my web application. I don't want to put anything back on the SFTP server. I want to get the file from my SFTP server, put it in a workiva directory on my workspace, then upload that file to a table, then query the table, then create a view from that query, then update a pivot view. Can you advise on this? I'm unsure how to format the destination directory field in the Get command as there isn't any documentation that I've found yet.

    0
  • Jeff Hickey

    Hi Wade Bouley,

    The best way to load the file you retrieved from the SFTP server to a Wdata Table is with the Load Data to Wdata template. The documentation for this template will walk you through the steps to deploy and use the template.

    You can then use other commands such as Run Query and Download Query Result to begin building the second part of your question. If you have not reviewed it already, the Connected Learning Path Run a Query and Export Results is an excellent guide for a better understanding this process.

    0

Vous devez vous connecter pour laisser un commentaire.