Oracle Communities

Oracle Analytics and AI

Child Item

How to get the direct URL to pass parameter value directly in OAC DV

Hi, I am trying to get the URL for below scenario.

I have one prompt called "Email" and value is satish.reddy@oracle.com in one of the workbook so I need to pass this value in direct link without going to workbook. if you have idea then please share the link ?

ex: https://your-oac-host/ui/dv?workbookId=F12345ABCDE&pageId=1&parameters=%7B%22region%22%3A%22West%22%7D

I want link for below values

Workbook Name = New Workbook123456

Parameter Name = Email

Email address = satish.reddy@oracle.com

Thanks,

Satish

Find more posts tagged with

Accepted answers

Brendan T

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.

All comments

Brendan T

Direct URL Construction

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.

Steve F-2

Hi @User_IPFAK

Welcome to the Oracle Analytics Community and Thanks for your question.

A few housekeeping updates for you
1. As an Oracle Employee, you are required to identify yourself as such in your Display Name, please update it.

2. Since this is a public forum exposed on the internet, you may want to use obfuscated values in regards to your email address. I will leave that to you.

To add to the information that Brendan supplied, here is a tutorial that is embedded the documentation. If you want to test with a curated example.

Pass Parameter Values in an Oracle Analytics URL

User_IPFAK

Thank you for providing the link

Thanks,

Satish