Asset Attribute with JSON Object and store data points to Line Chart

BrutalBirdie · July 3, 2023, 2:29pm

Me again

I was looking into the doc now for creating default dashboard for users and first noticed I could not select my device for a dashboard.

Quick search lead me to User Guide: Manager UI · openremote/openremote Wiki · GitHub where its described I need to add Store data points. Fair enough.

But when I select the Attribute with the JSON Object the Line Graph loads for ever.
Understandable since how should the line graph know which json path to render. At least this is what my head tells me.

I must be missing something
How can I create a Dashboard with Data from a JSON Object?
Somehow I need to configure the graphs to show either JSON Paths or something.

Don · July 3, 2023, 3:36pm

Hi Birdie,

We’re adding a filter to the asset attribute picker so you can’t select an attribute with a valuetype that does not match the widget anymore. So that should solve your initial confusion

Secondly, if you are getting the data using an Agent Link, you can filter the JSON with a value filter so that you only write the value that you need, not the whole object, to the attribute. However, I believe you are using the MQTT API, so you could do the following:

Write the JSON to an attribute ‘A’
Add the attribute link configuration item to that attribute to push a filtered value to another attribute ‘B’
Unfortunately the attribute link does not have a nice form UI yet, so you will have to it like this:

[
  {
    "ref": {
      "id": "ASSET_ID",
      "name": "B"
    },
    "filters": [
      {
        "type": "jsonPath",
        "path": "$.main.temp",
        "returnFirst": true,
        "returnLast": false
      }
    ]
  }
]

Now attribute ‘B’ will have the value.

You can push to multiple attributes. See this tutorial for more info: Tutorial: Open Weather API using HTTP Agent · openremote/openremote Wiki · GitHub

There might be a better solution that I can’t quickly think of now

Don

BrutalBirdie · July 3, 2023, 3:37pm

Will take a look. Thanks!

BrutalBirdie · July 3, 2023, 7:03pm

Don:

[
  {
    "ref": {
      "id": "ASSET_ID",
      "name": "B"
    },
    "filters": [
      {
        "type": "jsonPath",
        "path": "$.main.temp",
        "returnFirst": true,
        "returnLast": false
      }
    ]
  }

Invalid JSON missing a closing ]

But I got it. Currently configuring and well report back.

BrutalBirdie · July 3, 2023, 7:21pm

I just had it working.

But I needed to change an attribute from Integer to Long but since some data was already stored I think now something is buggy

I created a new asset to start fresh, but now when I want to add attribute links to the asset and press save I get this. . .

Log:

openremote-proxy-1       | 03/Jul/2023:19:20:56 +0000 https~ 172.19.0.1:55026 manager 0/0/0/14/14 "PUT /api/master/asset/4DrKYOjRz8AyWTFX1EiOla HTTP/1.1" 204 2/2/1/1/0 0/0

And now its just doing nothing…
Not only for this one asset but for all assets

I manage to break it all

BrutalBirdie · July 3, 2023, 7:45pm

Ohhhhhh!

Since the Asset is getting new Data every second even while configuring, the web view is getting resetted.
That’s why the JSON Object in the put request does not contain the the config for the attribute configuration.

this sounds like a “bug” or unintended behavior.

BrutalBirdie · July 3, 2023, 8:10pm

Working now:

Thanks @Don

BrutalBirdie · July 4, 2023, 11:45am

Added an update function to my code so on device creation it will set the Attribute Links, Attributes with meta to storeDataPoints.

github.com

