โ04-10-2019 12:44 AM
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
โ04-10-2019 06:17 PM
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.
โ04-10-2019 07:20 PM
I created the file in excel format and loaded it to the file server.
โ07-29-2023 03:57 AM - edited โ07-29-2023 03:58 AM
Hi sdeng.. can u please tell me r u got solution for this MFT account in snaplogic?