# Fetch value by specific key of json variable

**URL:** <https://community.weweb.io/t/fetch-value-by-specific-key-of-json-variable/6569>\
**Category:** How do I?\
**Tags:** binding, filter, xano\
**Created:** [January 23, 2024, 5:22pm UTC](https://community.weweb.io/t/fetch-value-by-specific-key-of-json-variable/6569 "2024-01-23T17:22:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![FHEXL](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/fhexl/32/13607_2.png) [@FHEXL](https://community.weweb.io/u/FHEXL)\
**Post date:** [January 23, 2024, 5:22pm UTC](https://community.weweb.io/t/fetch-value-by-specific-key-of-json-variable/6569/1 "2024-01-23T17:22:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dorilama](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/dorilama/32/10403_2.png) [@dorilama](https://community.weweb.io/u/dorilama)\
**Post date:** [January 23, 2024, 6:22pm UTC](https://community.weweb.io/t/fetch-value-by-specific-key-of-json-variable/6569/2 "2024-01-23T18:22:38Z")

</div>

You can use the `lookup` formula un der the array section:  
 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/9/9eee455cd36420b5f4331a89acabe09f0a3d3f17.png)

![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/e/ecdfe71173e594e4a28c52ff957062911f32b0ac.png)

---

<div class="post-metadata">

**Author:** ![FHEXL](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/fhexl/32/13607_2.png) [@FHEXL](https://community.weweb.io/u/FHEXL)\
**Post date:** [January 23, 2024, 7:35pm UTC](https://community.weweb.io/t/fetch-value-by-specific-key-of-json-variable/6569/3 "2024-01-23T19:35:59Z")

</div>

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.
