Get random row from Business object table via REST API call

Summary

How to get randon row from table through rest api call

Content

Hi All,

I have a Business Object table created with 50 records in it, I am able to call REST endpoints(GET,POST,etc) from outside VBCS of the BO,

Now I have a requirement of getting any random row from the table through REST call.

Is this even possible for VBCS business objects rest? Please let us know if it is.

Need to get random record whenever I call the REST API of Business Object and should update one of the column for that record to identify that the particluar record is already come in random call. So that whenever I call the GET rest call, the random row should return from the rest of the rows which are never got into response.