# How to push json into elasticsearch

**URL:** <https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275>\
**Category:** Elasticsearch\
**Created:** [October 23, 2022, 1:25pm UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275 "2022-10-23T13:25:31Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![ZahraZare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zahrazare/32/112102_2.png) [@ZahraZare](https://discuss.elastic.co/u/ZahraZare)\
**Post date:** [October 23, 2022, 1:25pm UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/1 "2022-10-23T13:25:31Z")

</div>

I want to push the following Json data using Python in elasticsearch, I used the following code but there is no data in the index.  
json data :  
[  
"break",  
false,  
-1314177328.9280925,  
[  
-107585784.0005331,  
1173232087.3724098,  
[  
true,  
-1841424252.6783514,  
true,  
"typical",  
true,  
false  
],  
false,  
1593426885.6051607,  
true  
],  
"parent",  
false  
]

 ![zahra](https://us1.discourse-cdn.com/elastic/original/3X/8/8/88ecc1a61a63358fcc4c3c70b4dc8f666a73ea2c.png)

---

<div class="post-metadata">

**Author:** ![A\_Mightiev](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_mightiev/32/62186_2.png) [@A\_Mightiev](https://discuss.elastic.co/u/A_Mightiev)\
**Post date:** [October 23, 2022, 1:29pm UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/2 "2022-10-23T13:29:25Z")

</div>

If the json is malformed elastic will reject the document, try to use logstash http input plugin with stdout rubydbg to see what you are really sending. check if the json is well structured with an online json checker

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [October 23, 2022, 2:28pm UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/3 "2022-10-23T14:28:22Z")

</div>

There are restrictions in what JSON you can index into Elasticsearch, and what you have posted is not valid in Elasticsearch. The root bust be a well formed JSON object and can not be an array. Elasticsearch is also not schemaless, so once a field has been mapped it can not accept values that are not aligned to this mapping.

---

<div class="post-metadata">

**Author:** ![ZahraZare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zahrazare/32/112102_2.png) [@ZahraZare](https://discuss.elastic.co/u/ZahraZare)\
**Post date:** [October 23, 2022, 6:37pm UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/4 "2022-10-23T18:37:31Z")

</div>

hi @A_Mightiev, Jason data is valid, I checked

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [October 23, 2022, 6:41pm UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/5 "2022-10-23T18:41:48Z")

</div>

It is valid JSON, but not in a form Elasticsearch will accept.

---

<div class="post-metadata">

**Author:** ![ZahraZare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zahrazare/32/112102_2.png) [@ZahraZare](https://discuss.elastic.co/u/ZahraZare)\
**Post date:** [October 23, 2022, 7:22pm UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/7 "2022-10-23T19:22:30Z")

</div>

Can you help me @Christian_Dahlqvist ? I am a beginner and the result of this task is very important to me:(

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [October 23, 2022, 7:31pm UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/8 "2022-10-23T19:31:34Z")

</div>

Have you looked at the Elasticsearch getting started guide and the examples available there?

---

<div class="post-metadata">

**Author:** ![ZahraZare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zahrazare/32/112102_2.png) [@ZahraZare](https://discuss.elastic.co/u/ZahraZare)\
**Post date:** [October 24, 2022, 5:09am UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/9 "2022-10-24T05:09:59Z")

</div>

no i didn't

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [October 24, 2022, 5:20am UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/10 "2022-10-24T05:20:07Z")

</div>

Then please do so. You will need to learn about how Elasticsearch works if you are going to use it. The [section on mapping](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html) describes how document structure and mapping works, and should explain why your document will not work in Elasticsearch.

---

<div class="post-metadata">

**Author:** ![ZahraZare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zahrazare/32/112102_2.png) [@ZahraZare](https://discuss.elastic.co/u/ZahraZare)\
**Post date:** [October 24, 2022, 5:31am UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/11 "2022-10-24T05:31:16Z")

</div>

I can't find a document that explains what Jsons are accepted by Elasticsearch... I would be grateful if you could send me a link or a document that can help me and improve my situation.

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [October 24, 2022, 5:36am UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/12 "2022-10-24T05:36:03Z")

</div>

I added a link to the documentation on mapping to my earlier response. A document must be an object with at least one field, e.g. `{"field:"value"}`. An array at the highest level is not acceptable.

Furthermore each field must have a single mapping. Although a field can contain an array, all values within the array must be of the same type, so you can e.g. not mix strings, numbers and objects in an array.

This [blog post](https://www.elastic.co/blog/a-practical-introduction-to-elasticsearch) may also be useful, although it is quite old and quite a few things have changed since.

---

<div class="post-metadata">

**Author:** ![ZahraZare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zahrazare/32/112102_2.png) [@ZahraZare](https://discuss.elastic.co/u/ZahraZare)\
**Post date:** [October 24, 2022, 5:41am UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/13 "2022-10-24T05:41:12Z")

</div>

Thank you very much, you helped me a lot. I will definitely read the points you said

---

<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:** [November 21, 2022, 5:41am UTC](https://discuss.elastic.co/t/how-to-push-json-into-elasticsearch/317275/14 "2022-11-21T05:41:33Z")

</div>

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