Oracle Analytics Cloud - Is OAuth Access Token usage supported with SOAP API

Chandresh Patel

We use username and password parameters with logon method to get session id and then subsequently SOAP calls are made using this session id to perform necessary tasks like get catalog item info. We do have a requirement to support OAuth token (Resource Owner or JWT assertion) for this process. Is it possible to use OAuth tokens with this particular SOAP API?

Mike Durran-Oracle

I’m working on an update of the SOAP doc currently so hopefully around that timescale.

GayathriAnand-Oracle

OAuth is already supported for REST API calls in OAC. Check doc here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/authenticate.html

I don't think we have SOAP API doc for OAC but you could try to invoke the soap api via REST call and pass token?

Thanks

Gayathri

Chandresh Patel

Thanks Gayathri.

We are currently using SOAP APIs significantly, so I was hoping to continue using them while we investigate REST API details. I tried to pass Authorization header with Bearer token but that does not work with SOAP API. With SOAP API, we need to invoke logon method to get Session Id and then subsequently invoke other APIs with that Session Id, I am not able to successfully call logon method using just user and token in header, and if I try to call other API with token in header then it complains about Session Id being invalid.

On REST API front, I am able to use Token, so yes that is working. But I could not find an API to download and import a specific Item like Report or Analysis, which is supported in SOAP API.

I would appreciate if you can provide me some direction on this.

Chandresh

GayathriAnand-Oracle

I don't think oauth is supported for soap api logon method. You probably need to pass the soap api calls (like the functional ones, not the logon ones) as a payload to rest api so you can use the oauth for rest call. Sorry I don't have any specifics unless I test it out. I do see an internal post from one of our PMs on a potential blog for this, will tag here. @Adam Bloom-Oracle Appreciate your inputs on this ask.

Gianni Ceresa

@Chandresh Patel , the "old" webservices (WSDL) also support a login with a token.

It just isn't documented because the doc for the WSDL webservices is being reviewed and refreshed now for Oracle Analytics (Cloud and Server).

@Mike Durran-Oracle mentioned that in a previous post here in the forum about the WSDL webservices.

(I managed to find the question where it was said: https://community.oracle.com/products/oracleanalytics/discussion/comment/60389#Comment_60377 )

Mike, if you are around, your input is welcome :)

Chandresh Patel

@GayathriAnand-Oracle and @Gianni Ceresa I appreciate your quick responses, will wait for details on how to use token with SOAP login.

Mike Durran-Oracle

Add an authorization header of Bearer <token> to the SOAP logon service. This will return a session ID that can be used with the other SOAP services. This should be fully available in the OAC January release.

GayathriAnand-Oracle

Thanks @Mike Durran-Oracle , will SOAP API documentation be available in January 2025 update for OAC?

Chandresh Patel

Thanks @Mike Durran-Oracle, I will try it out once this is released in January.