# \_jsonparsefailure with special characters?

**URL:** <https://discuss.elastic.co/t/jsonparsefailure-with-special-characters/220585>\
**Category:** Logstash\
**Created:** [February 24, 2020, 7:53am UTC](https://discuss.elastic.co/t/jsonparsefailure-with-special-characters/220585 "2020-02-24T07:53:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![barryb](https://avatars.discourse-cdn.com/v4/letter/b/d78d45/32.png) [@barryb](https://discuss.elastic.co/u/barryb)\
**Post date:** [February 24, 2020, 7:53am UTC](https://discuss.elastic.co/t/jsonparsefailure-with-special-characters/220585/1 "2020-02-24T07:53:34Z")

</div>

We are getting \_jsonparsefailure for some records being input from a client in France  
We have a copy of their Database and when importing with the same logstash.config file we succeed in parsing all the records correctly. from their site, they get "\_jsonparsefailure" for some records.  
the filter code which fails is:  
if [mdprops]  
{  
mutate {  
add\_field =\> {"[MDProperties][Type]" =\> "%{[mdprops][MDProperties][Type]}"}  
add\_field =\> {"[MDProperties][Name]" =\> "%{[mdprops][MDProperties][Name]}"}  
add\_field =\> {"[MDProperties][Value]" =\> "%{[mdprops][MDProperties][Value]}"}   
remove\_field =\> ["json", "mdprops"]  
}  
}

I see that the input contains a special character ° (degree)  
"MDProperties": [  
{  
"Type": 3,  
"Name": "JTO Aircraft Conditions",  
"Value": " **FROM/TO:** LFBO/LFBO **SFC WIND:** 320°/10 Kt **QNH:** 1020 HPa\n **ZFW:** 17000 KG (72) **CRZ WIND:** 320°/20 Kt \n **FUEL:** 2000 KG (72) **MET:** CAVOK \n **CG:** 25%(72) **OAT** + 15°C\n **DEP:** 32R\n **ARR:** ILS32R"  
},  
{  
"Type": 1,  
"Name": "JTO Group Num",  
"Value": "0"  
}  
]

the output for this record is:  
"MDProperties" : {  
"Value" : "%{[mdprops][MDProperties][Value]}",  
"Name" : "%{[mdprops][MDProperties][Name]}",  
"Type" : "%{[mdprops][MDProperties][Type]}"  
},

{

Thanks,  
Barry

---

<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:** [March 23, 2020, 7:53am UTC](https://discuss.elastic.co/t/jsonparsefailure-with-special-characters/220585/2 "2020-03-23T07:53:34Z")

</div>

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