How can I get a certain value out of a variable in ADF?

Jakub Urbaniak 0 Reputation points
2023-10-25T14:34:38.8566667+00:00

I have an appended variable that has a JSON value passed into it.

{
    "variableName": "LastRestorePoint",
    "value": {
        "location": "North Central US",
        "properties": {
            "restorePointType": "DISCRETE"
		}
	}
}

How would I go about calling only one value out of this? I want to get say the "restorePointType" out of this, but I don't know the method for doing this.

I know if this was a web activity you would do @{activity('WebActivityName').output.value.properties.restorePointType}. But the same is not the case if you're doing a variable call. @{variables('VariableName').output.value.properties.restorePointType} does not work the same.

So how do I draw out the value restorePointType specifically from the variable.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,566 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 18,186 Reputation points
    2023-10-25T15:47:04.6466667+00:00

    Can you try this ?

    @variables('LastRestorePoint').value.properties.restorePointType