Long time fan first time poster, love the project fantastic piece of kit.
I've run into a problem that I can't get past despite dredging through the forums.
I'm trying to put data from multiple sql tables into firebase, the majority of the process is fine but I'm trying to get clever with the Primary Key. I get an array of data from the table and format it to firebases liking.
I need to set whatever the primary key field (ID) is to the topic.
My problem is the name of the Primary key changes depending on the table i'm querying, I can get what each one is called. Where i'm stuck is trying to use the change node and JSONata to do it.
I can't figure out how to use the primary key name to build the path. it comes in as msg.id (for example) now I would expect if I put the following it would work.
However I'm actually returned the value of msg.id not msg.payload.id
This is the Array I'm using
How I want the data (ID specified directly not using variable)
Any help would be greatly appreciated!