sharepoint integration with Talend Studio

[sushantk19]

hello friends,

How can we access sharepoint location (https path) from Talend studio to download one of the files to our local system? what talend studio components could be used?

[sushantk19]

also, i am using google chrome as my browser to access this link. does that make a difference if i pass "Mozilla/5.0" in my header??

[Anonymous]

Hello,

"User-Agent" header is OK with your use case.

Is this website available in google chrome?

Does it work well when using tHttpRequest component?

Best regards

Sabrina

[sushantk19]

yes. website is available in google chrome.

when i run this URL using thttprequest component(without checking the die on error option), it still generates a corrupted file. the log is shown below:

Sending job 'job_000_Sharepointaccess_Testing1' to server (52.58.77.6:8004)...

File transfer completed.

Deploying job 'job_000_Sharepointaccess_Testing1' on server (52.58.77.6:8003)...

Running job 'job_000_Sharepointaccess_Testing1'...

Starting job job_000_Sharepointaccess_Testing1 at 11:44 21/06/2022.

Picked up JAVA_TOOL_OPTIONS: -Dlog4j2.formatMsgNoLookups=true

[statistics] connecting to socket on port 3917

[statistics] connected

[statistics] disconnected

Job job_000_Sharepointaccess_Testing1 ended at 11:44 21/06/2022. [Exit code = 0]

[sushantk19]

i have tried using both the components thttprequest and tFetch but still unsuccessful.

[Anonymous]

Hello,

What does your downloaded file look like? We are suspecting the format could not supported by tfilefetch component.

Best regards

Sabrina

[sushantk19]

as seen from my talend component screenshot, i am trying to generate .xlsx file(please see attached). i also tried to generate .xls. it opens but without any data. isnt .xls or .xlsx supported?

[sushantk19]

@Xiaodi Shi​ : do you have any further updates on this?

[Anonymous]

Hello,

I'm discussing your issue with our team and then come back to you as soon as possible.

Best regards

Sabrina

[sushantk19]

@xdshi: do you have any update on this ?