Exporting data into HTML table

Elastic Stack Elasticsearch
1

Hello,

I am looking for a tool that lets you export data stored in Elasticsearch on a file in HTML format.

I know that you can use Kibana to export the content of an index (or a subset) into CSV format.
Do you know if there is a tool I can use to export data directly into a HTML table from ES?
I do not want take the CSV produced by Kibana and transform it into a HTML table.

Let me give you an example.

Suppose I have the following data in an Elasticsearch index (just showing the original JSON):

[
	{
		"@timestamp": "2021-11-05T00:00:00.000Z",
		"user_name": "alessandro",
		"user_email": "alessandro@gmail.com",
		"message": "hello world",
		"status": "OK"
	},
	{
		"@timestamp": "2021-11-05T01:00:00.000Z",
		"user_name": "mario",
		"user_email": "mario@gmail.com",
		"message": "this is a test message",
		"status": "KO"
	},
	{
		"@timestamp": "2021-11-05T02:00:00.000Z",
		"user_name": "giuseppe",
		"user_email": "giuseppe@hotmail.com",
		"message": "lorem ipsum dolor sit amet",
		"status": "KO"
	}
]

If I exported it into CSV by using Kibana I would get something like this:

@timestamp,user_name,user_email,message,status
2021-11-05T00:00:00.000Z,alessandro,alessandro@gmail.com,"hello world",OK
2021-11-05T01:00:00.000Z,mario,mario@gmail.com,"this is a test message",KO
2021-11-05T02:00:00.000Z,giuseppe,giuseppe@hotmail.com,"lorem ipsum dolor sit amet",KO

Now, I would like instead to export it into a HTML table, like the following:

<TABLE id="" cellSpacing="1" cellPadding="1" width="100%" border="1" >
	<TR>
		<TD>@timestamp</TD>
		<TD>user_name</TD>
		<TD>user_email</TD>
		<TD>message</TD>
		<TD>status</TD>
	</TR>
	<TR>
		<TD>2021-11-05T00:00:00.000Z</TD>
		<TD>alessandro</TD>
		<TD>alessandro@gmail.com</TD>
		<TD>hello world</TD>
		<TD>OK</TD>
	</TR>
	<TR>
		<TD>2021-11-05T01:00:00.000Z</TD>
		<TD>mario</TD>
		<TD>mario@gmail.com</TD>
		<TD>this is a test message</TD>
		<TD>KO</TD>
	</TR>
	<TR>
		<TD>2021-11-05T02:00:00.000Z</TD>
		<TD>giuseppe</TD>
		<TD>giuseppe@hotmail.com</TD>
		<TD>lorem ipsum dolor sit amet</TD>
		<TD>KO</TD>
	</TR>
</TABLE>

Do you know if there is a tool that lets you do this?

2

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