Get a random entry with an API call

[dbueb]

Hi Everyone,

I’m starting using Cockpit and I’m very pleased with it. I’m trying to find a way to make an GET request to receive 1 single entry randomly.

I tried sort=random but I didn’t have much luck.

Is there any thing I might try ?

PS : I use the sqlite default database.
Many thanks

[raffaelj]

I needed a random sample in the past, too. Here is a solution for multiple items with the SQLite database:

How to request x random items

Is there a simple filter function to get x random items from a filtered collection? I try to find something like this (options may change): $options = [ 'filter' => [ 'published' => true, 'active' => true, 'location' => 'Germany' ], 'fields' => [ 'title' => true, 'excerpt' => true, '_created' => true, 'slug' => true, 'image' => true, ], 'lang' => 'de', ]; // all entries, but I need 3 random ones $entries = cock…