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

Jakub Urbaniak 0

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.

1 answer

Amira Bedhiafi 20,176 Reputation points

2023-10-25T15:47:04.6466667+00:00
Can you try this ?

@variables('LastRestorePoint').value.properties.restorePointType
Please sign in to rate this answer.
Jakub Urbaniak 0 Reputation points

2023-10-25T16:27:36.5433333+00:00

That's what I had now I just use ('VariableName') as a filler. This is what I have and get:

Amira Bedhiafi 20,176 Reputation points

2023-10-25T16:49:01.0733333+00:00

f the JSON is correctly stored in the variable LastRestorePoint, you should be able to extract it.

Jakub Urbaniak 0 Reputation points

2023-10-25T17:28:05.82+00:00

Yea, I know there is probably a way for it to happen, but I'm unsure how to get it. The JSON should be stored properly since it comes from another web activity.

Bhargava-MSFT 29,266 Reputation points Microsoft Employee

2023-10-25T18:31:05.7533333+00:00

Can you please try using json function to convert the string value to a JSON object?

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

Jakub Urbaniak 0 Reputation points

2023-10-26T13:49:05.4233333+00:00

Unfortunately, the string value is an array value. Not a string. So the @json() expression doesn't work in this case.

"message": "The function 'json' expects its parameter to be a string or an XML. The provided value is of type 'Array'.",

Amira Bedhiafi 20,176 Reputation points

2023-10-28T14:20:54.0233333+00:00

If the restorePointType is within an array, you would access it like this, where index is the position of the element in the array:

@variables('LastRestorePoint').value.properties[index].restorePointType

Replace [index] with the actual index number of the element you want to access.
Sign in to comment

Share via

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

1 answer