Hello Apex Gurus,
I am trying to develop an integration of Apex and Sharepoint Online to consume Sharepoint Online data from APEX via those Sharepoint Online APIs..
After working out Bearer token and tenant of Sharepoint Online, I am able to access our SP Online APIs in Postman and from our Linux server where APEX is installed in an Oracle database.
But when I try to use APEX's APEX_WEB_SERVICE.make_rest_request package to try to GET the APIs lists, I get "ORA-29024: Certificate validation failure" message. I downloaded the certificate from xxxx.sharepoint.com/_api/web site (where xxxx is the name of our sharepoint online site), and loaded it into the Oracle PKI wallet.
I loaded a number of certificates of other cloud systems into the wallet and built a number of integrations using the same APEX approaches without any problem. Only this Sharepoint Online has the certificate validation failure issue.
I wonder whether Sharepoint Online, or even Microsoft cloud systems have something special in their HTTPS requests using certificates in Oracle APEX ?
Thanks a lot for any suggestions
Andrew Qin