cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to read file content by using MFT as file server

sdeng
New Contributor II

We’re using MFT as file server, we’ve created an Basic Auth Account, it will got below error when reading the xlsx files. It’s not work for csv or txt as well. Is there any other account type we should use for this kind of file server? I’m using this format: AAA Sorry Page
image

I’ve tried to use below in the file reader as well, but all will get an error when reading the file. sftp://aaa.com:22/Foldername/a.xlsx
sftp://aaa.com:22/webclient/Foldername/a.xlsx
sftp://aaa.com/webclient/Foldername/a.xlsx
sftp://aaa.com/Foldername/a.xlsx
sftp://aaa.com:22/Foldername/a.xlsx

3 REPLIES 3

cstewart
Former Employee

It looks as though the failure is happening on the parse Snap, not the Reader. Perhaps you can try to do the File read from your MFT and temporarily write it to the local disk, then read with file reader and parse. This would help identify if the issue is the read from MFT or downstream. If you land the file, you may also check to see if you can ready it using Excel.

sdeng
New Contributor II

I created the file in excel format and loaded it to the file server.

nandudevi05
New Contributor II

Hi sdeng.. can u please tell me r u got solution for this MFT account  in snaplogic?