JsonParseException while importing JSON to elasticsearch

Question

I am trying to import some json data into my elasticsearch instance and getting the following error:

{
  "error" : "JsonParseException[Unexpected end-of-input: expected close marker for ARRAY (from [Source: [B@7110db07; line: 1, column: 0])\n at [Source: [B@7110db07; line: 1, column: 3]]",
  "status" : 500
}

I am using an Ubuntu (14.04) running on VirtualBox and this is the command I used to import the data:

url -XPOST 'localhost:9200/mydata/fields/_bulk?pretty' --data-binary @mydata.json

And here is my JSON sample:

[
  {
    "field1":"sometext",
    "field2":"O",
    "field3":"TEXT",
    "field4":"CR",
    "field5":"09:38.0",
    "field6":"09:38.0",
    "field7":"14:13.0",
    "field8":"NULL",
    "field9":"NULL",
    "field10":"0",
    "field11":"5",
    "field12":"NULL",
    "field13":"NULL",
    "field14":"4",
    "field15":"0"
  },
  {
    "field1":"othertext",
    "field2":"O",
    "field3":"TEXT",
    "field4":"CR",
    "field5":"09:38.0",
    "field6":"09:38.0",
    "field7":"14:13.0",
    "field8":"NULL",
    "field9":"NULL",
    "field10":"0",
    "field11":"5",
    "field12":"NULL",
    "field13":"NULL",
    "field14":"4",
    "field15":"0"
  },
]

Is is possible to import a JSON array using the bulk API?

Corrected json format is like so: {"index":{"_index":"mydata","_type":"data","_id":0}} {"field1":"someText","field2":"O","field3":"TEXT","field4":"CR","field5":"09:38.0","field6":"09:38.0","field7":"14:13.0","field8":"NULL","field9":"NULL","field10":"0","field11":"5","field12":"NULL","field13":"NULL","field14":"4","field15":"0"} — Nayan
– Nayan, Commented Jul 15, 2014 at 17:40
how did you post multiple records using bulk api? i always get an error? — AbtPst
– AbtPst, Commented Feb 3, 2016 at 18:41

ryudice · Accepted Answer · 2014-07-15 16:59:41Z

4

Your json doesnt have to contain line breaks in the bulk API, since the API uses the line break as a delimiter. From elasticsearch documentation here http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/docs-bulk.html

Because this format uses literal \n's as delimiters, please be sure that the JSON actions and sources are not pretty printed.

answered Jul 15, 2014 at 16:59

ryudice

37.6k33 gold badges122 silver badges164 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JsonParseException while importing JSON to elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related