Kibana display difficulty


#1

Hello I am new on elasticsearch and I need advice.

I get a json via an API that I store in mongodb then I extract it and insert it into elastisearch when I try to visualize my data in kibana I see this result. How can I fix this problem?

thank you in advance


(David Pilato) #2

Can you run in Kibana DEV Console:

GET /test_sncf_streaming/_search?size=1

And share the result here. Formatted please.

By the way, judging by the name of your index you might be interested of asking your questions in #in-your-native-tongue:discussions-en-francais :slight_smile:


#3

thank you for your answer, here is the result of the request and yes I am French but I usually publish in English to have the most answer possible.

Blockquote {
"took":1,
"timed_out":false,
"_shards":{
"total":5,
"successful":5,
"skipped":0,
"failed":0
},
"hits":{
"total":52,
"max_score":1.0,
"hits":[
{
"_index":"test_sncf_streaming",
"_type":"histo_disruptions",
"_id":"Pk4IFGgBxV7Cn2u2vqKm",
"_score":1.0,
"_source":{
"disruption":{
"status":"active",
"disruption_id":"e988b3c6-2b11-42ca-aa70-be1ae636992c",
"severity":{
"color":"#000000",
"priority":42,
"name":"trip delayed",
"effect":"SIGNIFICANT_DELAYS"
},
"impact_id":"e988b3c6-2b11-42ca-aa70-be1ae636992c",
"application_periods":[
{
"begin":"20181115T161200",
"end":"20181115T233359"
}
],
"messages":[
{
"text":"Régulation du trafic",
"channel":{
"types":[
"web",
"mobile"
],
"id":"rt",
"content_type":"",
"name":"rt"
}
}
],
"updated_at":"20181115T180147",
"uri":"e988b3c6-2b11-42ca-aa70-be1ae636992c",
"impacted_objects":[
{
"impacted_stops":[
{
"amended_arrival_time":"212500",
"stop_point":{
"name":"Colmar",
"links":[

                             ],
                             "coord":{  
                                "lat":"48.073137",
                                "lon":"7.347065"
                             },
                             "label":"Colmar (Colmar)",
                             "equipments":[  

                             ],
                             "fare_zone":{  
                                "name":"0"
                             },
                             "id":"stop_point:OCE:SP:TGV-87182014"
                          },
                          "stop_time_effect":"unchanged",
                          "departure_status":"unchanged",
                          "amended_departure_time":"212800",
                          "base_arrival_time":"212500",
                          "cause":"Régulation du trafic",
                          "base_departure_time":"212800",
                          "arrival_status":"unchanged"
                       },
                       {  
                          "amended_arrival_time":"233400",
                          "stop_point":{  
                             "name":"Luxembourg",
                             "links":[  

                             ],
                             "coord":{  
                                "lat":"49.59962",
                                "lon":"6.134022"
                             },
                             "label":"Luxembourg (Luxembourg)",
                             "equipments":[  

                             ],
                             "fare_zone":{  
                                "name":"0"
                             },
                             "id":"stop_point:OCE:SP:TGV-82001000"
                          },
                          "stop_time_effect":"unchanged",
                          "departure_status":"unchanged",
                          "amended_departure_time":"233400",
                          "base_arrival_time":"233400",
                          "cause":"Régulation du trafic",
                          "base_departure_time":"233400",
                          "arrival_status":"unchanged"
                       }
                    ],
                    "pt_object":{  
                       "embedded_type":"trip",
                       "id":"OCE:SN009898F02052",
                       "quality":0,
                       "trip":{  
                          "id":"OCE:SN009898F02052",
                          "name":"9898"
                       },
                       "name":"OCE:SN009898F02052"
                    }
                 }
              ],
              "id":"e988b3c6-2b11-42ca-aa70-be1ae636992c",
              "contributor":"realtime.cots",
              "cause":"",
              "disruption_uri":"e988b3c6-2b11-42ca-aa70-be1ae636992c"
           },
           "request_datetime":"181115T221920",
           "id":"5bede2ddb63ce5e7a21b052a"
        }
     }
  ]

}
}


(David Pilato) #4

Please format your code, logs or configuration files using </> icon as explained in this guide and not the citation button. It will make your post more readable.

Or use markdown style like:

```
CODE
```

This is the icon to use if you are not using markdown format:

There's a live preview panel for exactly this reasons.

Lots of people read these forums, and many of them will simply skip over a post that is difficult to read, because it's just too large an investment of their time to try and follow a wall of badly formatted text.
If your goal is to get an answer to your questions, it's in your interest to make it as easy to read and understand as possible.
Please update your post.

Is impacted_objects a nested type?
I'm not sure anyway you can do anything about how it is being displayed in Kibana as it's an array of objects.


(system) closed #5

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