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
