Insight JSON import - How do you refer to the body / header of the JSON in the Selector field

[Alexandru Dumitru]

Hi,

I'm struggling with the JSON import to Insight as the JSON I'm working with doesn't have an array for the header (the top level of the JSON). It looks something like this:

{
"attribute1" : "value1",
"attribute2" : "value2",
"attribute3" : "value3",
"attribute4" : "value4",
"attribute5" : {
 "attribute6" : "value6",
 "attribute7" : "value7",
 "attribute8" : "value8" }
}

 Well, the JSON import forces me to include a value in the Selector field, as the field is mandatory.

In the case of the JSON above, a valid selector would be "attribute5", which would allow me to get the values for attributes 6, 7 and 8. But not the values of attributes 1,2, 3 or 4.

So, what is the way of referring in the Selector field of the header (top level of the JSON) so that the importer allows to get the entirety of the JSON in this case?

[Björn Gullander]

Hi,

You are required to have an array in the JSON file. Otherwise the import is quite useless :)

If you don't have a selector name for the first level in the JSON file you can set a dot (.) in the Selector field of the mapping configuration.

Björn