Indielux-GmbH/R2P-OpenRemote-Bridge/blob/027f14bfda4e1f49177c2dd53f1c777ac6450553/Docker/app/code/openremote/main.py#L72-L78


      
          def updateAsset(assetID, assetName):
              getApiToken()
              rURL = f'{apiurl}/api/master/asset/{assetID}'
              rHeaders = {'Authorization': f'Bearer {thismodule.apitoken}'}
              rData = {"name": f"{assetName}","realm":"master","type":"ThingAsset","attributes":{"notes":{"type":"text","value":None,"name":"notes"},"location":{"type":"GEO_JSONPoint","value":None,"name":"location"},"tele":{"type":"JSONObject","value":None,"name":"tele","meta":{"attributeLinks":[{"ref":{"id":f"{assetID}","name":"client_id"},"filters":[{"type":"jsonPath","path":"$.client_id","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mac"},"filters":[{"type":"jsonPath","path":"$.mac","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"pcb_id"},"filters":[{"type":"jsonPath","path":"$.pcb_id","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"uptime"},"filters":[{"type":"jsonPath","path":"$.uptime","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"pcb_temp"},"filters":[{"type":"jsonPath","path":"$.pcb_temp","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"wifi_rssi"},"filters":[{"type":"jsonPath","path":"$.wifi_rssi","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"localtime"},"filters":[{"type":"jsonPath","path":"$.localtime","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"ts_since_unix_epoch"},"filters":[{"type":"jsonPath","path":"$.ts_since_unix_epoch","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"reset_cause"},"filters":[{"type":"jsonPath","path":"$.reset_cause","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"wake_cause"},"filters":[{"type":"jsonPath","path":"$.wake_cause","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mem_free"},"filters":[{"type":"jsonPath","path":"$.mem_free","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mem_alloc"},"filters":[{"type":"jsonPath","path":"$.mem_alloc","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"part_boot"},"filters":[{"type":"jsonPath","path":"$.part_boot","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"tainted"},"filters":[{"type":"jsonPath","path":"$.tainted","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"cable_temp_esp32"},"filters":[{"type":"jsonPath","path":"$.cable_temp_esp32","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"cable_temp_stm32"},"filters":[{"type":"jsonPath","path":"$.cable_temp_stm32","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"ampere_rms_esp32"},"filters":[{"type":"jsonPath","path":"$.ampere_rms_esp32","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"ampere_rms_stm32"},"filters":[{"type":"jsonPath","path":"$.ampere_rms_stm32","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"volt_gridmeter"},"filters":[{"type":"jsonPath","path":"$.volt_gridmeter","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mpy_sysname"},"filters":[{"type":"jsonPath","path":"$.mpy_sysname","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mpy_nodename"},"filters":[{"type":"jsonPath","path":"$.mpy_nodename","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mpy_release"},"filters":[{"type":"jsonPath","path":"$.mpy_release","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mpy_ver_str"},"filters":[{"type":"jsonPath","path":"$.mpy_ver_str","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mpy_git_tag"},"filters":[{"type":"jsonPath","path":"$.mpy_git_tag","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mpy_git_hash"},"filters":[{"type":"jsonPath","path":"$.mpy_git_hash","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"mpy_machine"},"filters":[{"type":"jsonPath","path":"$.mpy_machine","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"ip_addr"},"filters":[{"type":"jsonPath","path":"$.ip_addr","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"ip_subnet"},"filters":[{"type":"jsonPath","path":"$.ip_subnet","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"ip_gateway"},"filters":[{"type":"jsonPath","path":"$.ip_gateway","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"ip_dns"},"filters":[{"type":"jsonPath","path":"$.ip_dns","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"wifi_essid"},"filters":[{"type":"jsonPath","path":"$.wifi_essid","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"wifi_peer_mac"},"filters":[{"type":"jsonPath","path":"$.wifi_peer_mac","returnFirst":True,"returnLast":False}]},{"ref":{"id":f"{assetID}","name":"dev_id"},"filters":[{"type":"jsonPath","path":"$.dev_id","returnFirst":True,"returnLast":False}]}]}},"subscribeAttribute":{"type":"boolean","value":None,"name":"subscribeAttribute"},"client_id":{"name":"client_id","type":"text","meta":{"storeDataPoints":True}},"mac":{"name":"mac","type":"text","meta":{"storeDataPoints":True}},"pcb_id":{"name":"pcb_id","type":"text","meta":{"storeDataPoints":True}},"dev_id":{"name":"dev_id","type":"text","meta":{"storeDataPoints":True}},"uptime":{"name":"uptime","type":"long","meta":{"storeDataPoints":True}},"localtime":{"name":"localtime","type":"long","meta":{"storeDataPoints":True}},"ts_since_unix_epoch":{"name":"ts_since_unix_epoch","type":"long","meta":{"storeDataPoints":True}},"reset_cause":{"name":"reset_cause","type":"integer","meta":{"storeDataPoints":True}},"wake_cause":{"name":"wake_cause","type":"integer","meta":{"storeDataPoints":True}},"mem_free":{"name":"mem_free","type":"integer","meta":{"storeDataPoints":True}},"mem_alloc":{"name":"mem_alloc","type":"integer","meta":{"storeDataPoints":True}},"mpy_sysname":{"name":"mpy_sysname","type":"text","meta":{"storeDataPoints":True}},"mpy_nodename":{"name":"mpy_nodename","type":"text","meta":{"storeDataPoints":True}},"mpy_release":{"name":"mpy_release","type":"text","meta":{"storeDataPoints":True}},"mpy_ver_str":{"name":"mpy_ver_str","type":"text","meta":{"storeDataPoints":True}},"mpy_git_tag":{"name":"mpy_git_tag","type":"text","meta":{"storeDataPoints":True}},"mpy_git_hash":{"name":"mpy_git_hash","type":"text","meta":{"storeDataPoints":True}},"mpy_machine":{"name":"mpy_machine","type":"text","meta":{"storeDataPoints":True}},"part_boot":{"name":"part_boot","type":"integer","meta":{"storeDataPoints":True}},"tainted":{"name":"tainted","type":"boolean","meta":{"storeDataPoints":True}},"pcb_temp":{"name":"pcb_temp","type":"integer","meta":{"storeDataPoints":True}},"cable_temp_esp32":{"name":"cable_temp_esp32","type":"integer","meta":{"storeDataPoints":True}},"cable_temp_stm32":{"name":"cable_temp_stm32","type":"integer","meta":{"storeDataPoints":True}},"ampere_rms_esp32":{"name":"ampere_rms_esp32","type":"integer","meta":{"storeDataPoints":True}},"ampere_rms_stm32":{"name":"ampere_rms_stm32","type":"integer","meta":{"storeDataPoints":True}},"volt_gridmeter":{"name":"volt_gridmeter","type":"integer","meta":{"storeDataPoints":True}},"ip_addr":{"name":"ip_addr","type":"text","meta":{"storeDataPoints":True}},"ip_subnet":{"name":"ip_subnet","type":"text","meta":{"storeDataPoints":True}},"ip_gateway":{"name":"ip_gateway","type":"text","meta":{"storeDataPoints":True}},"ip_dns":{"name":"ip_dns","type":"text","meta":{"storeDataPoints":True}},"wifi_rssi":{"name":"wifi_rssi","type":"integer","meta":{"storeDataPoints":True}},"wifi_essid":{"name":"wifi_essid","type":"text","meta":{"storeDataPoints":True}},"wifi_peer_mac":{"name":"wifi_peer_mac","type":"text","meta":{"storeDataPoints":True}}}}
              r = requests.put(url=rURL, json=rData, headers=rHeaders)
              return r.status_code

This file has been truncated. show original