User-Provided Bearer Token Authentication

Oracle Visual Builder Add-in for Excel supports authenticating using a bearer token you get from an authorization server.

You are responsible for getting the bearer tokens and sharing them with your business users. The add-in doesn't connect with the authorization server to acquire them. The bearer token you use must be valid and provide access to the desired operations on the target REST services. Contact your REST service administrator.

If a workbook is configured to authenticate with a token, the business user is prompted to provide one when first connecting with the REST service. This token is included in the Authorization request header of the REST service request, using the Bearer authentication scheme, like this:

Authorization: Bearer <token-value>

This token is used for all subsequent requests sent during the session. If the business user logs out, closes the workbook, or quits Excel, the token is discarded. The token is also discarded if there is an authentication failure. Following any of these events, the add-in prompts the business user for a token the next time a request is sent to the service.

To configure your workbook to use a user-provided token, select "User-Provided Bearer Token" from the Authentication list when you create a catalog or a layout. No other configuration is required. See Set an Authentication Method for a REST Service or Create Layouts in an Excel Workbook.

Note:

The token value is sent in the Authorization header as is. The add-in does not provide any validation of the token before it is sent. If the token has expired or is in any other way invalid, the service returns a 401 error. In this situation, the add-in displays an error message to the user: A valid bearer token is required to proceed. Retry the operation and provide a valid token. Contact your administrator to troubleshoot these authentication errors.