Hola @Gerard_Fernandez
What I understood is:
- he wants to receive all data from an API request into a kind of Glide dynamic table (“skip storing this remote data into tables”), something similar to what Adalo does, he called it "External Collections” .
With it, I guess that any APP doesn’t consume rows. The case is opposite if you put all this in a Google Sheet, you will have to read and sync that data constantly and your APP’s row usage will be higher.
What we do in these cases is what this thread shows (what my example does too) using a transpose trick: Fetch Data from API and display array result in Collection
Saludos!
`