Get a single record from a database filtered by category_id and then randomised id

Steve Wright-2225084

I have a list of prompts that are all categorised. I want to set up an API to GET a single record, randomly, from a specific category.

I can easily filter by category ID and fetch a list of all prompts, but I can't see how to only select one from within that category and randomise which is picked.

Any help much appreciated!

Table structure:[Screenshot 2022-01-21 at 14.05.42.png]
Thanks

Michael Udinski

This is all done in the Return section of Query All Records. Set the return type to single and add a random sort:

[CleanShot 2022-01-21 at 09.12.17.png]

Steve Wright-2225084

 Thanks! All working