How to retrieve distinct field values from KV Store using REST API?

[rngfox1]

Hi,

I have a collection in the KV Store that contains several 10,000's of documents. Each document has a specific field that is present in each of them - sometimes values are the same, sometimes different. I need to retrieve a list of all possible values by REST API.

Talking in SPL I would like to have this result: 

|inputlookup mylookup |stats values(myfield)

(And I don't want to use the search endpoints a query a search job by REST API that does the SPL above : )  )

Does anyone know if this is possible and how to do it?

BR

RngFox