# Limit of total fields Error, Correct structure of .Json-File?

**URL:** <https://discuss.elastic.co/t/limit-of-total-fields-error-correct-structure-of-json-file/119994>\
**Category:** Elasticsearch\
**Created:** [February 15, 2018, 1:44pm UTC](https://discuss.elastic.co/t/limit-of-total-fields-error-correct-structure-of-json-file/119994 "2018-02-15T13:44:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![KingPapst](https://avatars.discourse-cdn.com/v4/letter/k/898d66/32.png) [@KingPapst](https://discuss.elastic.co/u/KingPapst)\
**Post date:** [February 15, 2018, 1:44pm UTC](https://discuss.elastic.co/t/limit-of-total-fields-error-correct-structure-of-json-file/119994/1 "2018-02-15T13:44:22Z")

</div>

Hello,

im new to Elasticsearch.

I got .json -Files from scraping a finances page.

They can look like this:

```
{
    "1. Information": "Daily Prices (open, high, low, close) and Volumes", 
    "2. Symbol": "MMM", 
    "3. Last Refreshed": "2018-01-10", 
    "4. Output Size": "Full size", 
    "5. Time Zone": "US/Eastern"
}{
    "2000-01-03": {
        "1. open": "96.0600", 
        "2. high": "96.4400", 
        "3. low": "94.0600", 
        "4. close": "94.3800", 
        "5. volume": "1086700"
    }, 
    "2000-01-04": {
        "1. open": "92.8800", 
        "2. high": "94.8100", 
        "3. low": "90.6300", 
        "4. close": "90.6300", 
        "5. volume": "1356900"
    }, 
    "2000-01-05": {
        "1. open": "91.1300", 
        "2. high": "95.3100", 
        "3. low": "91.1300", 
        "4. close": "95.2500", 
        "5. volume": "1849700"
    }, ....

```

or like this:

```
{
    "2000-01-03": {
        "1. open": "96.0600", 
        "2. high": "96.4400", 
        "3. low": "94.0600", 
        "4. close": "94.3800", 
        "5. volume": "1086700"
    }, 
    "2000-01-04": {
        "1. open": "92.8800", 
        "2. high": "94.8100", 
        "3. low": "90.6300", 
        "4. close": "90.6300", 
        "5. volume": "1356900"
    }, 
    "2000-01-05": {
        "1. open": "91.1300", 
        "2. high": "95.3100", 
        "3. low": "91.1300", 
        "4. close": "95.2500", 
        "5. volume": "1849700"
    },...

```

I used a mapping like this:

```
{
 "mappings": {
  "doc": {
   "properties": {
      "open": {"type": "double"},
      "high": {"type": "double"},
      "low": {"type": "double"},
      "close": {"type": "double"},
      "volume": {"type": "double"}
     }
    }
   }
  }

```

and then tried to upload the .json -File with this command:

`curl -XPOST 'http://localhost:9200/index/doc' -H 'Content-Type: application/json' -d @test.json`

but i got an Error:

```
{"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"Limit of total fields [1000] in index [index] has been exceeded"}], "type":"illegal_argument_exception","reason":"Limit of total fields [1000] in index [index] has been exceeded"},"status":400}

```

My aim is to upload every share of a Company and to reproduce the graph with Kibana.

How can I increase the "Limit of total fields"?  
And the 2nd thing is im not sure about the structure in the .json-Files. Is it even possible to do this with these .json-Files?

Im thankful for every help. 🙂

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [February 15, 2018, 4:23pm UTC](https://discuss.elastic.co/t/limit-of-total-fields-error-correct-structure-of-json-file/119994/2 "2018-02-15T16:23:41Z")

</div>

Change your model and index each share quotation instead (with its timestamp).

---

<div class="post-metadata">

**Author:** ![KingPapst](https://avatars.discourse-cdn.com/v4/letter/k/898d66/32.png) [@KingPapst](https://discuss.elastic.co/u/KingPapst)\
**Post date:** [February 15, 2018, 5:46pm UTC](https://discuss.elastic.co/t/limit-of-total-fields-error-correct-structure-of-json-file/119994/3 "2018-02-15T17:46:54Z")

</div>

Could u show me a short example how the json-File should look Like?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [February 15, 2018, 6:12pm UTC](https://discuss.elastic.co/t/limit-of-total-fields-error-correct-structure-of-json-file/119994/4 "2018-02-15T18:12:01Z")

</div>

Probably something like:

```auto
{
  "date": "2000-01-03",
  "Symbol": "MMM",
  "open": 96.0600, 
  "high": 96.4400, 
  "low": 94.0600, 
  "close": 94.3800, 
  "volume": 1086700
}

```

---

<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 15, 2018, 6:12pm UTC](https://discuss.elastic.co/t/limit-of-total-fields-error-correct-structure-of-json-file/119994/5 "2018-03-15T18:12:34Z")

</div>

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