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?