# Create an api call from database **URL:** \ **Category:** Get Help\ **Created:** [February 2, 2023, 8:06pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933 "2023-02-02T20:06:38Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 2, 2023, 8:06pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/1 "2023-02-02T20:06:38Z")
I’m attempting to use a foods database found here: > **[Build, Collaborate & Integrate APIs | SwaggerHub](https://app.swaggerhub.com/apis/fdcnal/food-data_central_api/1.0.1#/FDC/getFoodsSearch)** > > Join thousands of developers who use SwaggerHub to build and design great APIs. Signup or login today. But I’m having trouble filling out all the correct information for my API call. Can anyone help me out? ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 2, 2023, 8:27pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/2 "2023-02-02T20:27:07Z")
Hi @mrentrekin, You need to use the foods search? ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/7/e/7e2c0f4a7dde755b45e553a5ab1816324528b654.png) And then get the response through a external collection and display in a list? ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/f/5/f5d27088020458ac081cc878e84574f3bba5f083.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/f/e/fead45598efbaf766f0efbb871d0b900f0c14f4a.png) Thank you ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 2, 2023, 9:48pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/3 "2023-02-02T21:48:59Z")
Any chance you could make a two minute video? Thanks for these! I’ll attempt to parse through them later if you can’t! ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 2, 2023, 10:15pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/4 "2023-02-02T22:15:58Z")
> [@mrentrekin](#): > > Any chance you could make a two minute video? For sure! Here’s what I did : [Food API.mp4 on Vimeo](https://vimeo.com/795400416) The website URL to get the API Key : [FoodData Central](https://fdc.nal.usda.gov/api-key-signup.html) API Base URL : [https://api.nal.usda.gov/fdc/v1/foods/search](https://api.nal.usda.gov/fdc/v1/foods/search) ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 3, 2023, 4:12am UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/5 "2023-02-03T04:12:14Z")
I literally followed the entire video! And I still can’t retrieve it! Can I add you as a team member and you can tell me what I’m doing wrong? ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 3, 2023, 5:19am UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/6 "2023-02-03T05:19:26Z")
Yeah for sure! Here’s my email ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 3, 2023, 12:44pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/7 "2023-02-03T12:44:13Z")
Adding you now! It’s 100% bare bones at the moment because I wanted to get that down before I did anything else, and I need that to be able to journal. Also, I couldn’t set it up to look at errors because the test keeps failing! ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 3, 2023, 12:49pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/8 "2023-02-03T12:49:52Z")
So I’m actually asking you to set it up for me, since I can’t save any attempt for you to review. If you have a website or something I can donate 🙂 ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 3, 2023, 12:50pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/9 "2023-02-03T12:50:48Z")
Last thing! I’ll drop the api\_key in a user property named that! ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 3, 2023, 12:55pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/10 "2023-02-03T12:55:34Z")
> [@mrentrekin](#): > > Last thing! I’ll drop the api\_key in a user property named that! I was going to message you for this but you sent it now 😂 Telepathy 🤯 ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 3, 2023, 12:56pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/11 "2023-02-03T12:56:28Z")
> [@mrentrekin](#): > > So I’m actually asking you to set it up for me, since I can’t save any attempt for you to review. The setup that I made in the video right? ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 3, 2023, 1:08pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/12 "2023-02-03T13:08:00Z")
Yeah, please! Thanks man! ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 3, 2023, 1:15pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/13 "2023-02-03T13:15:05Z")
Give a refresh to the editor and check the app! ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 3, 2023, 1:43pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/14 "2023-02-03T13:43:33Z")
Dude! You’re amazing! Why do you think it’s only populating the A’s? Just the sheer volume? I tried to import a csv instead of using API, but it was too big a file. ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 3, 2023, 1:49pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/15 "2023-02-03T13:49:20Z")
> [@mrentrekin](#): > > Why do you think it’s only populating the A’s? Just the sheer volume? Did’t get it 😶 Could you explain a bit more? ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 3, 2023, 3:13pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/16 "2023-02-03T15:13:29Z")
This is as much as I’m getting when I scroll. ![Screen Shot 2023-02-03 at 10.11.37 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/1/a/1a725a9ce5faa6cbbe93b49a694854d344919095.png) ---
**Author:** ![mrentrekin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mrentrekin/32/13083_2.png) [@mrentrekin](https://forum.adalo.com/u/mrentrekin)\ **Post date:** [February 3, 2023, 3:18pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/17 "2023-02-03T15:18:36Z")
Also, I feel like I followed your instructions! Crazy that it didn’t work but yours did 🙂 ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 3, 2023, 5:21pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/18 "2023-02-03T17:21:13Z")
You need more items? ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 3, 2023, 5:33pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/19 "2023-02-03T17:33:52Z")
I’m guessing that you didn’t added the result key. But anyway that it’s working now! ---
**Author:** ![Khaire.ibraahim](https://avatars.discourse-cdn.com/v4/letter/k/4da419/32.png) [@Khaire.ibraahim](https://forum.adalo.com/u/Khaire.ibraahim)\ **Post date:** [February 4, 2023, 8:35pm UTC](https://forum.adalo.com/t/create-an-api-call-from-database/35933/20 "2023-02-04T20:35:49Z")
Hey, I am actually facing the same issue, I got News APi from [Newsapi.org](http://Newsapi.org) and it only calls one news repeating again and again. [Next page](https://forum.adalo.com/t/create-an-api-call-from-database/35933.md?page=2)