# Use Rest API calls as DATA
**URL:** https://community.glideapps.com/t/use-rest-api-calls-as-data/59185
**Category:** Ask for Help
**Created:** [March 15, 2023, 10:53am UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185 "2023-03-15T10:53:01Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@Patrick\_Mast](https://community.glideapps.com/u/Patrick_Mast)
#### Post date: [March 15, 2023, 10:53am UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/1 "2023-03-15T10:53:01Z")
How can I use REST API calls as DATA in Glide?
Thanks!
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [March 15, 2023, 4:39pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/2 "2023-03-15T16:39:25Z")
Hola!
I think we can cover many use cases using Glide’s API plugins or the JavaScript column
.
If you give us further info we can help you better.
---
### Author:  [@Patrick\_Mast](https://community.glideapps.com/u/Patrick_Mast)
#### Post date: [March 15, 2023, 5:41pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/3 "2023-03-15T17:41:13Z")
Thanks! Where can I find Glide’s API plugins or the JavaScript column?
---
### Author:  [@Patrick\_Mast](https://community.glideapps.com/u/Patrick_Mast)
#### Post date: [March 15, 2023, 5:53pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/4 "2023-03-15T17:53:49Z")
I can only see these datatypes:
---
### Author:  [@Moe\_A](https://community.glideapps.com/u/Moe_A)
#### Post date: [March 15, 2023, 6:03pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/5 "2023-03-15T18:03:24Z")
You have to create a new column and you’ll be able to see them
---
### Author:  [@Patrick\_Mast](https://community.glideapps.com/u/Patrick_Mast)
#### Post date: [March 15, 2023, 6:32pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/6 "2023-03-15T18:32:29Z")
Oh, now I see. Yes, the first column has limited field types. New columns have them all! GREAT!!
One more question. My API provider needs an authorization toke key send via headers. How can do do that?
---
### Author:  [@Moe\_A](https://community.glideapps.com/u/Moe_A)
#### Post date: [March 15, 2023, 6:38pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/7 "2023-03-15T18:38:42Z")
Check this post it might help.
> [@Fetch json with token](https://community.glideapps.com/t/fetch-json-with-token/53097):
>
> Hi wave I’m new here and seeing that i can use my external API was really great! but my API require a user-token in the headers of the request. is this possible to achieve?
---
### Author:  [@Patrick\_Mast](https://community.glideapps.com/u/Patrick_Mast)
#### Post date: [March 15, 2023, 7:07pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/8 "2023-03-15T19:07:16Z")
Ok, so, this method gives fetches data into ONE column. But the API provider returns an ARRAY of rows. How can I tell Glide to have 100 rows if the API returns a JSON with an array of 100?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 16, 2023, 12:18am UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/9 "2023-03-16T00:18:00Z")
You’ll need to use a working table to transpose the data.
> [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766):
>
> I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)
---
### Author:  [@Patrick\_Mast](https://community.glideapps.com/u/Patrick_Mast)
#### Post date: [March 21, 2023, 7:38pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/10 "2023-03-21T19:38:06Z")
Thanks Robert! But this still does not create rows for each entry in the JSON.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 21, 2023, 8:14pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/11 "2023-03-21T20:14:20Z")
You need to create the maximum number of rows in your working table, to cover the maximum number of items that you think your API could return. @Robert_Petitto’s method will not auto generate the needed rows for you. You need to create them, and use the method to populate all of those rows with data from the API.
---
### Author:  [@Patrick\_Mast](https://community.glideapps.com/u/Patrick_Mast)
#### Post date: [March 22, 2023, 6:11pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/12 "2023-03-22T18:11:33Z")
Wow, we need a native API-database integration like Adalo has:
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 22, 2023, 6:21pm UTC](https://community.glideapps.com/t/use-rest-api-calls-as-data/59185/13 "2023-03-22T18:21:27Z")
You mean like this?
> **[Glide • Glide Tables API](https://www.glideapps.com/docs/reference/data-sources/glide-tables-api)**
>
> Explore what you can do with the Glide Tables API