https://community.splunk.com/t5/Knowledge-Management/How-to-retrieve-distinct-field-values-from-KV-Store-using-REST/m-p/521238#M4740 <P>Hi,</P> <P>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.</P> <P>Talking in SPL I would like to have this result:&nbsp;</P> <LI-CODE lang="markup">|inputlookup mylookup |stats values(myfield)</LI-CODE> <P>(And I don't want to use the search endpoints a query a search job by REST API that does the SPL above : )&nbsp; )</P> <P>Does anyone know if this is possible and how to do it?</P> <P>BR</P> <P>RngFox</P> Tue, 06 Oct 2020 20:18:04 GMT rngfox1 2020-10-06T20:18:04Z https://community.splunk.com/t5/Knowledge-Management/How-to-retrieve-distinct-field-values-from-KV-Store-using-REST/m-p/521238#M4740 <P>Hi,</P> <P>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.</P> <P>Talking in SPL I would like to have this result:&nbsp;</P> <LI-CODE lang="markup">|inputlookup mylookup |stats values(myfield)</LI-CODE> <P>(And I don't want to use the search endpoints a query a search job by REST API that does the SPL above : )&nbsp; )</P> <P>Does anyone know if this is possible and how to do it?</P> <P>BR</P> <P>RngFox</P> Tue, 06 Oct 2020 20:18:04 GMT https://community.splunk.com/t5/Knowledge-Management/How-to-retrieve-distinct-field-values-from-KV-Store-using-REST/m-p/521238#M4740 rngfox1 2020-10-06T20:18:04Z