Json string parsing problem

Scoobsalamander

I have problems with parsing a string with the FB PJSOCT , somehow it is not detecting the values like "0-0:96.1.4" :

{
  "0-0:96.1.4": {
    "medium": 0,
    "channel": 0,
    "measurement": 96,
    "measureType": 1,
    "tariffRate": 4,
    "rawValue": "50215",
    "values": [
      {
        "value": 50215,
        "unit": ""
      }
    ]
  },
  "0-0:96.1.1": {
    "medium": 0,
    "channel": 0,
    "measurement": 96,
    "measureType": 1,
    "tariffRate": 1,
    "rawValue": "3153414731313030313530393931",
    "values": [
      {
        "value": "3153414731313030313530393931",
        "unit": ""
      }
    ]
  },
  "0-0:1.0.0": {
    "medium": 0,
    "channel": 0,
    "measurement": 1,
    "measureType": 0,
    "tariffRate": 0,
    "rawValue": "210217192713W",
    "values": [
      {
        "value": "210217192713W",
        "unit": ""
      }
    ]
  },
  "1-0:1.8.1": {
    "medium": 1,
    "channel": 0,
    "measurement": 1,
    "measureType": 8,
    "tariffRate": 1,
    "rawValue": "000987.072*kWh",
    "values": [
      {
        "value": 987.072,
        "unit": "kWh"
      }
    ]
  },
  "1-0:1.8.2": {
    "medium": 1,
    "channel": 0,
    "measurement": 1,
    "measureType": 8,
    "tariffRate": 2,
    "rawValue": "001143.964*kWh",
    "values": [
      {
        "value": 1143.964,
        "unit": "kWh"
      }
    ]
  },
  "1-0:2.8.1": {
    "medium": 1,
    "channel": 0,
    "measurement": 2,
    "measureType": 8,
    "tariffRate": 1,
    "rawValue": "000335.376*kWh",
    "values": [
      {
        "value": 335.376,
        "unit": "kWh"
      }
    ]
  },
  "1-0:2.8.2": {
    "medium": 1,
    "channel": 0,
    "measurement": 2,
    "measureType": 8,
    "tariffRate": 2,
    "rawValue": "000139.145*kWh",
    "values": [
      {
        "value": 139.145,
        "unit": "kWh"
      }
    ]
  },
  "0-0:96.14.0": {
    "medium": 0,
    "channel": 0,
    "measurement": 96,
    "measureType": 14,
    "tariffRate": 0,
    "rawValue": "0001",
    "values": [
      {
        "value": "0001",
        "unit": ""
      }
    ]
  },
  "1-0:1.7.0": {
    "medium": 1,
    "channel": 0,
    "measurement": 1,
    "measureType": 7,
    "tariffRate": 0,
    "rawValue": "00.665*kW",
    "values": [
      {
        "value": 0.665,
        "unit": "kW"
      }
    ]
  },
  "1-0:2.7.0": {
    "medium": 1,
    "channel": 0,
    "measurement": 2,
    "measureType": 7,
    "tariffRate": 0,
    "rawValue": "00.000*kW",
    "values": [
      {
        "value": 0,
        "unit": "kW"
      }
    ]
  },
  "1-0:21.7.0": {
    "medium": 1,
    "channel": 0,
    "measurement": 21,
    "measureType": 7,
    "tariffRate": 0,
    "rawValue": "00.665*kW",
    "values": [
      {
        "value": 0.665,
        "unit": "kW"
      }
    ]
  },
  "1-0:22.7.0": {
    "medium": 1,
    "channel": 0,
    "measurement": 22,
    "measureType": 7,
    "tariffRate": 0,
    "rawValue": "00.000*kW",
    "values": [
      {
        "value": 0,
        "unit": "kW"
      }
    ]
  },
  "1-0:32.7.0": {
    "medium": 1,
    "channel": 0,
    "measurement": 32,
    "measureType": 7,
    "tariffRate": 0,
    "rawValue": "231.6*V",
    "values": [
      {
        "value": 231.6,
        "unit": "V"
      }
    ]
  },
  "1-0:31.7.0": {
    "medium": 1,
    "channel": 0,
    "measurement": 31,
    "measureType": 7,
    "tariffRate": 0,
    "rawValue": "003.50*A",
    "values": [
      {
        "value": 3.5,
        "unit": "A"
      }
    ]
  },
  "0-0:96.3.10": {
    "medium": 0,
    "channel": 0,
    "measurement": 96,
    "measureType": 3,
    "tariffRate": 10,
    "rawValue": "1",
    "values": [
      {
        "value": 1,
        "unit": ""
      }
    ]
  },
  "0-0:17.0.0": {
    "medium": 0,
    "channel": 0,
    "measurement": 17,
    "measureType": 0,
    "tariffRate": 0,
    "rawValue": "999.9*kW",
    "values": [
      {
        "value": 999.9,
        "unit": "kW"
      }
    ]
  },
  "1-0:31.4.0": {
    "medium": 1,
    "channel": 0,
    "measurement": 31,
    "measureType": 4,
    "tariffRate": 0,
    "rawValue": "999*A",
    "values": [
      {
        "value": 999,
        "unit": "A"
      }
    ]
  },
  "0-0:96.13.0": {
    "medium": 0,
    "channel": 0,
    "measurement": 96,
    "measureType": 13,
    "tariffRate": 0,
    "rawValue": "",
    "values": [
      {
        "value": "",
        "unit": ""
      }
    ]
  }
}

cechurat

Hi Kris,

thanks for this bug report. The issue is in JSON object name containing "dots". I have passed it to our developers.

Sorry for difficulties caused by this issue.

Kind Regards,
Tomas

Scoobsalamander

@cechurat
No problem, Node-Red is always good for a (temporary) work around.