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

[sdeng]

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

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

[cstewart]

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]

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

[nandudevi05]

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