Qlik Talend Data Integration: How to download a file from SharePoint using tFileFetch

[TalendSolutionExpert]

You want to download a file from SharePoint using a tFileFetch component.

How To

1. Create a Job connecting a tFileFetch component to a tLogRow component.
    

   
    

2. Configure the tFileFetch component.
    

   
    

   1. Select http from the Protocol drop-down menu.
       

   2. In the URI field, provide the URL of the shared document. To get the link, right-click your SharePoint file and select Get a link.
       

      
       

   3. In the Destination directory field, enter the folder name where the fetched file will be stored.
       

   4. Enter a file name in the Destination filename field.
       

   5. Clear the POST method check box (enabled by default).
       

3. On the Advanced settings tab, select the Need authentication check box and provide the Username and Password that you use to access SharePoint.
    

   
    

4. Run the Job, and locate the HTML file in the destination folder.
    

   
    

   
    

5. Open the HTML file, and review the Excel file that is available on SharePoint.
    

   

Environment

• Talend Data Integration
• Talend Studio