# Change format json file to metrics with Logstash and save it in Victoria Metrics

**URL:** https://discuss.elastic.co/t/change-format-json-file-to-metrics-with-logstash-and-save-it-in-victoria-metrics/255732
**Category:** Logstash
**Created:** [November 17, 2020, 3:56pm UTC](https://discuss.elastic.co/t/change-format-json-file-to-metrics-with-logstash-and-save-it-in-victoria-metrics/255732 "2020-11-17T15:56:07Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![recepbalibey](https://avatars.discourse-cdn.com/v4/letter/r/e9bcb4/32.png) [@recepbalibey](https://discuss.elastic.co/u/recepbalibey)
#### Post date: [November 17, 2020, 3:56pm UTC](https://discuss.elastic.co/t/change-format-json-file-to-metrics-with-logstash-and-save-it-in-victoria-metrics/255732/1 "2020-11-17T15:56:07Z")

</div>

Here is only one example from my JSON file \>\>

`{"host":"ABCDEFASD","groups":["ABVD","TEST"],"applications": ["NETWORK"],"itemid":143172,"name":"Operational status of interface Se0/1/0:17","clock":1604283792,"ns":926563322,"value":2}`

AND I want to change this json file to metrics format:

`metrics{host="ABCDEFASD", groups="ABVD",groups="TEST",applications="NETWORK",name="Operational status of interface Se0/1/0:17", "itemid":143172}`

Remove \> value, ns, clock  
Separate \> ` "groups":[ABVD","TEST"] groups="ABVD",groups="TEST" metrics { } `

Can you help me with this? What should I follow with my config file? (Sorry I am a beginner to Logstash) I am connecting to SSH server with putty \>\> CentOS8 Linux Machine

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 15, 2020, 3:56pm UTC](https://discuss.elastic.co/t/change-format-json-file-to-metrics-with-logstash-and-save-it-in-victoria-metrics/255732/2 "2020-12-15T15:56:14Z")

</div>

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