Getting error while connecting sharepoint online source

Four Stars

Getting error while connecting sharepoint online source

Hi,

 

I am using Talend open studio-Big data(6.5) ,Getting error while connecting sharepoint online source by using tHttpRequest component to extract the source.

Error message :  401 unauthorized.

 

I have entered all the credentials and URL.

please provide the solution..

 

Thanks in advance..

Eight Stars

Re: Getting error while connecting sharepoint online source

me too getting.

Moderator

Re: Getting error while connecting sharepoint online source

Hello,

Do you need proxy to access internet from your machine? Are you able to access the URL in browser?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Getting error while connecting sharepoint online source

Hi,

 

I don't need proxy to access SharePoint , i am able to access from webbrowser.

 

 

Regards,

Mahesh

Moderator

Re: Getting error while connecting sharepoint online source

Hello,

Here is an article about:https://www.datalytyx.com/how-to-extract-list-items-from-sharepoint-on-premise-into-talend-gated/.

Let us know if it helps.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Eight Stars

Re: Getting error while connecting sharepoint online source

Hi @xdshi,

any article for Uploading a text File to SharePoint?I want to upload.

Six Stars

Re: Getting error while connecting sharepoint online source

The article you are referencing is for integrating on-premise Sharepoint lists. Have you any idea about hoy to integrate sharepoint online lists in Talend ?
Moderator

Re: Getting error while connecting sharepoint online source

Hello,

I haven't tried to integrate sharepoint online lists in Talend. We will make an investigation on it and then come back to you.

Thnaks for your time.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Getting error while connecting sharepoint online source

Can you provide any article or example to extract the Sharepoint lists based on the URL. I was used thttprequest,trestclient,tsoap,trest components.., in every case i am getting 401 Unauthorized error.Actually i am calling server url and passing the username and password here using GET method.

 

actually i have url of the server Sharepoint list and i have access through username and password.

I am unable to access that list getting 401 unauthorized. 

 

please provide the solution quickly.(It will more helpful to me).

 

 

Regards,

Mahesh

 

Thanks in advance....

Six Stars

Re: Getting error while connecting sharepoint online source

Hello @mahesh,

 

Actually I'm using TRestClient to get data from Online Sharepoint Lists :

tRestClient>tExtractXMLField 

community.png

 

Do you have access to your URL with a web browser? If you can read your data with a browser you shouldn't have a problem getting it with Talend.

 

Cheers 

Four Stars

Re: Getting error while connecting sharepoint online source

Hi All,

 

I am able to accessing the sharepoint server url with username and password through web browser, it is opens the Sharepoint lists.

but i am not achieving this with the talend open studio for big data(6.5.1 version).

I am doing all possibilities and used components like tfilefetch,thttprequest,trest,trestclient,tsoap..

please provide the solution(Quickly it will more useful to me).

 

Regards,

Mahesh

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download