# Error on my json

**URL:** <https://discuss.elastic.co/t/error-on-my-json/176811>\
**Category:** Elasticsearch\
**Created:** [April 15, 2019, 2:57am UTC](https://discuss.elastic.co/t/error-on-my-json/176811 "2019-04-15T02:57:42Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ridwan\_Syarifudin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ridwan_syarifudin/32/44111_2.png) [@Ridwan\_Syarifudin](https://discuss.elastic.co/u/Ridwan_Syarifudin)\
**Post date:** [April 15, 2019, 2:57am UTC](https://discuss.elastic.co/t/error-on-my-json/176811/1 "2019-04-15T02:57:42Z")

</div>

this is my code for simulate  
\</\>  
POST \_ingest/pipeline/\_simulate  
{  
"pipeline": {  
"description": "parsing master produk indexing",  
"processors": [  
{  
"grok": {  
"field": "message",  
"patterns": [  
"""%{NUMBER:id\_product};"%{DATA:code\_product}";"%{DATA:name\_product}";"%{DATA:satuan\_product}";"%{DATA:merek\_vehicle}";"%{DATA:jenis\_vehicle}";"%{DATA:merek\_product}";"%{DATA:part\_number}";%{NUMBER:weight};"%{DATA:unit\_weight}""""  
]  
}  
},  
{  
"remove": {  
"field": "message"  
}  
}  
]  
},

"docs": [  
{  
"\_index": "master\_product\_info",  
"\_type": "message",  
"\_id": "AVvJZVQEBr2flFKzrrkr",  
"\_score": 1,  
"\_source": {  
"message": """42305;"FX4PER000501I";"PER DPN F-50 DH-0005-01 48110-87624-01 MITS";"PCS";"DAIHATSU";"";"INDOSPRING";"";;"""""  
}  
}  
]  
}  
\</\>

somehow i got an error like this  
\</\>  
{  
"error": {  
"root\_cause": [  
{  
"type": "parse\_exception",  
"reason": "Failed to parse content to map"  
}  
],  
"type": "parse\_exception",  
"reason": "Failed to parse content to map",  
"caused\_by": {  
"type": "json\_parse\_exception",  
"reason": "Unexpected character ('"' (code 34)): was expecting comma to separate Array entries\n at [Source: org.elasticsearch.transport.netty4.ByteBufStreamInput@421e7b4e; line: 9, column: 254]"  
}  
},  
"status": 400  
}  
\</\>

how do i fix this?? please help

---

<div class="post-metadata">

**Author:** ![gabriel\_tessier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabriel_tessier/32/27911_2.png) [@gabriel\_tessier](https://discuss.elastic.co/u/gabriel_tessier)\
**Post date:** [April 15, 2019, 3:20am UTC](https://discuss.elastic.co/t/error-on-my-json/176811/2 "2019-04-15T03:20:33Z")

</div>

Hi, I tried with a 6.5 version I don't know which version you run but the code below is not returning error.

```
POST _ingest/pipeline/_simulate
{
  "pipeline": {
    "description": "parsing master produk indexing",
    "processors": [
      {
        "grok": {
          "field": "message",
          "patterns": [
            """%{NUMBER:id_product};"%{DATA:code_product}";"%{DATA:name_product}";"%{DATA:satuan_product}";"%{DATA:merek_vehicle}";"%{DATA:jenis_vehicle}";"%{DATA:merek_product}";"%{DATA:part_number}";%{NUMBER:weight};"%{DATA:unit_weight}"
            """
          ]
        }
      },
      {
        "remove": {
          "field": "message"
        }
      }
    ]
  },
  "docs": [
    {
      "_index": "master_product_info",
      "_type": "message",
      "_id": "AVvJZVQEBr2flFKzrrkr",
      "_score": 1,
      "_source": {
        "message": """ 42305;"FX4PER000501I";"PER DPN F-50 DH-0005-01 48110-87624-01 MITS";"PCS";"DAIHATSU";"";"INDOSPRING";"";0;""
        """
      }
    }
  ]
}

```

I added a blank line at the end of the content with """ otherwise kibana dev tools return error. Look like you can't have more than 3 following on the same line without kibana raise a syntar error.  
I also added 0 for the weight.

Can you check with your version?

EDIT\>\>\>  
Forget to put the returned result

```
{
  "docs" : [
    {
      "doc" : {
        "_index" : "master_product_info",
        "_type" : "message",
        "_id" : "AVvJZVQEBr2flFKzrrkr",
        "_source" : {
          "name_product" : "PER DPN F-50 DH-0005-01 48110-87624-01 MITS",
          "jenis_vehicle" : "",
          "satuan_product" : "PCS",
          "weight" : "0",
          "id_product" : "42305",
          "merek_vehicle" : "DAIHATSU",
          "code_product" : "FX4PER000501I",
          "merek_product" : "INDOSPRING",
          "part_number" : "",
          "unit_weight" : ""
        },
        "_ingest" : {
          "timestamp" : "2019-04-15T03:20:58.893Z"
        }
      }
    }
  ]
}
```

---

<div class="post-metadata">

**Author:** ![Ridwan\_Syarifudin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ridwan_syarifudin/32/44111_2.png) [@Ridwan\_Syarifudin](https://discuss.elastic.co/u/Ridwan_Syarifudin)\
**Post date:** [April 15, 2019, 3:40am UTC](https://discuss.elastic.co/t/error-on-my-json/176811/3 "2019-04-15T03:40:44Z")

</div>

thank you so much sir for your help, let me try your answer

---

<div class="post-metadata">

**Author:** ![Ridwan\_Syarifudin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ridwan_syarifudin/32/44111_2.png) [@Ridwan\_Syarifudin](https://discuss.elastic.co/u/Ridwan_Syarifudin)\
**Post date:** [April 15, 2019, 3:47am UTC](https://discuss.elastic.co/t/error-on-my-json/176811/4 "2019-04-15T03:47:49Z")

</div>

sir can i ask you one question?

```
PUT _template/product_template

```

{  
"index\_patterns": ["master\_product\*"],  
"settings": {  
"number\_of\_shards": 1  
},  
"mappings": {  
"message": {  
"properties": {  
"id\_product": {  
"type": "keyword"  
},  
"code\_product": {  
"type": "keyword"  
},  
"satuan\_product": {  
"type": "text"  
},  
"merek\_vehicle": {  
"type": "text"  
},  
"jenis\_vehicle": {  
"type": "text"  
},  
"merek\_product": {  
"type": "text"  
},  
"part\_number": {  
"type": "text"  
},  
"weight": {  
"type": "float"  
},  
"unit\_weight": {  
"type": "text"  
}  
}  
}  
}  
}

do you think my indexing document is correct?

---

<div class="post-metadata">

**Author:** ![gabriel\_tessier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabriel_tessier/32/27911_2.png) [@gabriel\_tessier](https://discuss.elastic.co/u/gabriel_tessier)\
**Post date:** [April 15, 2019, 4:01am UTC](https://discuss.elastic.co/t/error-on-my-json/176811/5 "2019-04-15T04:01:27Z")

</div>

According to your example document "id\_product": is integer so better to use int (or better depends on the size you expect to have) instead of keyword.

More about numeric datatype in doc:  
[https://www.elastic.co/guide/en/elasticsearch/reference/current/number.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/number.html)

Also for the text fields I think it's better to use multi-fields

```
"merek_vehicle": {
"type": "text",
"fields":{
          "raw":{
              "type": "keyword",
               "ignore_above": 256
          },
}....

```

it will allow you to use the field in aggregations.

More about multi-fields in the doc: [https://www.elastic.co/guide/en/elasticsearch/reference/current/multi-fields.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/multi-fields.html)

Hope it help.

---

<div class="post-metadata">

**Author:** ![Ridwan\_Syarifudin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ridwan_syarifudin/32/44111_2.png) [@Ridwan\_Syarifudin](https://discuss.elastic.co/u/Ridwan_Syarifudin)\
**Post date:** [April 15, 2019, 4:02am UTC](https://discuss.elastic.co/t/error-on-my-json/176811/6 "2019-04-15T04:02:11Z")

</div>

thank you so much sir

---

<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:** [May 13, 2019, 4:02am UTC](https://discuss.elastic.co/t/error-on-my-json/176811/7 "2019-05-13T04:02:13Z")

</div>

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