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
Best answer by jakemolnar
View original