topic Re: Connect to Sharepoint using tRestClient in Talend Studio

Connect to Sharepoint using tRestClient

Knowme — Thu, 05 Nov 2020 17:29:54 GMT

Hi All,

I need to get Sharepoint list data from Talend and trying to Connect to Sharepoint using tRestClient. But I keep getting the 403 Forbidden access error. Any idea how to get it done and flow of the mapping.

Appreciate your help

Re: Connect to Sharepoint using tRestClient

vikramk — Fri, 06 Nov 2020 06:54:29 GMT

Hi @Roopa K. Veturi ,

Would mind going through below url, still if the issue persist please post the ss of your job design.

https://www.cdata.com/kb/tech/sharepoint-jdbc-talend.rst

Please let me know if helps.

Re: Connect to Sharepoint using tRestClient

Knowme — Fri, 06 Nov 2020 21:29:03 GMT

Hi Vikram,

Thank you for the link. I did try the post and installed Cdata jars was able to connect but I am not able to see any table schemas in the connection. Not sure where I am doing wrong. Maybe the link? . The connection says successful though.

Attaching the URl. I need to get data from the lists in sharepoint.Attaching URL

Re: Connect to Sharepoint using tRestClient

manodwhb — Sun, 08 Nov 2020 02:29:49 GMT

@Roopa K. Veturi , are you able to access that api from postman? from same system and within network?

Thanks,

Manohar

Re: Connect to Sharepoint using tRestClient

Knowme — Mon, 09 Nov 2020 15:06:51 GMT

Hi @Manohar B ,

Yes i am able to access from postman. But since the token expires i was looking for another process.