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

jay_t0 — Sat, 16 Nov 2024 01:21:38 GMT

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-B38F-20C3AAD5A097}&View={A3504288-6CA3-45D5-9F56-443461723F1E}&RowLimit=0&RootFolder=%2fsites%2fpwa%2fLists%2fA%5fEMPLOYEES

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

topic Talend connection to SharePoint online (o365.sharepoint.com) in Talend Studio

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