nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Does SOAP Api Supports JWT for getting BIP Reports O/P - xmlpserver/services/v2/ScheduleService?wsdl

Prithvi_Raj

Hello Everyone,

I was able to use the SOAP WSDL — "xmlpserver/services/v2/ScheduleService?wsdl" to get the BIP Output of a seeded ESS job, but this requires a Username and password to be sent in the body of the payload. Could anyone guide me if there is a way to use JWT token to run this payload?

WSDL Services Testing -

I tried to update the Header, with authentication with JWT but that didn't work.

I also was able to find a oracle doc which says JWT is not possible on BIP WSDL - https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=22308296016800&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2954741.1&_afrWindowMode=0&_adf.ctrl-state=5qfpfhb0j_4

I would appreciate it if someone can guide me how to execute this without username and password if possible, as in our Prod environment we have only token based authentication.

Thanks,
Prithvi

Find more posts tagged with

soap

Scheduler

BIP Reports

Accepted answers

Kevin M-Oracle

See: Using JWT token authentification with BIP web services (Doc ID 2954741.1).

That is not an option at this time.

Kevin

MandeepGupta

Hi Prithvi,

As confirmed by Kevin, JWT token authentication is not yet support:

JWT Token Support for Fusion Applications BIP Webservice (Doc ID 2772939.1)

I have submitted an idea for same. Please upvote if you think it will be helpful:

Enable JWT token-based authentication for BIP web service calls — Oracle

Thanks,

Mandeep.

All comments

Mallikarjuna Kuppauru-Oracle

Hi @ Prithvi_Raj

Welcome to Analytics & AI community.

Can you refer below -

Configure JWT

Invoking SOAP BIP service with OAuth — Cloud Customer Connect

Regards,

Arjun

Prithvi_Raj

https://community.oracle.com/products/oracleanalytics/discussion/comment/71926#Comment_71926

Hi @Mallikarjuna Kuppauru-Oracle,

I tried to pass the JWT token generated by Token relay option for the Scheduled services WSDL, but I am getting this error after I have removed the password from the payload of the WSDL body.

Body with No pass -

But If I add the password on the body, it is working. I have checked the documentation for the In-session token generation method, but it seems to generate the session token I would still need username and password. Is there any way I can use the self generated bearer token to authenticate the SOAP payload, I am trying not to run a report but get the output of a previously run Seeded BIP Report output.

Thanks,
Prithvi

Kevin M-Oracle

There are BIP wsdls built for FA SaaS.

See: Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications(Doc ID 2086077.1).

Rgds,

Kevin

Prithvi_Raj

https://community.oracle.com/products/oracleanalytics/discussion/comment/71957#Comment_71957

Hi @Kevin M-Oracle, Could you please help me with a sample payload, I am trying to follow the Process for this Support Doc - https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=124132212907450&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2354979.1&_afrWindowMode=0&_adf.ctrl-state=uk2p5lrdv_4

As in the shared document, I am having difficulty understanding how the JWT is passed or which payload will help in completing the above process. Apologies, as this is my first time working with SOAP payloads. I would really appreciate your guidance on this.

Thanks,
Prithvi

Kevin M-Oracle

Try one of these two:

ScheduleReportWSSService

ExternalReportWSSService

Then set basic authentication in SoapUI.

Kevin

Prithvi_Raj

https://community.oracle.com/products/oracleanalytics/discussion/comment/72044#Comment_72044

Hi @Kevin M-Oracle, I am looking for option to use JWT bearer token. I am able to use basic auth for getting the report output, but in prod we have only jwt token based access. Could you please guide if this will support JWT Bearer tokens.

Kevin M-Oracle

See: Using JWT token authentification with BIP web services (Doc ID 2954741.1).

That is not an option at this time.

Kevin

MandeepGupta

Hi Prithvi,

As confirmed by Kevin, JWT token authentication is not yet support:

JWT Token Support for Fusion Applications BIP Webservice (Doc ID 2772939.1)

I have submitted an idea for same. Please upvote if you think it will be helpful:

Enable JWT token-based authentication for BIP web service calls — Oracle

Thanks,

Mandeep.

Prithvi_Raj

Hi @MandeepGupta & @Kevin M-Oracle,

Thanks for confirming this, I had checked this doc reference in the post and just wanted to double-check with everyone in case there have been any recent updates.

Thanks for Creating the Idea, I will upvote it @MandeepGupta