Modifying Email Report URLs

[intapiuser]

Introduction

When embedding Sisense in a parent application, there will be a need to route email reports to your parent application dashboard URL.

For example, when a customer will load a dashboard in the embedded application, the dashboard URL might look something like this

https://endcustomer.appowner.com/division/analytics?sisense_url=%2Fdashboards%2F{dashboard_oid}

While the original Sisense dashboard URL might looks something like this:

http://endcustomer-bi.appowner.com/app/main%23/dashboards/{dashboard_oid}

In this case, when a customer receives an email report from the application, for instance to view a dashboard that was shared with them, they will be routed to the original Sisense dashboard URL and not the parent application URL. 

Solutions

This article proposes two solutions to this:

1) Change the Alias field in the Admin/Settings of Sisense to the parent application URL. If the parent application dashboard URLs match this pattern:

http://subdomain.domain.com/app/main%23/dashboards/{dashboard_oid}

Then this solution will work. But, in case the parent application dashboard URL must be manipulated, you will need to apply the second solution.

2) Manipulate the embedded url token in Sisense templates.

Let's use the dashboard share report as an example. If we open:

path/to/email/templates/dashboard_report/html.ejs

We will the see following:

...
<td align="left" bgcolor="#ffffff">
     <a name='dashboard' href='<%= url %>' target='_blank'> <img src='cid:<%= images[i] %>' id="<%= images[i] %>" name="<%= images[i] %>" /> </a>
</td>

We notice that the anchor tag has an EJS expression as the reference for the hyperlink:

href='<%= url %>'

The url token in this case evaluates to the original Sisense dashboard URL:

url = http://endcustomer-bi.appowner.com/app/main%23/dashboards/{dashboard_oid}

We can use JavaScript replace method to manipulate this token to match the parent application dashboard URL as so:

<a name='dashboard' href='<%= url.replace('http://endcustomer-bi.appowner.com/app/main%23/dashboards/', 'https://endcustomer.appowner.com/division/analytics?sisense_url=%2Fdashboards%2F') %>' ... </a>

When the email will be generated, the URL will resolve to the expected endpoint:

https://endcustomer.appowner.com/division/analytics?sisense_url=%2Fdashboards%2F{dashboard_oid}

and direct the customer to the dashboard in the parent application.

* This solution was tested on Linux LA version 7.4.1.571 and Windows version 7.4.