Methodology to Download a file from Sharepoint (residing in a private network)

Six Stars

Methodology to Download a file from Sharepoint (residing in a private network)

Hello all,
I need your help.

I need to create a Job that allows me to download an excel file from Sharepoint. The sharepoint "folder" that I need to access is inside a company private network.
When I access the folder via web link I need to authenticate with my credential and then add a random key generated by the application PingID. Once that my credentials are verified I can access the sharepoint page.

Is there a specific way to accomplish the download via talend? Do I need to have a keystore to allow my user to connect?

Thank you in advance for your help!

Community Manager

Re: Methodology to Download a file from Sharepoint (residing in a private network)

You will need to use a tFileFetch and follow this specification. I've not done this, but I would suggest using the tFileFetch's Header options to supply your credentials.

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest

Highlighted
Six Stars

Re: Methodology to Download a file from Sharepoint (residing in a private network)

@rhall_2_0
thank you for your advice. Could you tell me how to use the tFileFetch's Header options to supply my credentials? I have checked online, but I don't get how this component works.

Thank you.

Community Manager

Re: Methodology to Download a file from Sharepoint (residing in a private network)

You should set your tFileFetch URL to http://site url/_api/web/GetFolderByServerRelativeUrl('/Folder Name')/Files('file name')/$value

 

I'm not sure what $value should be. I can't try it out I'm afraid. The API is not very clear here.

 

When it comes to the headers, you will need to create a header called "Authorization" and in its value add .....

"Bearer "+context.AccessToken

You will have to use the API to get your AccessToken first.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download