Fronius inverter JSON integration

[Firechief]

When I try JSON call http://fronius/solar_api/v1/GetMeterReal...ope=System via URL I get this response:

Code:

{
   "Body" : {
      "Data" : {
         "0" : {
            "Current_AC_Phase_1" : 3.9950000000000001,
            "Current_AC_Phase_2" : -1.4910000000000001,
            "Current_AC_Phase_3" : 0.82499999999999996,
            "Current_AC_Sum" : 3.3289999999999997,
            "Details" : {
               "Manufacturer" : "Fronius",
               "Model" : "Smart Meter TS 65A-3",
               "Serial" : "1987314142"
            },
            "Enable" : 1,
            "EnergyReactive_VArAC_Sum_Consumed" : 1143,
            "EnergyReactive_VArAC_Sum_Produced" : 608719,
            "EnergyReal_WAC_Minus_Absolute" : 176372,
            "EnergyReal_WAC_Plus_Absolute" : 597616,
            "EnergyReal_WAC_Sum_Consumed" : 597616,
            "EnergyReal_WAC_Sum_Produced" : 176372,
            "Frequency_Phase_Average" : 49.899999999999999,
            "Meter_Location_Current" : 0,
            "PowerApparent_S_Phase_1" : 938,
            "PowerApparent_S_Phase_2" : 295.5,
            "PowerApparent_S_Phase_3" : 148.09999999999999,
            "PowerApparent_S_Sum" : 1381.7,
            "PowerFactor_Phase_1" : 0.94499999999999995,
            "PowerFactor_Phase_2" : -0.61099999999999999,
            "PowerFactor_Phase_3" : 0.75700000000000001,
            "PowerFactor_Sum" : 0.78900000000000003,
            "PowerReactive_Q_Phase_1" : -306.5,
            "PowerReactive_Q_Phase_2" : -234,
            "PowerReactive_Q_Phase_3" : -96.700000000000003,
            "PowerReactive_Q_Sum" : -637.39999999999998,
            "PowerReal_P_Phase_1" : 886.5,
            "PowerReal_P_Phase_2" : -180.40000000000001,
            "PowerReal_P_Phase_3" : 112.09999999999999,
            "PowerReal_P_Sum" : 818.20000000000005,
            "TimeStamp" : 1619105985,
            "Visible" : 1,
            "Voltage_AC_PhaseToPhase_12" : 410.60000000000002,
            "Voltage_AC_PhaseToPhase_23" : 415.10000000000002,
            "Voltage_AC_PhaseToPhase_31" : 411.5,
            "Voltage_AC_Phase_1" : 237.40000000000001,
            "Voltage_AC_Phase_2" : 239.19999999999999,
            "Voltage_AC_Phase_3" : 237.80000000000001
         }
      }
   },
   "Head" : {
      "RequestArguments" : {
         "DeviceClass" : "Meter",
         "Scope" : "System"
      },
      "Status" : {
         "Code" : 0,
         "Reason" : "",
         "UserMessage" : ""
      },
      "Timestamp" : "2021-04-22T17:39:46+02:00"
   }

Maybe this helps

[admin]

If you can read JSON via HTTP requests then you can use it instead of Modbus.

[Firechief]

Daniel stated it is better to do this with a ModBus Profile, thats why I continued with this.

[admin]

What Daniel meant is that a profile should be used instead of a Modbus TCP script. If your device provides another way of supplying data then it can be used instead of Modbus.

[Firechief]

Can you give me an example of how to do this?

[admin]

What is the URL for JSON data from the meter?

[Firechief]

I think you mean these:

I found these on GitHub

http://fronius/solar_api/v1/GetActiveDev...ass=System
http://fronius/solar_api/v1/GetInverterInfo.cgi
http://fronius/solar_api/v1/GetInverterR...ope=System
http://fronius/solar_api/v1/GetLoggerInfo.cgi
http://fronius/solar_api/v1/GetLoggerLEDInfo.cgi
http://fronius/solar_api/v1/GetMeterReal...ope=System
http://fronius/solar_api/v1/GetPowerFlow...eData.fcgi
http://fronius/solar_api/v1/GetStorageRe...ope=System
http://fronius/solar_api/v1/GetArchiveDa...rterErrors
http://fronius/solar_api/v1/GetArchiveDa...s_Absolute

[admin]

Try this script, adjust URL and group addresses as needed. You can add extra checkupdate calls as needed.

Code:

http = require('socket.http')
json = require('json')

url = 'http://fronius/solar_api/v1/GetMeterRealtimeData.cgi?Scope=System'

resp = http.request(url)
data = json.decode(resp).Body.Data['0']

grp.checkupdate('1/1/1', data.Current_AC_Sum)
grp.checkupdate('1/1/2', data.Current_AC_Phase_1)
grp.checkupdate('1/1/3', data.Voltage_AC_Phase_1)

[Firechief]

I copied and modified script and created resident script with 5s interval. Modified group addresses to the correct ones and activated the script, but i don't see any updates of the group addresses. No Error logs, Logs or Alerts

Code:

http = require('socket.http')
json = require('json')

url = 'http://192.168.100.189/solar_api/v1/GetMeterRealtimeData.cgi?Scope=System'

resp = http.request(url)
data = json.decode(resp).Body.Data['0']

grp.checkupdate('33/0/1', data.Current_AC_Sum)
grp.checkupdate('33/0/2', data.Current_AC_Phase_1)
grp.checkupdate('33/0/3', data.Current_AC_Phase_2)
grp.checkupdate('33/0/4', data.Current_AC_Phase_3)
grp.checkupdate('33/0/5', data.Voltage_AC_PhaseToPhase_12)
grp.checkupdate('33/0/6', data.Voltage_AC_PhaseToPhase_23)
grp.checkupdate('33/0/7', data.Voltage_AC_PhaseToPhase_31)
grp.checkupdate('33/0/8', data.Voltage_AC_Phase_1)
grp.checkupdate('33/0/9', data.Voltage_AC_Phase_2)
grp.checkupdate('33/0/10', data.Voltage_AC_Phase_3)

[Daniel]

This is sent only on change of value

[admin]

Add some extra logging and post what you get in Logs tab:

Code:

http = require('socket.http')
json = require('json')

url = 'http://192.168.100.189/solar_api/v1/GetMeterRealtimeData.cgi?Scope=System'

resp, code = http.request(url)
log(resp, code)
data = json.decode(resp).Body.Data['0']
log(data)

grp.checkupdate('33/0/1', data.Current_AC_Sum)
grp.checkupdate('33/0/2', data.Current_AC_Phase_1)
grp.checkupdate('33/0/3', data.Current_AC_Phase_2)
grp.checkupdate('33/0/4', data.Current_AC_Phase_3)
grp.checkupdate('33/0/5', data.Voltage_AC_PhaseToPhase_12)
grp.checkupdate('33/0/6', data.Voltage_AC_PhaseToPhase_23)
grp.checkupdate('33/0/7', data.Voltage_AC_PhaseToPhase_31)
grp.checkupdate('33/0/8', data.Voltage_AC_Phase_1)
grp.checkupdate('33/0/9', data.Voltage_AC_Phase_2)
grp.checkupdate('33/0/10', data.Voltage_AC_Phase_3)

[Firechief]

These values should change all the time as it's solar production and energy consumption.
What I want to monitor is real time (5-10s interval) data coming from the inverter and Smart Energy Meter so I can make a dashboard on the visu and maybe in the future actions depending on production or consumption.

---

this is the log:

Code:

Wiser for KNXLogoutStart pageLanguage:
English
1
Version: 2.5.1






CPU/IO: 0.12 0.06 0.08, Memory: 21%, KNX/TP: OK

* table:
["Current_AC_Phase_1"]
  * number: 1.312
["PowerReal_P_Phase_1"]
  * number: 190.8
["PowerFactor_Phase_1"]
  * number: 0.796
["PowerReal_P_Sum"]
  * number: -53.6
["Current_AC_Sum"]
  * number: 0.434
["PowerFactor_Phase_3"]
  * number: 0.328
["PowerReal_P_Phase_2"]
  * number: -283.6
["PowerReactive_Q_Phase_3"]
  * number: -112.7
["EnergyReactive_VArAC_Sum_Produced"]
  * number: 614904
["Current_AC_Phase_2"]
  * number: -1.412
["PowerApparent_S_Sum"]
  * number: 654.4
["TimeStamp"]
  * number: 1619170026
["Voltage_AC_PhaseToPhase_23"]
  * number: 416.4
["EnergyReal_WAC_Sum_Produced"]
  * number: 176646
["PowerFactor_Phase_2"]
  * number: -0.961
["Current_AC_Phase_3"]
  * number: 0.534
["PowerFactor_Sum"]
  * number: -0.156
["PowerReactive_Q_Phase_2"]
  * number: -81.9
["Voltage_AC_Phase_2"]
  * number: 240.5
["EnergyReal_WAC_Minus_Absolute"]
  * number: 176646
["Meter_Location_Current"]
  * number: 0
["Voltage_AC_Phase_3"]
  * number: 238
["EnergyReactive_VArAC_Sum_Consumed"]
  * number: 1143
["Voltage_AC_Phase_1"]
  * number: 238.7
["PowerApparent_S_Phase_2"]
  * number: 295.2
["EnergyReal_WAC_Sum_Consumed"]
  * number: 602167
["Visible"]
  * number: 1
["Voltage_AC_PhaseToPhase_31"]
  * number: 412.8
["Voltage_AC_PhaseToPhase_12"]
  * number: 412.8
["Frequency_Phase_Average"]
  * number: 50
["PowerApparent_S_Phase_3"]
  * number: 119.3
["Details"]
  * table:
   ["Manufacturer"]
    * string: Fronius
   ["Model"]
    * string: Smart Meter TS 65A-3
   ["Serial"]
    * string: 1987314142
["Enable"]
  * number: 1
["PowerReactive_Q_Sum"]
  * number: -339.9
["EnergyReal_WAC_Plus_Absolute"]
  * number: 602167
["PowerApparent_S_Phase_1"]
  * number: 239.7
["PowerReactive_Q_Phase_1"]
  * number: -145.1
["PowerReal_P_Phase_3"]
  * number: 39.2

[Firechief]

The log shows it updates every 5s but values in the group addresses are not updated.
Tried grp.update instead of grp.checkupdate, but no change.

[Daniel]

What datatypes do you use for your objects?

[Firechief]

Daniel,

14. 4-byte floating point in HL Objects, but manual states that they are int16 and some acc32?

I'm trying like this now in the script:

Code:

grp.update('34/0/1', (data.Current_AC_Sum) ,dt.float16)                        -- Totaal vermogen (A)
grp.update('33/0/2', (data.Current_AC_Phase_1) ,dt.float16)                    -- Stroom L1 (A)
grp.update('33/0/3', (data.Current_AC_Phase_2) ,dt.float16)                    -- Stroom L2 (A)
grp.update('33/0/4', (data.Current_AC_Phase_3) ,dt.float16)                    -- Stroom L3 (A)
grp.update('34/0/5', (data.Voltage_AC_PhaseToPhase_12) ,dt.float32)                            -- Spanning L1-L2 (V)
grp.update('33/0/6', (data.Voltage_AC_PhaseToPhase_23) ,dt.float32)                        -- Spanning L2-L3 (V)
grp.update('33/0/7', (data.Voltage_AC_PhaseToPhase_31) ,dt.float32)                        -- Spanning L3-L1 (V)
grp.update('34/0/8', (data.Voltage_AC_Phase_1) ,dt.float32)                    -- Spanning L1-N (V)
grp.update('33/0/9', (data.Voltage_AC_Phase_2) ,dt.float32)                    -- Spanning L2-N (V)
grp.update('33/0/10', (data.Voltage_AC_Phase_3) ,dt.float32)                    -- Spanning L3-N (V)

and in HL Objects:

group 1-4: 2 byte floating point
group 5-10: 4 byte floating point.

This gives the correct values in HL, but still no auto update of those groups.

[admin]

Use float32 for instantaneous values like voltage, current etc, use int64 for counter values. What is stated in the manual does not matter because you are not reading via Modbus.

[Firechief]

Thx,

Rebooted the HL and now everything is updating. thx for the help.

[mxcxpx]

attached find my json

[admin]

Check this: http://www.fronius.com/QR-link/0006
Otherwise ask Fronius support directly. This is not something that we can help you with.

[mxcxpx]

If you can read JSON via HTTP requests then you can use it instead of Modbus.

for me this works to
http://IP of inverter/solar_api/v1/GetPowerFlowRealtimeData.fcgi

but how to implement in LogicMchine.

sorry iam new and have to learn by doing.
thanks