Azure Data Factory

Getting Started

Syntax

Coalesce

ExistsNot Exists

P_EXTRACT

{
    "parent": {
      "child": {
        "key": "value"
      }
    }
}

@coalesce(parameters.P_EXTRACT.parent.child?.key, 'default')

Output:

value

P_EXTRACT

{
    "parent": {
      "child": {
        "foo": "bar"
      }
    }
}

@coalesce(parameters.P_EXTRACT.parent.child?.key, 'default')

Output:

default

Read Mores