Forum Discussion

ragera4's avatar
ragera4
New Contributor II
8 years ago

Connecting Windows based SFTP servers using SnapLogic

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”: “Ca...
pmancevski's avatar
pmancevski
New Contributor III
3 years ago
Copy LinkReport

Hi @aprabhav,

For the sake of discussion 🙂 and if adding additional field resolve your issue.
If you are concern about id duplicates, you can always do a quick look up into the table and get the most recent id. After that snap.in.totalCount + look up value.

For example:
param1 = 222;

Result:

Thanks,
Pero M.

aprabhav's avatar
aprabhav
New Contributor III
3 years ago
Copy LinkReport

Thanks Pero for your helpful suggestions.

It should not be required to add the serial column data in the input document.

I was able to fix this problem by doing the following…

  1. specified the list of columns (excluding the serial id column) in the Columns list in the snap
  2. used ‘Text’ option for the format field in the snap
  3. unchecked ‘Header provided’ field in the snap.