topic How to read api xlsx file? in Talend Studio

How to read api xlsx file?

sudarshank — Tue, 06 Jun 2023 06:24:07 GMT

Hello,

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

Error:

Anonymous — Tue, 06 Jun 2023 09:34:59 GMT

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 — Tue, 06 Jun 2023 09:36:32 GMT

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 💪.