How to read api xlsx file?

[sudarshank]

Hello,

I have use tFilefetch component to get excel data but it is not working.

Error:

[Anonymous]

Hello @sudarshan khandu​ ,

Could you please change the Protocol to http for tFileFetch component to re-try?

Please refer to the article

https://community.talend.com/s/article/How-to-download-a-file-from-SharePoint-using-tFileFetch-eq7eb?language=en_US

Best regards

Aiming

[Lord-Vader]

If im not wrong, the tfilefetch downloads the file. To read it you have to use like a tfileinputdelimited.

But from your situation here seems like your file is not found. Try to use the url in your browser and see what it does.

If it downloads the data.xlsx file then its working, but surely your gonna get the 404 not found error.

idk how your api here works so i can only help you to an extend.

Hope this helps.

Vader out 💪.