|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

SFTP List Directories - What's the correct syntax for Directories

Udzielono odpowiedzi
Zamów wersję demonstracyjną

I'm trying to use the SFTP command "List Directories" for a specific folder. When I use the wildcard "*" I'm able to connect to the directory but when I use a filepath to a more specific folder I get the "Directory not found" error. Am I using the correct syntax for "Directory" here?

Also, when I use the full filepath --- \WorkivaUnum\Finance\Out\Annual Statutory Reporting\Test File.csv --- I get the same error. 

Thanks!

Ryan

0

Komentarze

Komentarze: 8

Data Głosy
  • Paige Ringhofer

    Hi Ryan,

    Thanks for reaching out! I spoke with some of our experts and they mentioned that your Full Path is missing a "\" Please let me know if there is anything else we can help with!

    Thanks!

    0
  • Ryan Clark

    Where should I place the missing "\"? I've tried a couple different versions of this but I'm still getting errors. 

    0
  • Paige Ringhofer

    So in the Full Path screensnip you sent, there are two "\" but the full filepath you sent only has one "\" at the beginning. Let me know if that changes anything!

    Thanks! 

    0
  • Ryan Clark

    Gotcha, sorry these were inconsistent. I've tried a lot of different iterations of directory name. This does not fix the issue.

    Is there any place within Workiva/Wdata to see what directory SFTP is connected to? 

    Similarly, using the "SFTP Connection - Get" command what format does the "Destination" have if I want to send the contents of an uploaded CSV file to a Workiva spreadsheet? 

    Thanks!

    0
  • Jeff Hickey

    Hi Ryan, sometimes it is possible that the user's home directory is not what you're expecting if someone else set it up. A good way to figure out the location path is to start at the beginning and work your way toward the file. What I mean by this is to configure the List Directory command to show everything at the root directory by entering just a period in the Directory field so you can establish your starting point. Screenshot example is below:

    Publish and run the chain to see the output in the LOGS tab. From here you should be able to see any subdirectories available and start to build your path. For example you may see the directory 'WorkivaUnum'. Modify the List Directory command to use this path such as "./WorkivaUnum/." and repeat running the Chain until you work your way to the file your after.

    For the Get command, if you're using CloudRunner, a period is sufficient for the Destination field.

    0
  • Wade Bouley
    • Edytowano

    Hello, I'm having the same issue as Ryan. It seems like no matter the iteration I use it's not working. I tried the . period suggestion and that didn't work either. Is there any documentation for specific syntax on how to enter directories in SFTP connection? I'm also wondering what format using the "SFTP Connection - Get" command does the "Destination" need to have if I want to send the contents of an uploaded CSV file to a Workiva table? Is there any Workiva documentation with actual syntax requirements for these fields?

     

    1
  • Wade Bouley
    • Edytowano

    Looks like all I had to do was put a * in the directory path and that worked. I'm not sure how the connection knew what file path to look at is though.. for context - my field path is something similar to this: e:\directory\WORKIVA

    There are multiple other folders inside of the directory folder so I'm not sure how Workiva connection knew to look at the WORKIVA folder but nonetheless we got it to work. If anyone could provide any insight into how that is working then that would be great. Also if anyone could provide information on how to put the files in a workiva directory on workiva web after I use the get command that would also be super helpful. Thanks everyone!

     

    0
  • Jeff Hickey

    Hi Wade Bouley,

    Glad you got this work! An asterisk acts as a wildcard, while a period refers to the current directory. A wildcard means that it matches any sequence of characters within filenames or directories.

    If you are seeing the WORKIVA directory as the root directory rather than e or e:\directory, it is possible that the SFTP server administrator who provisioned the SFTP login credentials changed the root directory for the user to e:\directory\WORKIVA. If you do need to access a higher level directory and are unable to, I recommend contacting the SFTP server admin for clarification on access.

    Now that you are able to retrieve the data from the SFTP server, there are several ways to load the data into Workiva. Where you need the data loaded in Workiva will ultimately decide the necessary commands in your Chain. For example, if you are going to load the data into a Wdata Table, I recommend utilizing the Load Data to Wdata template. 

    0

Zaloguj się, aby dodać komentarz.