Generate .csv using Elasticsearch API

Hi team,

Can I create .csv file using Elasticsearch REST API. Because I want automatic .csv file generation mechanism.


Have a look at

@dadoonet Thanks for reply.

I want to fetch logs from Elasticsearch using REST API and store them into CSV format.

Elasticsearch version - 7.9.0


I don't understand.

Hi @dadoonet

I used following query and it return data in csv format. Is it right formation?

POST /_sql?format=csv
  "query": """
  SELECT * FROM "index-name" WHERE event.event_header.client_code = 'AMX153'

Thanks for help.

So we are all good?

BTW update to 7.9.3 or better 7.10.0 :slight_smile:

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.