Help with JSON_TABLE syntax for parsing JSON

Database
Highlighted
Teradata Employee

Help with JSON_TABLE syntax for parsing JSON

Having trouble with the JSON_TABLE syntax.  Given the JSON below, what is the appropriate JSON_TABLE syntax to pull out the RecordInfo?

{

  "RecordInfo":{

    "ApiVer":"1.3.0.0",

    "DeviceId":"NPC0000001",

    "HostUnixTime":1525964185130,

    "SessionId":"1525964180538"

  },

  "StreamState":{

    "AccelStreamEnabled":false,

    "AdaptiveStreamEnabled":false,

    "DetectionStreamEnabled":false,

    "FftStreamEnabled":false,

    "LoopRecordMarkerEchoStreamEnabled":false,

    "PowerDomainStreamEnabled":false,

    "StreamsEnabled":false,

    "TimeDomainStreamEnabled":false,

    "TimeSyncStreamEnabled":false

  }

}

 

Here is what I'm doing, which returns no results.  I have tried countless different combinations of rowexpr and jsonpath but have had no success.  Can anyone help?

 

SELECT * FROM JSON_Table

( ON (select json_id, json_txt from mt.devicesettings_all where json_id = 2)

USING rowexpr('$RecordInfo.')

      colexpr('[{"jsonpath" : ".ApiVer", "type" : "VARCHAR(20)"}]')

) AS JT(json_id,ApiVer);