Using JavaScript in the database FETCH data from REST API and call that from SQL is easy.
Here my REST API is from my Autonomous Oracle Database 19c, and my local 23c DB is acquiring data from that resource.
And in 23c the db can use local OS Cert for https!