Length of the body of an object

Elastic Stack Elasticsearch
1

Hello guys,

I have a JSON Object with the following structure:

{
   "_index": ... ,
   ... ,
   "_source": {
      "JobResult": "OK",
      "JobSpecification": {
         "ColorsOfPages": {
            "Page1": {
               "Yellow": 10.1,
               "Black": 9.0,
               "Cyan": 7.3,
               "Magenta": 1.1
            },
           "Page1": {
               "Yellow": 11.3,
               "Black": 10.2,
               "Cyan": 10.6,
               "Magenta": 3.1
            },
            ...
         }
      }
   }
}

Now I want to find out how many pages I have and add the single values.
Can you help me please? :tipping_hand_woman:t2:

Thanks in advance.

2

Hey,

you could use an ingest script processor and check the size of the ColorsOfPages map.

--Alex

3

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