Use Rest API calls as DATA

Ask for Help
1

How can I use REST API calls as DATA in Glide?

Thanks!

2

Hola!

I think we can cover many use cases using Glide’s API plugins or the JavaScript column

image
image470×563 34.9 KB
.

If you give us further info we can help you better.

3

Thanks! Where can I find Glide’s API plugins or the JavaScript column?

4

I can only see these datatypes:

image
image768×1038 38.6 KB

5

You have to create a new column and you’ll be able to see them

6

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?

7

Check this post it might help.

1 Like
8

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?

9

You’ll need to use a working table to transpose the data.

1 Like
10

Thanks Robert! But this still does not create rows for each entry in the JSON.

11

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.

1 Like
12

Wow, we need a native API-database integration like Adalo has:

image
image1350×1148 41.6 KB

13

You mean like this?

1 Like