You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Identification from Excel to Get JWT token

Received Response
edited Dec 12, 2019 10:50AM in Applications Security 9 comments



I am using custom excel spreadsheets to call REST API using basic identification with username and password included in VBA code...

I would like to remove credentials data from the code and use JWT token to first, ask user to enter his credentials and then use APIs..


Here is the code I have, it displays the Oracle identification windows, but I don't know how to retrieve token data (to be used later with Bearer identification) once credentials are entered:


Dim oBrowser As InternetExplorerMedium 'InternetExplorer
'create IE object
Set oBrowser = New InternetExplorerMedium 'InternetExplorer

'open identification windows
strUrl = "https://&quot


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!