Skip to main content
Solved

How to combine token generation to use in post outbound request?

  • October 27, 2023
  • 1 reply
  • 171 views

Forum|alt.badge.img+5

Hi,

I have implemented a outbound (POST) request to 3rd party to transfer some information from IFS to their system, but to access their system I need to generate a token and then need to send the outbound request authorization as Bearer using that generated token.

Can I fulfil this requirement only using Routing Rules and Addresses?

Token Generation 

I’m getting a token as a result of above.

 

Outbound Request

I should be able to use the generated token here to send the data.

Please share if you have any sample setup for this..

Best answer by Asanka Dissanayake

To achieve this I have to create two routing addresses, one is to generate token and other one is to send outbound request using generated token.

Somehow for this required some code changes in PLSQL side for the outbound request.

Wrote a new method to get the generated token.

 

Method:

FUNCTION Get_Access_Token RETURN VARCHAR2
IS
   json_clob_    CLOB;
   token_        VARCHAR2(32000);
BEGIN
   Plsql_Rest_Sender_API.Call_Rest_EndPoint3(rest_service_ => 'CLIENT_TOKEN',
                                             xml_ => json_clob_,
                                             http_method_ => 'GET');


   token_ := Plsql_Rest_Sender_API.Get_Value__(json_clob_, '<token>');
   RETURN token_;
END Get_Access_Token;

 

Routing Address for Token Generation:
 

 

Outbound Request:
 

 

Routing Address for the Outbound Request, remember to set Authorization Method as ‘None’. It will handle as ‘Bearer’ in the code (screen shot above)

 

 

 

View original

Forum|alt.badge.img+5

To achieve this I have to create two routing addresses, one is to generate token and other one is to send outbound request using generated token.

Somehow for this required some code changes in PLSQL side for the outbound request.

Wrote a new method to get the generated token.

 

Method:

FUNCTION Get_Access_Token RETURN VARCHAR2
IS
   json_clob_    CLOB;
   token_        VARCHAR2(32000);
BEGIN
   Plsql_Rest_Sender_API.Call_Rest_EndPoint3(rest_service_ => 'CLIENT_TOKEN',
                                             xml_ => json_clob_,
                                             http_method_ => 'GET');


   token_ := Plsql_Rest_Sender_API.Get_Value__(json_clob_, '<token>');
   RETURN token_;
END Get_Access_Token;

 

Routing Address for Token Generation:
 

 

Outbound Request:
 

 

Routing Address for the Outbound Request, remember to set Authorization Method as ‘None’. It will handle as ‘Bearer’ in the code (screen shot above)

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings