How to use bind variables - 2 scenario's

[lucbaert]

Hi, I am a novice node-red user. I have a simple flow:

where I read MQTT input and store it in an Oracle Autonomous Data Warehouse.

I managed to find out that the incoming payload with as output property "parsed json object" can be used in the oracledb node in bind variables like this:

This is the payload (type object): {"read_at":"2024-08-06T14:16:25+02:00","delivered":"6883.212","currently_delivered":"0.000"}
Query:

And using this field mapping:

Where can I find that the bind variables in my query have to be :valueOfValuesArrayIndex0; :valueOfValuesArrayIndex1,…?

I have a second flow where the input is just a string value (e.g. 2.84) , I tried to do the same thing there but I never get the value in my table.
Query is :

INSERT INTO energymonitor.dsmr_peak_running_month
  ( reading_timestamp ,
    peak_kw )
    VALUES (
        current_date,
        :valueOfValuesArrayIndex0
    )

I tried to put in the mapping :

[
    "payload"
]

Or

[
    "msg.payload"
]

But no luck.

In the end I added a string at the beginning and end of my message string to convert it into a dummy json format {"running_month":"2.84"} and then I can use field mapping

[
    "running_month"
]

Is there a better way to achieve this?

Thanks,
Luc