hello,
we are trying to develop a flow in nifi that loads jsons to dynamodb.
our json looks like this:
{
"hash_field": "hash_value",
"field2": "value2",
"field3": "value3"
}
</p><p>
We are using putDynamDB processor. </p><p>
Field one is the hash key. We tried to specify a json path to the hash key('$.field1') at the putDynamDB's attribute '<strong style="background-color: initial;">Hash Key Value' </strong>but it failed, so we add an attribute that contains the hash key value and removed the hash key from the original json, so now it looks like this:</p><pre> {
"field2": "value2",
"field3": "value3"
}
We understood that in the putDynamDB's attribute 'Json Document attribute' we need to specify the json path we want to load, which means that if we want to load the whole json we need to insert '$'. But somehow $ loads the data like this:
{ "field2" : { "S" : "value2" }, "field3" : { "S" : "value3" } }we tried changing it to '$.', '$.*','.' and nothing loads the data right.
What are we doing wrong?
Thanks for the help
@gal626262