I would like to know how I could make a query by consuming an API from Glide. This API will return a certain number of records that I would like to insert into my Glide table. How can I do that?
Call API will only return whatever result your API gives you.
If you need them as static rows in a new table, based on the result, you must construct a batch API call to add multiple rows to your desired table.
If you don’t need them permanently, I would suggest this method.