# json insert

**URL:** <https://discuss.elastic.co/t/json-insert/271891>\
**Category:** Elasticsearch\
**Created:** [May 1, 2021, 9:30pm UTC](https://discuss.elastic.co/t/json-insert/271891 "2021-05-01T21:30:22Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![pyeonzzang123](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pyeonzzang123/32/87818_2.png) [@pyeonzzang123](https://discuss.elastic.co/u/pyeonzzang123)\
**Post date:** [May 1, 2021, 9:30pm UTC](https://discuss.elastic.co/t/json-insert/271891/1 "2021-05-01T21:30:22Z")

</div>

I want to write the same c# code as the Python code below.  
But there was an error. I don’t' know the reason.

python

// import json  
import sys

from elasticsearch import Elasticsearch  
from elasticsearch.helpers import bulk

ES\_ENDPOINT = "[http://id:password@ip:9200](http://id:password@ip:9200)"  
es = Elasticsearch(ES\_ENDPOINT, timeout=300, max\_retries=10, retry\_on\_timeout=True)

def gendata():

```
# 파일 open 후 읽어오기?
file = open('me.json')
jsonString = json.load(file)

# key 값 추출
keys = [
    key for key in jsonString
]
print(keys)

# i = 0 # 변수 초기화
x = range(len(keys))

# 키 값에 따른 객체 가져온 후 값 insert
for i in x:

    jsonArray = jsonString.get(keys[i])

    # print(jsonArray)

    for list in jsonArray:
        yield {
            "_index": "jsoninsert3",
            "_source": {
                keys[i] : list
            }
        }

    # print(list)

    i = i + 1

```

bulk(es, gendata())

gendata()

c#

// using System;  
using System.Collections.Generic;  
using [System.IO](http://System.IO);  
using System.Linq;  
using System.Text;  
using System.Threading.Tasks;  
using [Elasticsearch.Net](http://Elasticsearch.Net);  
using Nest;  
using Newtonsoft.Json;  
using Newtonsoft.Json.Linq;  
namespace jsonParsing  
{  
class Program  
{  
public class IotDatabase  
{  
public JToken K { get; set; }  
public JToken V { get; set; }  
public virtual JToken First { get; }  
public static explicit operator JToken(IotDatabase v)  
{  
throw new NotImplementedException();  
}  
}  
static void Main(string args)  
{  
var defaultIndex = "jsoninsert";  
var pool = new SingleNodeConnectionPool(new Uri("[http://id:password@ipAddress:9200](http://id:password@ipAddress:9200)"));  
var settings = new ConnectionSettings(pool)  
.DefaultIndex(defaultIndex);  
var client = new ElasticClient(settings);  
String path = @"C:\me.json";  
JObject obj = JObject.Parse(File.ReadAllText(path));  
IList keys = obj.Properties().Select(p =\> p.Name).ToList();  
// 키 추출  
List key\_list = new List();  
var z = keys.Count();  
List list5 = new List();  
for (var i = 0; i \< z; i++)  
{

```
            Console.WriteLine(keys[i]);
            JToken key_list2 = keys[i];
            JToken key_value_list = obj[keys[i]];
            JToken iotDatabase = (JToken) new IotDatabase { K = (JToken)key_list2, V = (JToken)key_value_list };
            list5.Add(iotDatabase);
        }
        // bulk 삽입
        var bulkAllObservable = client.BulkAll(list5, b => b
            .Index("jsoninsert")
            .BackOffTime("30s") // 재시도 간의 대기시간
            .BackOffRetries(2)
            .Size(100000) // 대량 요청 당 항목?
        )
        .Wait(TimeSpan.FromMinutes(15), next =>
        {
            
        }); 
        Console.ReadLine();
    }
}

```

}

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 2, 2021, 9:48pm UTC](https://discuss.elastic.co/t/json-insert/271891/2 "2021-05-02T21:48:54Z")

</div>

Welcome to our community! 😃

> [@pyeonzzang123](#):
>
> But there was an error

What is the error?

---

<div class="post-metadata">

**Author:** ![pyeonzzang123](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pyeonzzang123/32/87818_2.png) [@pyeonzzang123](https://discuss.elastic.co/u/pyeonzzang123)\
**Post date:** [May 3, 2021, 1:23am UTC](https://discuss.elastic.co/t/json-insert/271891/3 "2021-05-03T01:23:54Z")

</div>

![python으로 했을때](https://us1.discourse-cdn.com/elastic/original/3X/b/8/b864ecbc8554ac53d74a50fb83b7cc76467824f1.png)

![c#으로 했을때_줄바꿈 문자 포함안되게 저장하고싶음.](https://us1.discourse-cdn.com/elastic/original/3X/8/4/84cf64d5953efccb61687ba7771ae97663a3e91e.png)

The first picture is the result of running on Python. The second picture is the result of running with c#. I hope value is saved so that it doesn't include line-switched characters.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 3, 2021, 1:24am UTC](https://discuss.elastic.co/t/json-insert/271891/4 "2021-05-03T01:24:51Z")

</div>

Please don't post pictures of text, they are difficult to read, impossible to search and replicate (if it's code), and some people may not be even able to see them 🙂

---

<div class="post-metadata">

**Author:** ![pyeonzzang123](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pyeonzzang123/32/87818_2.png) [@pyeonzzang123](https://discuss.elastic.co/u/pyeonzzang123)\
**Post date:** [May 3, 2021, 1:27am UTC](https://discuss.elastic.co/t/json-insert/271891/5 "2021-05-03T01:27:47Z")

</div>

I want to solve this problem. If you don't mind, I will send my code to your email address, so can you check it?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 3, 2021, 1:33am UTC](https://discuss.elastic.co/t/json-insert/271891/6 "2021-05-03T01:33:49Z")

</div>

Sorry, I don't answer technical questions via email.  
Feel free to put things on gist/pastebin/etc and link here.

---

<div class="post-metadata">

**Author:** ![pyeonzzang123](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pyeonzzang123/32/87818_2.png) [@pyeonzzang123](https://discuss.elastic.co/u/pyeonzzang123)\
**Post date:** [May 3, 2021, 1:35am UTC](https://discuss.elastic.co/t/json-insert/271891/7 "2021-05-03T01:35:12Z")

</div>

> [@How to insert json data into elasticsearch](https://discuss.elastic.co/t/how-to-insert-json-data-into-elasticsearch/271921):
>
> I want to write the same c# code as the Python code below. But there was an error. I don’t' know the reason. python ''' import json import time from elasticsearch import Elasticsearch from elasticsearch.helpers import bulk ES\_ENDPOINT = "http://id:password@ip주소:9200" es = Elasticsearch(ES\_ENDPOINT, timeout=300, max\_retries=10, retry\_on\_timeout=True) def gendata(): file = open('me.json') jsonString = json.load(file) keys = [key for key in jsonString] print…

I uploaded a new post, could you check it?  
I am not good at English, so writing can be awkward.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 3, 2021, 1:36am UTC](https://discuss.elastic.co/t/json-insert/271891/8 "2021-05-03T01:36:26Z")

</div>

> [@pyeonzzang123](#):
>
> I am not good at English, so writing can be awkward.

Feel free to use our language specific categories - [Elastic In Your Native Tongue - Discuss the Elastic Stack](https://discuss.elastic.co/c/in-your-native-tongue/11)

---

<div class="post-metadata">

**Author:** ![pyeonzzang123](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pyeonzzang123/32/87818_2.png) [@pyeonzzang123](https://discuss.elastic.co/u/pyeonzzang123)\
**Post date:** [May 3, 2021, 1:45am UTC](https://discuss.elastic.co/t/json-insert/271891/9 "2021-05-03T01:45:26Z")

</div>

thank you very much

---

<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 31, 2021, 1:46am UTC](https://discuss.elastic.co/t/json-insert/271891/10 "2021-05-31T01:46:09Z")

</div>

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