Generate .csv using Elasticsearch API

Elastic Stack Elasticsearch
1

Hi team,

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

Thanks

2

Have a look at

3

@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

Thanks

4

I don't understand.

5

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.

6

So we are all good?

BTW update to 7.9.3 or better 7.10.0 :slight_smile:

7

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