# getMapProperty

Returns the value of an execution property.

This function is only available in DSQL maps.

## Description

The getMapProperty function returns the value of an execution property. Execution properties are named values that can be passed to a DSQL script or map at runtime.

Common use cases include:

* Accessing context variables from Talend Studio Jobs when using the tHMap component (context variables are automatically set as execution properties)
* Accessing message headers in ESB/Camel Routes when using the cMap component (inbound exchange headers are automatically set as execution properties)
* Accessing custom properties passed to the tDSQL4JSON component
* Reading predefined system properties such as oaklandsw.source.url or oaklandsw.result.url

## Arguments

Name of the execution property as a string literal.

## Return value

The value of the specified execution property. The return type depends on the property value type. Returns null if the property does not exist.

## Examples

| Expression | Description |
| --- | --- |
| getMapProperty('userName') | Returns the value of the userName execution property |
| getMapProperty('Account\_Website') | In an ESB Route, returns the value of the Account\_Website message header |
| getMapProperty('context\_database') | In a Talend Job<br>with tHMap, returns the value of the database context<br>variable |