MQTT string to value

[niejan]

Hello all, best wishes in new year.

I have simple questions

Q1 - is there any way how to force Json A to accept string

Q2 - is there any way how to force Json A to convert published value as a string and covert it into number?

Description of my problem

I have JSON that looks like that

{
"main":
{
"value": "868.9640",
"raw": "00868.9640",
"pre": "868.9640",
"error": "no error",
"rate": "0.000060",
"timestamp": "2024-12-18T18:27:05+0100"
}

}

And i want to receive the tag VALUE. But its represented as a string. And there is no string point in CSE 2022 (23 update 85.8650) and analog point is not accepting that format. While HomeAssistant has no problem with that (but i am not using that).

My Mqtt broker is Mosquitto as i found big help in one of Steve's videos on youtube.

When i used Mqtt browser and force to pretend that he received the JSON in this format

{
"main":
{
"value": 868.9640,
"raw": "00868.9640",
"pre": "868.9640",
"error": "no error",
"rate": "0.000060",
"timestamp": "2024-12-18T18:27:05+0100"
}

}

I can get the value into analog point easily.

[sbeadle · Accepted solution]

Sorry, no. But the new Text/JSON driver in Geo SCADA 2023 might do it?

[niejan]

Ok, i'll give a try

EDIT:

yes the new driver helped and work with strings. Now i can easily convert the string into value. Thank you Mr Steve.