Extract value from array in datafactory

Question

how can I extract the value of the Name element from the following array in datafactory:

{ "variableName": "PiQuality", "value": { "Value": { "Value": { "Name": "vaCurrent" } } } }

Thankyou so much.

Dharman · Accepted Answer · 2020-11-17 21:17:06Z

1

So I just tried this, created a string variable called "try" and set it with your example json. Then I set a second string variable with the following value:

@json(variables('try')).value.Value.Value.Name

So this first converts the string to a json, and then navigates the properties until it gets to the one you are looking for.

edited Nov 17, 2020 at 21:17

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Nov 17, 2020 at 21:11

Martin Esteban Zurita

3,18416 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Extract value from array in datafactory

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related