topic Re: Getting error while connecting sharepoint online source in Talend Studio

Getting error while connecting sharepoint online source

Anonymous — Sat, 16 Nov 2024 08:33:21 GMT

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..

Re: Getting error while connecting sharepoint online source

abhi90 — Thu, 15 Mar 2018 10:38:14 GMT

me too getting.

Re: Getting error while connecting sharepoint online source

Anonymous — Fri, 16 Mar 2018 06:55:31 GMT

Hello,

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

Best regards

Sabrina

Re: Getting error while connecting sharepoint online source

Anonymous — Fri, 16 Mar 2018 07:35:09 GMT

Hi,

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

Regards,

Mahesh

Re: Getting error while connecting sharepoint online source

Anonymous — Mon, 26 Mar 2018 11:26:22 GMT

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

Re: Getting error while connecting sharepoint online source

abhi90 — Mon, 26 Mar 2018 15:33:20 GMT

Hi @xdshi,

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

Re: Getting error while connecting sharepoint online source

Anonymous — Sun, 15 Apr 2018 09:31:37 GMT

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 ?

Re: Getting error while connecting sharepoint online source

Anonymous — Thu, 19 Apr 2018 08:05:49 GMT

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

Re: Getting error while connecting sharepoint online source

Anonymous — Sat, 28 Apr 2018 19:49:55 GMT

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....

Re: Getting error while connecting sharepoint online source

Anonymous — Sun, 29 Apr 2018 10:48:22 GMT

Hello @mahesh,

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

tRestClient>tExtractXMLField

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

Re: Getting error while connecting sharepoint online source

Anonymous — Mon, 30 Apr 2018 12:25:14 GMT

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