Storage Integration - Not showing payload fields when integers or floats

3

That’s a Decoder for a very specific device, but indeed it outputs numbers, just like the OP’s Decoder does, and booleans. Are you saying you’re using this with the Storage Integration, and that it shows data when fetching that?

No. It works for me, at least when using Swagger UI (as linked from “go to platform” from the integration’s settings).

Are you testing with Swagger UI? What if you do? What if you don’t set a time in your request (which then defaults to 1 hour)? What if you add a single dummy string value? (You already wrote “storage only happens if ALL the values are passed as strings”.)

You might want to post the Payload Format code.

Did you really test the all-numbers Decoder output? Or is there always some string value? (I don’t have any decoders at hand that output some string along with numbers. Maybe having at least one string value changes things.)

Just for your information: I do have problems fetching nested objects, which yield a string value "map[...]". But numbers are okay.

For example, when TTN Console shows that my Decoder returns some nested object:

{
  "battery": 93,
  "no2": {
    "max": 0.26,
    "median": 0.22,
    "min": 0.19
  },
  "pressure": {
    "max": 107.47,
    "median": 106.49,
    "min": 106
  },
  "temperature": {
    "max": 20.96,
    "median": 20.96,
    "min": 20.96
  }
}

…then Swagger UI gets me:

[
  {
    "battery": 93,
    "device_id": "haarlem-waspmote-1-24-139",
    "no2": "map[median:0.22 min:0.19 max:0.26]",
    "pressure": "map[min:106 max:107.47 median:106.49]",
    "raw": "CDAIMAgwKWgpmSn7ABMAFgAaXQ==",
    "temperature": "map[max:20.96 median:20.96 min:20.96]",
    "time": "2019-11-28T22:36:36.665667086Z"
  }
]

This is the same format that TTN Console shows for “historical data”, when the Storage Integration is enabled.

But above, the "battery": 93 is fine.

Same good results for another application, which shows the following in TTN Console, hence does not include any string values (but does contain some null values, which are not shown in TTN Console):

{
  "humidity": 60.01,
  "temperature": 23.91
}

For the above the integration does include the null values, which TTN Console does not show above:

[
  {
    "device_id": "haarlem-bb-1",
    "humidity": 60.01,
    "raw": "CVcXcQ==",
    "temperature": 23.91,
    "time": "2019-11-28T22:47:11.63668127Z",
    "vcc": null,
    "vdd": null
  },
  ...
]
1 Like