Hi,
I would like to write to elasticsearch, not from a table but from some JSON instead. I have prepared the JSON before hand because it has to be nested.
The output format is like so:
{ "mappings": {
"storymap": {
"properties": {
"storyname": {
"type": "text"
},
"storyid": {
"type": "integer"
},
"storyjson": {
"type": "text"
},
"categoryname": {
"type": "text"
},
"subcategoryname": {
"type": "text"
},
"regions": {
"type": "nested",
"properties": {
"region_id": {
"type": "integer"
}
}
}
}
}
}
}
I have managed to get this output format using the JSONTemplater - thanks to @petrahammoser
your post was helpful.
But now I want to pass the JSON to an index in elasticsearch which is already created.
I have tried but I am at a loss, the JSON doesn't seem to populate and I just get an empty index. Some example excel source files and workbench is attached.
If you can offer any help that would be fantastic.
Many Thanks,
Oliver
