Files need to move from SharePoint

[vamsitrack]

How can we move files from SharePoint to local using Talend Studio. And

what do we need for connection?

[Anonymous]

Hello,

To download the files from SharePoint, you can use the component tFileFetch in the talend studio.

Please follow the below article:

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

[vamsitrack]

Hello Achen,

We tried this process earlier but no use. Can we any other way?

[Covid19]

Hi @Vamsi Chimata,

I explained everything in this post.

https://community.talend.com/s/feed/0D55b00007QRgwUCAT

​Or

https://community.talend.com/s/feed/0D55b00007LRTd3CAH

Kind regards,

😷19.

[jameskenny11]

Here is how I succeeded to download and upload files from Sharepoint using Talend tHttpRequest component: Get Sharepoint access token (here is really good tutorial how to do it. After you test it in Postman go to Talend. Search for tHttpRequest component. Upload file: - Choose POST method. - URL: Download file. myccpay

[smithdirect]

To move files from SharePoint to a local system using Talend Studio, follow these steps:

Steps to Move Files:

1. Set Up Talend Studio:

   • Open Talend Studio and create a new job.

2. Use tSharepointFileList Component:

   • Add the tSharepointFileList component to your job. This component will list the files available in the specified SharePoint directory.

3. Configure tSharepointFileList:

   • Configure the tSharepointFileList component with your SharePoint site details, including the site URL, username, and password.

4. Use tFileFetch Component:

   • Add a tFileFetch component to your job. This component will be used to download the files from SharePoint to your local system.

5. Connect Components:

   • Connect the tSharepointFileList to the tFileFetch component using the "Iterate" connection.

6. Configure tFileFetch:

   • In the tFileFetch component, set the URL to the file path from SharePoint (obtained from tSharepointFileList).
   • Set the local directory where you want to save the files.

7. Run the Job:

   • Execute the job to start downloading files from SharePoint to your local system.

Connection Requirements:

1. SharePoint URL:

   • The URL of the SharePoint site where the files are stored.

2. Authentication Credentials:

   • Username and password for accessing the SharePoint site. If your SharePoint uses OAuth or another authentication method, you'll need to configure Talend to use those credentials.

3. Access Token (if applicable):

   • If your SharePoint site uses OAuth, you'll need to obtain an access token. You can use a service like Microsoft Graph to get the token.

4. Talend Components:

   • Ensure you have the tSharepointFileList and tFileFetch components available in Talend Studio.

[taddy]

Sounds like a shitty file organization plan to me. What happens next month and the month after that? The files continue to just completely change location? If the concern is moving from on prem to cloud, it would probably make more sense to have something like a DFS setup with an Azure file share for files older than a year so that the location change isn't even visible to the end user.