https://community.qlik.com/t5/Talend-Studio/Extracting-data-from-Sharepoint-tfilefetch/m-p/2247105#M32402 <P>Hi all,</P><P>I have two questions</P><P>My requirement is I will get an excel file from Share point.</P><P>How can I fetch the data from it?</P><P>Here is the sample link I get the data from</P><P><A href="https://MYCOMPANYNAME-my.sharepoint.com/personal/jOSH_nel_MYCOMPANY/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fjay%5Fnelson%5FMYCOMPANY%5Fcom%2FDocuments%2F" target="_blank" rel="nofollow noopener noreferrer">https://MYCOMPANYNAME-my.sharepoint.com/personal/jOSH_nel_MYCOMPANY/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fjay%5Fnelson%5FMYCOMPANY%5Fcom%2FDocuments%2F</A></P><P><BR />If there is anything to know about share point let me know</P><P>If data comes in any day of any week the data should process how can I achieve it?</P> Thu, 12 Mar 2020 13:39:38 GMT TharunJoshi 2020-03-12T13:39:38Z https://community.qlik.com/t5/Talend-Studio/Extracting-data-from-Sharepoint-tfilefetch/m-p/2247105#M32402 <P>Hi all,</P><P>I have two questions</P><P>My requirement is I will get an excel file from Share point.</P><P>How can I fetch the data from it?</P><P>Here is the sample link I get the data from</P><P><A href="https://MYCOMPANYNAME-my.sharepoint.com/personal/jOSH_nel_MYCOMPANY/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fjay%5Fnelson%5FMYCOMPANY%5Fcom%2FDocuments%2F" target="_blank" rel="nofollow noopener noreferrer">https://MYCOMPANYNAME-my.sharepoint.com/personal/jOSH_nel_MYCOMPANY/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fjay%5Fnelson%5FMYCOMPANY%5Fcom%2FDocuments%2F</A></P><P><BR />If there is anything to know about share point let me know</P><P>If data comes in any day of any week the data should process how can I achieve it?</P> Thu, 12 Mar 2020 13:39:38 GMT https://community.qlik.com/t5/Talend-Studio/Extracting-data-from-Sharepoint-tfilefetch/m-p/2247105#M32402 TharunJoshi 2020-03-12T13:39:38Z https://community.qlik.com/t5/Talend-Studio/Extracting-data-from-Sharepoint-tfilefetch/m-p/2247106#M32403 Hi <BR />There are no direct components to process the data in Sharepoint. You need to download the file to local system using tFileFetch or tHttpRequest, and then read the file using tFileInputExcel. <BR /> <BR />Regards <BR />Shong Sat, 14 Mar 2020 08:32:34 GMT https://community.qlik.com/t5/Talend-Studio/Extracting-data-from-Sharepoint-tfilefetch/m-p/2247106#M32403 Anonymous 2020-03-14T08:32:34Z