Hi Team!
Goal: I currently have a use case where I need to display the first entry on certain bucket.
Problem
Currently there is no documentation regarding how to efficiently do this, it seems I have to list all the files first then just do {{ data[0] }}
But this is also a problem on its own. Several bucket folders have quite plenty of entries:
This makes Retool to immediately throw an error because the response exceeds 100MB:
I read from the Cloud Storage JSON API overview | Google Cloud that we could use Partial Response here but I have no idea how to do it with Retool.
Any advice is appreciated, thank you!