Best way to extract a CSV with aggregations

Elastic Stack Elasticsearch
1

Hi,

I was wondering what is the best way to extract a csv with the various
terms of some fields alongside with the corresponding counts? For example
create a csv as follows:

productId, product, category, city, hour, products_count,

selled_products_count

Will cat API be useful in this case? Or I have to pass from multiple
aggregation calls to construct this information?

Thanks
Thomas

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6756e0e8-cf82-40b8-9bd5-8713bb85aed8%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

2

You'll probably need to parse the JSON query results in your programming
language to constuct a CSV result yourself. No the CAT API has a different
purpose - it is used to display columnar views of cluster/index/node info
and statistics - not query results.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/36ca9219-00ce-4145-a1df-bde2f5a36f09%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.