# How to convert String into JSon format?

**URL:** <https://discuss.elastic.co/t/how-to-convert-string-into-json-format/295703>\
**Category:** Logstash\
**Created:** [January 28, 2022, 12:38pm UTC](https://discuss.elastic.co/t/how-to-convert-string-into-json-format/295703 "2022-01-28T12:38:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [January 28, 2022, 12:38pm UTC](https://discuss.elastic.co/t/how-to-convert-string-into-json-format/295703/1 "2022-01-28T12:38:54Z")

</div>

Hello Friends,  
Need your help to parse string into Json format in logstash.

```auto
{
   "id":"xxx",
   "MessageCreateDate":"2022-01-20",
   "Response":"{'Cardholder':{'cards':[{'isPrimaryCard':'N','cardNumber':'xxxxxxxxxx','referenceID':'xxxxxxx','customerId':'xxxx
xxxxxxxxxxxxx','billingCurrencyCode':'xxx','allocatedCreditLimit':00.00,'pendingTransactionsBalance':0.00,'allocatedCashAdvanceLimit':00.00,'baseCreditLimit':00.00,'outstanding
SettlementBalance':0.00}],'responseCode':'00','responseDesc':'YES','fee':0.00,'balance':0.0
0,'lastDepositAmount':0.00,'ledgerBalance':0.00}}"
}

```

I want to convert **Response** into JSON format from string. Everything is in json format except outer inverted commas. Is it any way to convert whole string to json format?

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [January 28, 2022, 3:57pm UTC](https://discuss.elastic.co/t/how-to-convert-string-into-json-format/295703/2 "2022-01-28T15:57:11Z")

</div>

If I use a multiline codec to consume that then

```
    mutate { gsub => ["message", "[\r\n]", "" ] }
    mutate { gsub => ["message", ":00+", ":0"] }
    json { source => "message" remove_field => ["message"] }
    mutate { gsub => ["Response", "'", '"'] }
    json { source => "Response" }

```

works for me.

---

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [January 29, 2022, 1:34pm UTC](https://discuss.elastic.co/t/how-to-convert-string-into-json-format/295703/3 "2022-01-29T13:34:45Z")

</div>

let me check

---

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [January 31, 2022, 10:17am UTC](https://discuss.elastic.co/t/how-to-convert-string-into-json-format/295703/4 "2022-01-31T10:17:20Z")

</div>

It is working fine now.

```auto
           mutate{
            gsub => ["MethodParameter", "[\r\n]", ""]
           }
            mutate{
                gsub => ["MethodParameter", '\"', '"']
            }
            json { 
                source => "MethodParameter"
                target => "MethodParameter_Json"
            }
            mutate{
                remove_field => ["MethodParameter"]
            }

```

---

<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:** [February 28, 2022, 10:18am UTC](https://discuss.elastic.co/t/how-to-convert-string-into-json-format/295703/5 "2022-02-28T10:18:12Z")

</div>

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