# Populate App With Food API (JSON)

**URL:** https://community.glideapps.com/t/populate-app-with-food-api-json/15104
**Category:** Ask for Help
**Created:** [September 1, 2020, 9:42pm UTC](https://community.glideapps.com/t/populate-app-with-food-api-json/15104 "2020-09-01T21:42:33Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![jen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jen/32/12897_2.png) [@jen](https://community.glideapps.com/u/jen)
#### Post date: [September 1, 2020, 9:42pm UTC](https://community.glideapps.com/t/populate-app-with-food-api-json/15104/1 "2020-09-01T21:42:33Z")

</div>

Hi

We need assistance in populating app with food from food databases with APIs.  
We’re using json. But aren’t having any luck in the query/food being populated.Once it does work it will go beyond a max of 25k rows which exceeds what Glide apps will hold but is a great start. And will use Chomp as its Canadian based. But also want the data for Fatsecret and Nutrionix (links found in excel sheet)

We tried the IP address into Fatsecret but it’s not working.

Here is a copy of our spreadsheet. (Use Tab 1)

> **[Google.Glide Apps. API (V2)](https://docs.google.com/spreadsheets/d/1A3vRyCoKCIVi-bLFClD1ZTA8OzE57lPVbnyg1JCpK4o/edit?usp=drivesdk)**
>
> Method 1 &amp; 2 
> 
> 
> Urls:,https://platform.fatsecret.com/js?key=cdf7f73d80a74ed997906d5ea2d9f59a
> Filter:
> Last update
> Results ▶︎

Helpful site

> **[ImportJSON | Import JSON data into Google Sheets - Google Workspace Marketplace](https://workspace.google.com/marketplace/app/importjson_import_json_data_into_google/782573720506)**
>
> Import JSON data from any API and convert it into an easy-to-read table. All through a simple function!

---

<div class="post-metadata">

### Author: ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [September 1, 2020, 11:08pm UTC](https://community.glideapps.com/t/populate-app-with-food-api-json/15104/2 "2020-09-01T23:08:27Z")

</div>

Welcome to the community @jen

---

<div class="post-metadata">

### Author: ![jen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jen/32/12897_2.png) [@jen](https://community.glideapps.com/u/jen)
#### Post date: [September 2, 2020, 10:07pm UTC](https://community.glideapps.com/t/populate-app-with-food-api-json/15104/3 "2020-09-02T22:07:26Z")

</div>

Thanks!