Getting error while connecting Sharepoint online source

Seven Stars

Getting error while connecting Sharepoint online source

I am trying to connect Talend with Online sharepoint.I have tried according to this url "https://www.datalytyx.com/how-to-extract-list-items-from-sharepoint-on-premise-into-talend-gated/"

1.I am using tsoap component however getting a long error message:

 

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The method invokeSOAP(String, String, String, String) in the type SOAPUtil is not applicable for the arguments (String, String, test.row1Struct)
Syntax error on tokens, delete these tokens
Syntax error, insert ")" to complete Expression
at local_project.test_0_1.test.tSOAP_1Process(test.java:540)
at local_project.test_0_1.test.runJobInTOS(test.java:1003)
at local_project.test_0_1.test.main(test.java:860)
Job test ended at 16:13 22/08/2016. [exit code=0]

The soap message contains this :


"<soapenv:Envelope xmlns:soapenv=’’><soapenv:Body><GetListItems xmlns=’’>
<listName>test-list</listName>
<query><Query></Query></query>
<viewFields>
<ViewFields>
<FieldRef Name=’id’ />
<FieldRef Name=’name’ />
</ViewFields>
</viewFields>
</GetListItems>
</soapenv:Body>"
</soapenv:Envelope>"

 

Thanks & Regards
A Ravi Kumar
Mobile Number : +91 852-762-1083
Email-id : a.ravikumar104@gmail.com
Skype Id : ammanannaravikumar
Moderator

Re: Getting error while connecting Sharepoint online source

Hello,

Here is a related resolved topic:https://community.talend.com/t5/Design-and-Development/How-to-update-REST-API-sharepoint-list-items/...

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

Re: Getting error while connecting Sharepoint online source

Hi All,

 

We are trying to use tHttp talend component to download the file from sharepoint but getting the below error:

 

sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[ERROR]: mywork.sharepoint_3_0_1.sharepoint_3 - tHttpRequest_1 - sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

 

I am using the belew URI  in the compoent:

 

https://<Domiain_Name>/global/enterprise/Shared%20Documents/Framework%20IDs.xlsx

 

Did anyone able to successfully iterate and download the excel files from sharepoint on premise? Please provide suggestions

Moderator

Re: Getting error while connecting Sharepoint online source

Hello,
Please see a related article http://stackoverflow.com/questions/6908948/java-sun-security-provider-certpath-suncertpathbuilderexc....
Are you able to successfully import the certification? By tSetKeystore component?

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,

Thanks for responding.

I have gone through that blog but i am not sure ,how to get the key store and password for the sharepoint.

From where this certificate can be generated?