Fetch value by specific key of json variable

Ask us anything How do I?
, ,
1

Hi there,

Let’s say I have a variable that is a json array with objects that consists of key/value.

[
{
“Key”: “item1”
“Value”: “value of item 1”
},
{
“Key”: “item2”
“Value”: “value of item 2”
}
]

So for example: How do I get the value where key = “item2”

Thanks in advance.

2

You can use the lookup formula un der the array section:
image

image

3

Great. More efficient then a combination of filterbykey and getkeyvalue. And good to see that that dot notation to fetch the value of value key works. I will try this out.