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

Hola! I think we can cover many use cases using Glide’s API plugins or the JavaScript column [image]. If you give us further info we can help you better.

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

I can only see these datatypes: [image]

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

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?

Check this post it might help. [image] Fetch json with token 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?

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?

You’ll need to use a working table to transpose the data. [image] fishbaguette_breadbasket Transpose Columns to an Inline List: The Miracle Method Community Resources 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]

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

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.

Use Rest API calls as DATA

Ask for Help

Moe_A March 15, 2023, 6:38pm 7

Check this post it might help.

Topic		Replies	Views
Get rows of data into glide via call api Ask for Help api	20	230	December 9, 2024
Call API, Multiple records Ask for Help	2	339	November 18, 2023
Api interaction Ask for Help	4	565	May 13, 2022
Fetch Column Ask for Help custom-code	76	6180	March 8, 2022
How can I integrate 3rd party API to my glide app Ask for Help	15	1898	March 7, 2022

Use Rest API calls as DATA

Related topics