# Fetch JSON with username

**URL:** <https://community.glideapps.com/t/fetch-json-with-username/45952>\
**Category:** Ask for Help\
**Created:** [August 4, 2022, 3:37pm UTC](https://community.glideapps.com/t/fetch-json-with-username/45952 "2022-08-04T15:37:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mike](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike/32/45713_2.png) [@mike](https://community.glideapps.com/u/mike)\
**Post date:** [August 4, 2022, 3:37pm UTC](https://community.glideapps.com/t/fetch-json-with-username/45952/1 "2022-08-04T15:37:24Z")

</div>

Hi,

new to glide and have 2 questions.

1. Using the fetch JSON feature I need to fetch an API where I can not fetch all results and filter for the username of the glide table so I thought I can use “Custom” in the URL field and then add to the url something like {Name} so the request will be like transformed to [api.com/players/mike](http://api.com/players/mike) where mike was the name from the glide users table but the request is in fact [api.com/players/{Name}](http://api.com/players/%7BName%7D) and fails.

2. If 1. is working the field has JSON. Can I use this field with JSON and add a UI component which populates the fields with the JSON or do i have to use jq in the fetch feature and filter for every single value (name, score, tag, etc.)?

Thanks for any help

Mike

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [August 4, 2022, 7:14pm UTC](https://community.glideapps.com/t/fetch-json-with-username/45952/2 "2022-08-04T19:14:13Z")

</div>

1. Use Template column to construct URL
2. You have to filter JSON with jq

---

<div class="post-metadata">

**Author:** ![mike](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike/32/45713_2.png) [@mike](https://community.glideapps.com/u/mike)\
**Post date:** [August 7, 2022, 7:26pm UTC](https://community.glideapps.com/t/fetch-json-with-username/45952/3 "2022-08-07T19:26:55Z")

</div>

thanks that did it.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 8, 2022, 7:27pm UTC](https://community.glideapps.com/t/fetch-json-with-username/45952/4 "2022-08-08T19:27:45Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.