Connecting Windows based SFTP servers using SnapLogic

[ragera4]

Hello,

We’re trying to connect with Windows-based SFTP server in order to read data files, but getting the error as -

“error”: “Unable to read from sftp://sftp server//readme.txt”
“reason”: “Cannot open input stream for sftp://sftp server/readme.txt”
“resolution”: “Check for URL syntax and file access permission”

This is a very critical time of our program and any help or lead would be much appreciated.

Thanks!

[del]

I’ve found that sometimes FTP connections don’t interpret the file paths the same when logging on with an FTP UI client vs. when logging on with a service application like SnapLogic. The UI client might place you into the logged-in account’s home directory where /readme.txt might work while the application might require a full start-from-root path. So you might look at modifying the path to sftp://server name/repository path/login name/readme.txt or something similar.

[Joy]

Have you found a way to search the account’s home directory without hard coding that portion of the path?

[stephenknilans]

Joy,

One way you can you this on windows is to pretend that the directory in the home directory is the ROOT of what you want, and prefix it with:

%LOCALAPPDATA%....

SO, if you were a user with a home directory of \users\joy and wanted to save things in JUNK, just use:

%LOCALAPPDATA%....\JUNK

If HENRY had a directory \users\HENRY, the directory would be \users\HENRY\JUNK. Just realize that this is based on the user that actually STARTED the process.

There are supposedly simpler ways, but this was the first one I found that worked for ME.

[Joy]

Thanks for that info Stephen. I am using a Linux environment so I cannot port that solution directly. Similar options available in Linux didn’t worked for me due to the sftp and server prefix needed on the Dir/File snaps (the snaps won’t accept the user info as part of the search URL).

[Supratim]

@ragera4

Hi- Please check same configuration details with WinScp, if you able to connect via Winscp go to your folder and right click then copy path. You should use same path on snaplogic.
If from winscp also you are not able to connect then you might need to white list snap cloud/groundplex.