# Problem with API Airtable **URL:** \ **Category:** Web API's\ **Created:** [July 14, 2022, 8:36am UTC](https://community.thunkable.com/t/problem-with-api-airtable/1963339 "2022-07-14T08:36:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![peterroxv6](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/peterroxv6/32/152780_2.png) [@peterroxv6](https://community.thunkable.com/u/peterroxv6)\ **Post date:** [July 14, 2022, 8:36am UTC](https://community.thunkable.com/t/problem-with-api-airtable/1963339/1 "2022-07-14T08:36:42Z")
Hi guys, I’m pretty new here and enjoying Thunkable immensely - however, I’m stuck when it comes to doing queries in Airtable. The situation: I want to filter thousands of Airtable records by name, age group, company code etc. and have built it in Thunkable - and that works, but it takes a lot if time to download all these records and filter them in the app. And I mean: hours. So, I thought it might be better to create an API to do the filtering in Airtable and only download the selected records to the app. And that is something I can’t master. I’ve read a lot in this community but somehow I can’t even download the records with an API. In the enclosed example, I tried to get a list of just the UserID’s from the records in Airtable. to no avail. My question: what am I forgetting? Cheers, Peter ![Screen Shot 2022-07-14 at 16.21.49](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/c/3c5a06cc8def4d7bcaa962f347332ef60f103688.png) ---
**Author:** ![zander](https://avatars.discourse-cdn.com/v4/letter/z/ecb155/32.png) [@zander](https://community.thunkable.com/u/zander)\ **Post date:** [July 14, 2022, 4:35pm UTC](https://community.thunkable.com/t/problem-with-api-airtable/1963339/2 "2022-07-14T16:35:34Z")
Check out this post it might have the answer you’re looking for 🙂 [https://community.thunkable.com/t/airtable-tutorial](https://community.thunkable.com/t/airtable-tutorial) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 14, 2022, 8:03pm UTC](https://community.thunkable.com/t/problem-with-api-airtable/1963339/3 "2022-07-14T20:03:34Z")
Why are you initializing the `Query Parameters` part of the `web API` this way? Remove it and if the URL is correct then you should get all records in the table referenced in the URL. Another issue is the code inside the loop is wrong. You should use one of the `Lists` blocks. ---
**Author:** ![peterroxv6](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/peterroxv6/32/152780_2.png) [@peterroxv6](https://community.thunkable.com/u/peterroxv6)\ **Post date:** [July 16, 2022, 1:58am UTC](https://community.thunkable.com/t/problem-with-api-airtable/1963339/4 "2022-07-16T01:58:11Z")
Thank you very much, indeed now I get the output in a JSON-list :-)) Next challenge is to convert that into Thunkable variables to work with. ![Screen Shot 2022-07-16 at 09.54.54](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/9/594f23a786ddf81597edb133aba569c9f61935c9.png) ---
**Author:** ![peterroxv6](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/peterroxv6/32/152780_2.png) [@peterroxv6](https://community.thunkable.com/u/peterroxv6)\ **Post date:** [July 16, 2022, 2:01am UTC](https://community.thunkable.com/t/problem-with-api-airtable/1963339/5 "2022-07-16T02:01:21Z")
Thank you - it seems the links in that topic are inactive. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 17, 2022, 1:54pm UTC](https://community.thunkable.com/t/problem-with-api-airtable/1963339/6 "2022-07-17T13:54:22Z")
Your loop is constructed wrongly. You need to use the green block `response` instead of the variable in the loop after converting `response` to an object. The list should be filled with `j` variable of the loop. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:13pm UTC](https://community.thunkable.com/t/problem-with-api-airtable/1963339/7 "2024-11-08T13:13:03Z")