How to build expression in ADF from json using parameterized variable?

Question

I have one activity output like this

{
    "firstRow": {
        "mapping": "{\"CHRSCRT\":\"CHRT\",\"CST\":\"CUSTOM\"}"
    }
}

an second activity output like

{
    "name": "FF",
    "value": "CST"
}

Now i want to take only one value from mapping table using the second variable.

I tried

@{json(activity('1stActivity').output.firstRow.mapping)}.@{variables('secondActivity')}}

I want output like CUSTOM

But i am getting output {\"CHRSCRT\":\"CHRT\",\"CST\":\"CUSTOM\"}.CST

Please help in this expression builder in ADF.

@RakeshGovindula no I am not getting error but I need desired result, how can I get that? — amit.k.maurya.16
– amit.k.maurya.16, Commented Oct 18, 2024 at 6:05

Rakesh Govindula · Accepted Answer · 2024-10-18 06:27:34Z

0

I want output like CUSTOM

To achieve your requirement, you can modify your dynamic expression without string interpolation like below.

@json(activity('1stActivity').output.firstRow.mapping)[variables('secondActivity')]

enter image description here

Here, it uses [] notation instead of . to specify the key from the secondActivity output.

Result:

enter image description here

answered Oct 18, 2024 at 6:27

Rakesh Govindula

11.9k2 gold badges5 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1