Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ChaitraCP
Contributor
Contributor

Upload files into sharepoint

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

Labels (3)
1 Solution

Accepted Solutions
Covid19
Creator
Creator

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.

View solution in original post

9 Replies
ppatel
Contributor III
Contributor III

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
Contributor
Contributor
Author

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.

0695b00000SsbMiAAJ.pngFull URI:

 

0695b00000SsbNCAAZ.png 

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

Covid19
Creator
Creator

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
Contributor
Contributor
Author

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.

 

 

0695b00000SseYmAAJ.png 

Thanks & Regards,

Chaitra CP

KimFerguson
Contributor II
Contributor II

This is sally question but anyone tell me How do I upload multiple files to SharePoint? Why can't I upload a file to SharePoint? Can I upload a folder into SharePoint? myPennMedicine.org

 

ChaitraCP
Contributor
Contributor
Author

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
Contributor
Contributor
Author

Hi,

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

 

Thanks,

Chaitra CP

Covid19
Creator
Creator

Hi @Chaitra Prakash​,

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

ChaitraCP
Contributor
Contributor
Author

Hi @not specified not specified​ ,

 

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