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!
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.
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.
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 .....
You will have to use the API to get your AccessToken first.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.