Created 09-04-2018 03:23 PM
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
Created 11-13-2021 07:47 AM
Were you able to solve this?
Created 11-15-2021 01:06 AM
@jacektrocinski, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.
Regards,
Vidya Sargur,