Hi All! So I am trying to use the API to query items in a collection. However I know that the items that I would need are only a subset of the entire items in the collection. So in order for me to get all the items I am querying for, I need to get back ALL items and filter them out on my end. The API seems like it only provides methods for querying a single item from a collection or querying ALL items in a collection. Is there a way to query a subset of items in a collection based upon some sort of reference ID?
For example if I had 2 collections: users, favorite_songs. The favorite songs collection would contain all the favorite songs from each user. But if I had thousands of users and each had about 10 favorite songs, that means I would have to loop through 10,000 items just to retrieve the 10 I really needed. I should be able to query the favorite_songs collection by the user_id referenced in the users collection.
Is this scenario possible via the API? I can’t imagine that Webflow would be able to scale their customers sites without doing this in their own backend, so why is this not available via the API?