Web Functions

You can use web functions in custom tables and fields. See Adding a Custom Table and Editing Field Formulas for further details. Below are explanations of available web functions.

Note:

In all circumstances, the URL must include ‘http://’. For example, if the URL is www.sisense.com, the syntax should be GetFile (‘http:// www.sisense.com’)

DomainIs: true/false DomainIs (URL,compared domain)

Get whether the given urls domain matches the given domain. For example ‘http://www.wikipedia.org’ matches org, wikipedia, www.wikipedia.org.

GetFile: string GetFile (url)

Extract the filename portion of the path in the given url and returns it.

The filename is everything after the last slash in the path.

GetHost: string GetHost (url)

Extract host from the given url, for example ‘www.wikipedia.org’ in’http://www.wikipedia.org’

GetPassword: string GetPassword (url)

Extract password from the given url.

Specified in the url following the user name, with leading colon (‘:’) and trailing at sign (@), as in ‘http://user:password@host/.’

GetPath: string GetPath (url)

Extract path from the given url.

Path is the url portion following the host name, for example ‘/wiki/Business_intelligence’ in
‘http://www.wikipedia.org/wiki/Business_Intelligence’

GetPort: string GetPort (url)

Extract port from the given url, parsed as integret, for example 123 in ‘http://www.wikipedia.org:123/’

GetQuery: string GetQuery(url)

Extract the query from the given url.
Specified in the url after the ‘?’ and before (optional) the ‘#’ sign, for example ‘par=val’ in ‘http://www.wikipedia.org/?par=val#ref’.

GetQueryParamValue (url,param name): string GetQueryParamValue (url,param name)

Extract param value from the given url’s query, by the given param name.

Param/Value pairs when supplied, are delimited by an ampersand or a semicolon.

GetRef: string GetRef (url)

Extract ref from given url.

Specified in the url starting after last appearance of the ‘#’ sign, for example ‘ref’ in ‘http://www.wikipedia.org/?par=val#ref’

GetScheme: string GetScheme (url)

Extract scheme from given url.

Skips leading spaces and followed colon (‘:’) sign, for example ‘http://www.wikipedia.org/’

GetUserName: string GetUserName (url)

Extract user name from given url.

Specified in the url before the host name and delimited by an ‘@’ as in ‘http://user@host/.’

HasHost: true\false HasHost (url)

Get whether the given url specifies a host.

HasPassword: true\false HasPassword (url)

Get whether the given url specifies a password.

HasPath: true\false HasPath (url)

Get whether the given url specifies a path.

HasPort: true\falseHasPort (url)

Get whether the given url specifies a port.

HasQuery: true\false HasQuery (url)

Get whether the given url specifies a query.

HasRef: true\false HasRef (url)

Get whether the given url specifies a ref.

HasScheme: true\false HasScheme (url)

Get whether the given url specifies a scheme.

HasUsername: true\false HasUsername (url)

Get whether the given url specifies a user name.

HostIsIpAddress: true\false HostIsIpAddress (url)

Get whether the given url host name is an ip address.

IsEmptyUrl: true\false IsEmptyUrl (url)

Get whether the given url is empty.

IsFileUrl: true\false IsFileUrl (url)

Get whether the given url is a file url.

IsSecuredUrl: true\false IsSecuredUrl (url)

Get whether the given url scheme indicates a secured connection(https).

IsStandardScheme: true\false IsStandardScheme (url)

Returns true if the scheme for the current urk is a known ‘standard’ scheme.

Standard schemes have an authority and a path section (including file:).

IsValidUrl: true\false IsValidUrl (url)

Get whether the given url has a valid form.

PathForRequest: true\false PathForRequest (url)

Returns the path that should be sent to the server.

This is the path, parameter, and query portions of the url.

SchemeIs: true\false SchemeIs (url)

Get whether the given url scheme portion matches the given scheme.

.r.