# Other functions


Following, find reference topics for other functions that work with recipe actions. 

**Topics**
+ [

# COALESCE
](recipe-actions.COALESCE.md)
+ [

# GET\$1ACTION\$1RESULT
](recipe-actions.GET_ACTION_RESULT.md)
+ [

# GET\$1STEP\$1DATAFRAME
](recipe-actions.GET_STEP_DATAFRAME.md)

# COALESCE


Returns in a new column the first non-null value found in the array of columns. The order of the columns listed in the function determines the order in which they're searched.

**Parameters**
+ `sourceColumns` – A JSON-encoded string representing list of existing columns.
+ `targetColumn` – The name of the new column to be created.

**Example**  
  

```
{
    "RecipeAction": {
        "Operation": "COALESCE",
        "Parameters": {
            "sourceColumns": "[\"nation_position\",\"joined\"]",
            "targetColumn": "COALESCE Column 1"
        }
    }
}
```

# GET\$1ACTION\$1RESULT


Fetches the result of a previously submitted action. Only for use in the interactive experience.

**Parameters**
+ `actionId` – The ActionId returned in the original SendProjectSessionAction response.

**Example**  
  

```
{
    "RecipeAction": {
        "Operation": "GET_ACTION_RESULT",
        "Parameters": {
            "actionId": "7",
        }
    }
}
```

# GET\$1STEP\$1DATAFRAME


Fetches the data frame from a step in the project's recipe. Only for use in the interactive experience. Used with the ViewFrame parameter to paginate across a large data frame.

**Parameters**
+ `stepIndex` – The index of the step in the project's recipe for which to fetch the data frame.

**Example**  
  

```
{
    "RecipeAction": {
        "Operation": "GET_STEP_DATAFRAME",
        "Parameters": {
            "stepIndex": "0"
        }
    }
}
```