Talend connection to SharePoint online (o365.sharepoint.com)

[jay_t0]

I am trying to connect to SharePoint list hosted on O365/SharePoint online via tHttpRequest (http-GET) but it is failing with HTTP 403.

I can browse the list in browser - chrome, Edge, IE without any issues. Also, I can connect, link the list in MS Access, MS Excel...etc without any issues.

Is there a different method to connect to SharePoint online?

URL of List = https://DNSHOSTo365.sharepoint.com/sites/pwa/Lists/A_EMPLOYEES/AllItems.aspx

XML URL of List = https://DNSHOSTo365.sharepoint.com/sites/pwa/_vti_bin/owssvr.dll?XMLDATA=1&List={90CED3C3-7E67-4819-...

Log:

tHttpRequest_1 Request failed:403 FORBIDDEN

403 FORBIDDEN

java.lang.RuntimeException: Request failed:403 FORBIDDEN

403 FORBIDDEN

  at bi_pmo.pmoresourcelist_0_1.PMOResourceList.tHttpRequest_1Process(PMOResourceList.java:871)

  at bi_pmo.pmoresourcelist_0_1.PMOResourceList.runJobInTOS(PMOResourceList.java:7432)

  at bi_pmo.pmoresourcelist_0_1.PMOResourceList.main(PMOResourceList.java:7114)

java.version=1.8.0_65

java.vendor=Oracle Corporation

TalendStudioversion=7.2.1 TalendBigdataPlatform