@ChuckE ,   You can use a JoltTransformRecord processor to perform the conversion to JSON and, at the same time, add the root node back to it.   The JOLT specification I used is this: { "*": "a.&" }   Cheers, André     ... View more

@SandyClouds ,   You don't need a MySQL replication server. What I meant is that the CaptureChangeMySQL act as a replication client, and needs the same privileges as one.   I tested the exact same commands that you specified above and I was able to connect to the database from the command line: [root@cdp ~]# mysql -u replication -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 Server version: 8.0.26 Source distribution Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>   I was also able to configure the CaptureChangeMySQL processor to capture changes without any other privileges being granted:   Which version of MySQL are you using? There seems to be some issue with your user creation. The connection from the command line should work. What was the command you used to connect to the db using the replication user?   Could you please provide the configuration of your processor?   Cheers, André   ... View more

@Brenigan ,   1. It depends on the context and the level of &n. In the example above, &1 return the element in the transports array (e.g. "PUSH"), while &2 returns the numeric index of that element in the array (e.g. 0).   2. &4 and &2 are numeric array indexes. outer[&4] means that the output will be in the &4 position of an array called outer. That element of the array will have and attribute called inner and the &2 position of the inner array will have two attributes, t and etc, with the specified values.   Cheers, André ... View more