topic Re: Files need to move from SharePoint in Talend Studio

Files need to move from SharePoint

vamsitrack — Fri, 15 Nov 2024 22:24:13 GMT

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

what do we need for connection?

Re: Files need to move from SharePoint

Anonymous — Wed, 02 Nov 2022 08:54:21 GMT

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

Re: Files need to move from SharePoint

vamsitrack — Wed, 02 Nov 2022 11:53:16 GMT

Hello Achen,

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

Re: Files need to move from SharePoint

InfoCraft — Wed, 02 Nov 2022 13:03:00 GMT

Hi @Vamsi Chimata,

I explained everything in this post.

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

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

Kind regards,

😷19.

Re: Files need to move from SharePoint

jameskenny11 — Tue, 08 Nov 2022 05:42:02 GMT

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

Re: Files need to move from SharePoint

smithdirect — Wed, 26 Jun 2024 13:34:34 GMT

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

Steps to Move Files:

Set Up Talend Studio:
- Open Talend Studio and create a new job.
Use tSharepointFileList Component:
- Add the tSharepointFileList component to your job. This component will list the files available in the specified SharePoint directory.
Configure tSharepointFileList:
- Configure the tSharepointFileList component with your SharePoint site details, including the site URL, username, and password.
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.
Connect Components:
- Connect the tSharepointFileList to the tFileFetch component using the "Iterate" connection.
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.
Run the Job:
- Execute the job to start downloading files from SharePoint to your local system.

Connection Requirements:

SharePoint URL:
- The URL of the SharePoint site where the files are stored.
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.
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.
Talend Components:
- Ensure you have the tSharepointFileList and tFileFetch components available in Talend Studio.

Re: Files need to move from SharePoint

taddy — Fri, 12 Jul 2024 08:25:32 GMT

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.