Data Hub Mapping Functions

The mapping functions available in Data Hub.

Mapping Functions

In addition to Template and Data Transformation Functions, the following mapping functions are included in Data Hub.

parseDate

Converts the specified date string, parsed according to the specified pattern, to the ISO 8601 format.

parseDate( value, pattern )
value
String containing the date in the specified pattern.
pattern
Format of the specified value. Valid formats are: "MM/dd/yyyy", "dd/MM/yyyy", "MM-dd-yyyy", "MM.dd.yyyy", "dd.MM.yyyy", "yyyyMMdd", "yyyy/MM/dd", "Mon dd, yyyy", "dd Mon yyyy", and "dd-Mon-yyyy".
parseDateTime

Converts the specified date-and-time string, parsed according to the specified pattern, to the ISO 8601 format.

parseDateTime( value, pattern )
value
String containing the date and time in the specified pattern.
pattern
Format of the specified value. Valid formats are: "yyyyMMddThhmmss", "dd/MM/yyyy-hh:mm:ss", "dd/MM/yyyy hh:mm:ss", "yyyy/MM/dd-hh:mm:ss" , "yyyy/MM/dd hh:mm:ss".
memoryLookup

Retrieves the value of the specified key in the dictionarystring.

memoryLookup( key, dictionarystring )
key
Word or phrase to look up in the dictionary.
dictionarystring
String representing a JSON object that defines an array of key-value pairs.

Example: memoryLookup( "en", '{"en": "English", "fr": "French", "sp": "Spanish"}' ) would return English.

documentLookup

Retrieves the value of the specified key in the dictionary located at the specified dictionaryURI.

documentLookup( key, dictionaryURI )
key
Word or phrase to look up in the dictionary.
dictionaryURI
URI to a document containing a JSON object that defines an array of key-value pairs.