Resume R&D on connecting Pentaho 9 to Magento endpoint. Found that the REST API object in Pentaho only supports HTTP connection with a username and password. Connections using more complicated authentications aren't supported yet.