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…

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 da…

Use Rest API calls as DATA

Ask for Help

Robert_Petitto March 16, 2023, 12:18am 9

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

Topic		Replies	Views
Get rows of data into glide via call api Ask for Help api	21	144	December 16, 2024
Call API, Multiple records Ask for Help	2	330	November 18, 2023
Api interaction Ask for Help	5	539	May 14, 2022
Fetch Column Ask for Help custom-code	76	5722	March 8, 2022
How can I integrate 3rd party API to my glide app Ask for Help	15	1825	March 7, 2022

Use Rest API calls as DATA

Related topics