topic Re: SharePoint Online Excel file Download using Talend in Talend Studio

SharePoint Online Excel file Download using Talend

User5855061838151518 — Sat, 16 Nov 2024 01:03:50 GMT

Hello

Problem Statement : Download excel from SharePoint online where multiple excel files can be present. Identify latest file and download it in destination folder

We are open to use any component to achieve this like trest, tHttpsRequest, tfileFetch provided it works and we are using below URL from SharePoint copy link option not what other component configuration I need to change in tHttpsRequest or tFileFetch component

SharePoint URL used: https://mycompany.sharepoint.com/:x:/r/sites/BI/Shared%20Documents/BIChanges/Open%20Red%20RMA%20Reporting/Carrier%20Status/CarrierStatus.xlsx?d=wd4f501a0828642419ad6f5e2403b31f2&csf=1&web=1&e=erNSyu

We have multiple file in SharePoint folder as below and we need to use latest carrier status file

In HttpRequets component getting 403 FORBIDDEN error
In TFileFetch getting java.lang.Exception: Method failed: HTTP/1.1 301 Moved Permanently error

Exception in component tFileFetch_1 (SHarePointTest)

java.lang.Exception: Method failed: HTTP/1.1 301 Moved Permanently

We need urgent help in this which URL to use. I have followed correct copy link from SharePoint and other component settings

Thanks

Smita

Re: SharePoint Online Excel file Download using Talend

Aadhi — Tue, 24 Nov 2020 17:43:55 GMT

You can use Soap call (tSoap) to download the file from sharepoint.

Re: SharePoint Online Excel file Download using Talend

User5855061838151518 — Tue, 24 Nov 2020 22:09:39 GMT

Will you give more details about like sample component configuration. I have already tried tHTTPRequest and tFileFetch but no luck

Re: SharePoint Online Excel file Download using Talend

Aadhi — Wed, 25 Nov 2020 09:21:35 GMT

Hi,

I have attached screenshot with configuration details which you need to provide in tsoap component.

You can get the soap request template from the sharepoint URL.

In your case, https://mycompany.sharepoint.com/:x:/r/sites/BI/_vti_bin/copy.asmx

GetItem action will give the file content in base64 encoded version. You can use a simple java code to convert it to a excel file.

I have attached the sample job flow for your reference.

Re: SharePoint Online Excel file Download using Talend

Aadhi — Wed, 25 Nov 2020 09:22:57 GMT

see screenshot.

Re: SharePoint Online Excel file Download using Talend

LO1 — Thu, 13 Oct 2022 17:49:43 GMT

Could you give me more details on how to use the tSoap component?