Grab data from JSON and format correct (and send to influxDB)

[Fux2]

Hi,
is it possible, to grab the "Temperature" and "Humidity" of the following JSON String?

{"Time":"2021-01-16T21:44:19","HTU21":{"Temperature":3.2,"Humidity":35.4,"DewPoint":-10.7},"TempUnit":"C"}

It should be forwarded to an influxDB:

[tele/sonoff4ch/SENSOR]
topic = tele/sonoff4ch/SENSOR
targets = log:info, influxdb:garageHumidity
format = value={Humidity}   # how to format correctly ?

Another issue is, that I can not use the topic a second time, to get humidity and temperature separately.

[tele/sonoff4ch/SENSOR]
topic = tele/sonoff4ch/SENSOR
targets = log:info, influxdb:garageTemp
format = value={Temperature}
    ...
configparser.DuplicateSectionError: While reading from 'mqttwarn.ini' [line 211]: section 'tele/sonoff4ch/SENSOR' already exists

So both values have to be transfered at once - is this possible?

Thanks for your help!

[jpmens]

Please see transforming in the handbook.

[Fux2]

Ok, I got it by help of this issue: #294
Here my solution as example:

#mqttwarn.ini
   ...
[garageTemp]
topic = tele/sonoff4ch/SENSOR
targets = log:info, influxdb:garageTemp
alldata = getJsonNestedTemp()
format = {Temperature}

[garageHumi]
topic = tele/sonoff4ch/SENSOR
targets = log:info, influxdb:garageHumi
alldata = getJsonNestedHumidity()
format = {Humidity}

#samplefuncs.py
   ...
import ast
   ...
def getJsonNestedHumidity(topic, data, srv=None):
    payload = ast.literal_eval(data["payload"])
    humi = payload["HTU21"]["Humidity"]
    d = dict( Topic = topic, Humidity = humi )
    return d

def getJsonNestedTemp(topic, data, srv=None):
    payload = ast.literal_eval(data["payload"])
    temp = payload["HTU21"]["Temperature"]
    d = dict( Topic = topic, Temperature = temp )
    return d