davyam commented on pull request #4065:
URL: https://github.com/apache/nifi/pull/4065#issuecomment-671348801
> > With the replacement from JSON Simple to Jackson, the output (content)
changed too.
> > Example:
> > ```
> > {
> > "tupleData" : {
> > "codigo" : 4,
> > "nome" : "CDC",
> > "data_fund" : "1929-10-19"
> > },
> > "relationName" : "public.cidade",
> > "type" : "insert"
> > }
> > ```
>
> @davyam could you please possibly explain how to use Jackson JSON format
for a CDC event? Or maybe it is documented somewhere.
>
> Thanks!
> > With the replacement from JSON Simple to Jackson, the output (content)
changed too.
> > Example:
> > ```
> > {
> > "tupleData" : {
> > "codigo" : 4,
> > "nome" : "CDC",
> > "data_fund" : "1929-10-19"
> > },
> > "relationName" : "public.cidade",
> > "type" : "insert"
> > }
> > ```
>
> @davyam could you please possibly explain how to use Jackson JSON format
for a CDC event? Or maybe it is documented somewhere.
>
> Thanks!
@energy2522 if I understood your question, you are asking for more detail
about the CDC event that is returned in flowfile content in JSON type.
So, for each row in an event (INSERT, UPDATE, DELETE) we have a JSON in this
format:
{
"tupleData" : { _JSON object with all the fields and their values_ },
"relationName" : _Table's name_,
"type" : _Event type (INSERT, UPDATE, DELTE, BEGIN*, COMMIT*)_
}
*BEGIN and COMMIT events are included if the "Include Begin/Commit Events"
property are checked.
More info here: [https://github.com/davyam/pgEasyReplication](url)
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
