To generate a direct link to your Oracle Analytics Cloud (OAC) workbook that passes a specific parameter value, you can use the syntax demonstrated in your example or the positional parameter syntax described in the sources.

Direct URL Construction

Based on the values provided, you have two primary methods to construct the link. Please note that all special characters (like the "@ in the email or spaces in the workbook name ) must be URL-encoded.

Method 1: JSON Parameter Syntax (Recommended)

This method follows the structure of your provided example, where parameters are passed as a JSON object within the URL.

• Workbook Path: Assuming the workbook is in Shared Folders, the path is /shared/New Workbook123456. Encoded, this is %2Fshared%2FNew%20Workbook123456.
• JSON Object: {"Email":"satish.reddy@oracle .com"}
• Encoded Parameters: %7B%22Email%22%3A%22satish.reddy%40oracle.com%22%7D.

Constructed URL: https://your-oac-host/ui/dv?reportpath=%2Fshared%2FNew%20Workbook123456&pageId=1&parameters=%7B%22Email%22%3A%22satish.reddy%40oracle.com%22%7D

Method 2: Positional Parameter Syntax

The sources also specify a syntax using p1n (parameter name) and p1v (parameter value). This is often used for embedding or simpler direct links.

• p1n: Email
• p1v: satish.reddy%40oracle.com

Constructed URL: https://your-oac-host/ui/dv/ui/project.jsp?pageid=visualAnalyzer&reportmode=full&reportpath=%2Fshared%2FNew%20Workbook123456&p1n=Email&p1v=satish.reddy%40oracle.com

Key Requirements for the Link to Work

• Safe Domains: If you are using this link within an iFrame or an external portal, your OAC administrator must first register the host domain as a Safe Domain in the OAC Console and select the "Embedding" and "Allow Frames" options.
• Workbook ID vs. Path: While your example used a workbookId (a unique alphanumeric string), the examples in the sources typically use reportpath for manually built URLs. To find the exact reportpath, you can open the workbook, go to the Menu, select Developer, and click the Embed tab to see the generated path for that specific item.
• Authentication: When the user clicks this link, they will be prompted to log in unless you have configured Single Sign-On (SSO) or user federation between your application and OAC.
• Encoding: Ensure that the email address uses %40 instead of @ and any spaces in your workbook name are replaced with %20 to prevent the browser from breaking the link.