Web Functions

You can use mathematical functions in custom tables and fields. See Adding a New Custom Table and Defining and Editing Field Formula 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:[email protected]/.’

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://[email protected]/.’

HasHost: true\fast HasHost (url)

Get whether the given url specifies a host.

HasPassword: true\fast HasPassword (url)

Get whether the given url specifies a password.

HasPath: true\fast HasPath (url)

Get whether the given url specifies a path.

HasPort: true\fast HasPort (url)

Get whether the given url specifies a port.

HasQuery: true\fast HasQuery (url)

Get whether the given url specifies a query.

HasRef: true\fast HasRef (url)

Get whether the given url specifies a ref.

HasScheme: true\fast HasScheme (url)

Get whether the given url specifies a scheme.

HasUsername: true\fast HasUsername (url)

Get whether the given url specifies a user name.

HostIsIpAddress: true\fast HostIsIpAddress (url)

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

IsEmptyUrl: true\fast IsEmptyUrl (url)

Get whether the given url is empty.

IsFileUrl: true\fast IsFileUrl (url)

Get whether the given url is a file url.

IsSecuredUrl: true\fast IsSecuredUrl (url)

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

IsStandardScheme: true\fast 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\fast IsValidUrl (url)

Get whether the given url has a valid form.

PathForRequest: true\fast 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\fast SchemeIs (url)

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