Use Direct URLs to Open a Specific Dataset or Table - SuperWEB2

The standard way for a user to access SuperWEB2 is to start by loading the login screen, and then select the dataset or table they want to work with from the catalogue.

As an alternative, you can provide users with special URLs that take them directly to a specific dataset or table. For example, you can use this feature if you want to include direct links to specific datasets or tables on your website or intranet.

There is no specific configuration required to enable this feature. Construct the links as follows:

How Do I Find the Dataset ID or Table Name?

Type	To Find The ID/Name
Dataset	Log in to the SuperADMIN console and use the cat command.
System Defined Table (a TXD file installed on the SuperWEB2 server )	Check the TXD filename. The value you need is the same as the filename (without the .txd extension). Direct URLs to system defined tables can only be used to access TXD files that are saved in the <tomcat_home>\webapps\webapi\WEB-INF\resources\txd directory. They cannot open TXD files that have been saved to sub-directories within the txd directory. If you wish to organise your saved tables into folders, you are recommended to upload them to the user data repository in SuperADMIN , rather than saving them on disk.
User Saved Table	Check the Saved Tables tab. The value you need is the name shown in the list of tables.
Shared User Saved Table	For the table, check the Saved Tables tab. The value you need is the name shown in the list of tables. For the folder, log in to the SuperADMIN console and use the cat command.

The IDs/names are case sensitive.

Will the User Need to Log In?

See this page for more information about configuring guest access .

Using POST with Direct URLs

System direct URLs also support HTTP POST actions. You can use this feature to construct an external login form on your website that sends the user directly to a particular dataset or table after logging in.

The following example HTML code creates a login form that will direct the user straight to Retail Banking after logging in:

<form action="http://mysuperweb2.com:8080/webapi/opendatabase?id=bank" method="post">
    <label>Username</label> <input type="text" name="username" value="" />
    <label>Password</label> <input type="password" name="password" value="" />
    <input type="submit" value="Submit" />
</form>

You can copy this code onto your own HTML page. Simply change the action element on the <form> tag to the direct URL you want to use.

If you want users to be directed to the catalogue page, set the action to <server>/webapi/home. For example:

<form action="http://mysuperweb2.com:8080/webapi/home" method="post">
    <label>Username</label> <input type="text" name="username" value="" />
    <label>Password</label> <input type="password" name="password" value="" />
    <input type="submit" value="Submit" />
</form> 

Replacing the Standard Login Page with your External Login Form

You can use this feature to create a custom login form that is hosted on a different website to SuperWEB2. If you want to do this then you may also want to change SuperWEB2's logoutRedirectionURL configuration setting, which controls the location of the SuperWEB2 login page.

If you change this setting then your login page will completely replace the standard SuperWEB2 login page. Your page will be loaded:

• When a user attempts to access SuperWEB2 and is not currently logged in.
• When a user logs out of SuperWEB2.
• When a user's SuperWEB2 session times out.
• When a user attempts to access a direct URL that requires a login.

Your external login form will work even if you do not change the  logoutRedirectionURL configuration setting. However, if you do not change the setting then users will be redirected to the standard SuperWEB2 login page when they logout or their session times out.

To make this change:

1. Open <tomcat_home>\webapps\webapi\WEB-INF\web.xml in a text editor.
   
   

   Make a backup copy of this file before making any changes.

2. Locate the following section:

   XML

       <context-param>
           <description>
               The page which the user is redirected to if they do not have a valid login (timeout) or they clicked the log out button.
           </description>
           <param-name>logoutRedirectionURL</param-name>
           <param-value>login.xhtml</param-value>
       </context-param> 

   By default, the logout redirection URL is set to login.xhtml (the standard SuperWEB2 login page).

3. Change the parameter to the location of your alternative login page. For example:

   XML

        <context-param>
           <description>
               The page which the user is redirected to if they do not have a valid login (timeout) or they clicked the log out button.
           </description>
           <param-name>logoutRedirectionURL</param-name>
           <param-value>http://myserver/superweb2.html</param-value>
       </context-param> 

   

   If the URL contains non ASCII characters, then you must URL encode those characters.

   For example, to use the URL http://ru.wikipedia.org/wiki/Юникод you would need to encode this as http://ru.wikipedia.org/wiki/%D0%AE%D0%BD%D0%B8%D0%BA%D0%BE%D0%B4

   In most modern web browsers, including Chrome and Firefox, if you copy the full URL from the browser address bar, it will automatically copy the encoded form of the URL to the clipboard.

4. Save your changes to the file and restart Tomcat or the SuperWEB2 service.

Note for Deployments with Non-ASCII Characters in IDs

SuperWEB2 supports the full Unicode character set. This means your table IDs are allowed to contain non ASCII characters (characters that are not part of the English alphabet).

If your deployment includes tables with IDs that have non ASCII characters in them (or it is likely that your users might create tables containing non ASCII characters in the table name), then you will need to make a change to the Tomcat server configuration to ensure that direct URLs continue to work: Tomcat must be configured to use UTF-8 encoding for URIs.

If you do not configure Tomcat correctly then system direct URLs containing non ASCII characters will not work.

This setting is not enabled by default. To make the change:

1. Open <tomcat_home>\conf\server.xml in a text editor.

2. Locate the following section:

   XML

   <Connector port="8080" protocol="HTTP/1.1"
              connectionTimeout="20000"
              redirectPort="8443" />

3. Add URIEncoding="UTF-8" to the Connector:

   XML

   <Connector port="8080" protocol="HTTP/1.1"
              connectionTimeout="20000"
              redirectPort="8443" 
              URIEncoding="UTF-8" />

4. Save your changes and restart the Tomcat service.

Some versions of Internet Explorer (including IE10 and IE11) do not fully support non ASCII characters in URL query parameters. If you are using the system direct URLs feature and your deployment has tables with non ASCII characters, then you are recommended to use an alternative browser where possible.