topic Re: Upload files into sharepoint in Talend Studio

Upload files into sharepoint

ChaitraCP — Wed, 20 Jul 2022 05:49:46 GMT

Hi,

I have a requirement that I need to get a files from SFTP location and upload all the files into SharePoint Location by using talend. Could anyone please suggest few methods in detail.

Thanks & Regards,

Chaitra CP

Re: Upload files into sharepoint

ppatel — Wed, 20 Jul 2022 09:37:47 GMT

Hello,

Can you please check it out https://community.talend.com/s/question/0D53p00007vCngbCAC/how-to-upload-a-file-on-microsoft-sharepoint-online

Regards,

Pooja Patel

Re: Upload files into sharepoint

ChaitraCP — Wed, 20 Jul 2022 12:24:33 GMT

Hi Pooja,

Thank you. I have checked the link.

However in my case with ClientID, ClientSecret and TenantID details I need to upload the files into SharePoint folder.

I'm able to update the existing file in the SharePoint with the blow URI.

Full URI:

But I'm unable to upload the new file. Could anyone pls share the URI to upload the new file to SharePoint.

Thanks & Regards,

Chaitra CP

Re: Upload files into sharepoint

InfoCraft — Wed, 20 Jul 2022 16:45:57 GMT

Hi @Chaitra Prakash,

I explained everything in this post.

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

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

Kind regards,

😷19.

Re: Upload files into sharepoint

ChaitraCP — Wed, 20 Jul 2022 17:20:33 GMT

Hi @not specified not specified ,

Thanks for the details.

I have few more queries. Kindly help me on this.

1) What is the maximum size of the file we can upload to SharePoint via talend code( For example, If we have 1 GB file , do I need to add any extra parameters)

2) How to increase the upload speed for large size files.

3) How to create subfolders during execution (Like Year--> Month--> Day)

4) Kindly provide the appropriate values( To handle all the scenarios) for these parameters.

Thanks & Regards,

Chaitra CP

Re: Upload files into sharepoint

ChaitraCP — Mon, 08 Aug 2022 09:28:26 GMT

We can able to upload multiple files. Instead of hardcoding filename in the upload URL we have to use the global map variable from tfileList component.

Re: Upload files into sharepoint

ChaitraCP — Wed, 10 Aug 2022 08:32:14 GMT

Hi,

Is it possible to use tRestClient Component instead of tRest to upload files.

Thanks,

Chaitra CP

Re: Upload files into sharepoint

InfoCraft — Thu, 11 Aug 2022 20:26:15 GMT

Hi @Chaitra Prakash,

Of course you can use tRESTClient( which has more options).

Re: Upload files into sharepoint

ChaitraCP — Tue, 16 Aug 2022 07:44:12 GMT

Hi @not specified not specified ,

Kindly share the screenshot of the component and code. I'm struggling with tRestClient component.