Upload files into sharepoint

[ChaitraCP]

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

[ppatel]

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

[ChaitraCP]

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

[InfoCraft · Accepted solution]

Hi @Chaitra Prakash,

I explained everything in this post.

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

​Or

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

Kind regards,

😷19.

[ChaitraCP]

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

[ChaitraCP]

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.

[ChaitraCP]

Hi,

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

Thanks,

Chaitra CP

[InfoCraft]

Hi @Chaitra Prakash​,

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

[ChaitraCP]

Hi @not specified not specified​ ,

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