JSON data - can't find the right way of grabbing info from data

[Symbiot78 2]

Hi

 

I need to get the lockStatus from this, but I can't find the right way..

data.armState.statusType works..

but 

data.doorLockStatusList.lockedState doesn't. 

There's a [ in doorLockStatusList that isn't there for armState - but I don't know how that changes the way I need to get the info.

data.doorLockStatusList.lockedState.lockedstate doesn't work.

if I add data.doorLockStatusList.0.lockedState lua crashes

if I add data.doorLockStatusList[0].lockedState i get "nil" as result

if I add data.doorLockStatusList[lockedState] I get "nil" as result.. 

What am I msising?

 

{

"accountPermissions": {

"accountPermissionsHash": "###########################"

},

"armState": {

"statusType": "DISARMED",

"date": "2021-06-29T15:01:39.000Z",

"name": "Fibaro Verisure",

"changedVia": "REMOTE_APP"

},

"smartPlugs": [],

"doorLockStatusList": [

{

"deviceLabel": "2CBK DK42",

"area": "Fordør",

"userString": "Tina Thomsen",

"method": "TAG",

"lockedState": "UNLOCKED",

"currentLockState": "UNLOCKED",

"pendingLockState": "NONE",

"eventTime": "2021-11-06T10:28:01.000Z",

"secureModeActive": false,

"motorJam": false,

"paired": true

}

],

[jgab 2,642]

Please login or register to see this code.

It's an array so you need to pick out an element from the array - in this case the first [1] element.

Beware, the reason it returns an array is that there can be multiple items in the array.

I don't know hoe the lock responds but it could be a list of previous users unlocking... and if you are lucky the last is the first.

 

[Symbiot78 2]

@jgab.. that worked BUT...

 

why... when the json looks like this in json2table?:

it says '0' .. which I tried... 

 

Please login or register to see this attachment.

[jgab 2,642]

Because many other languages index arrays from 0 - like javascript and probably the 'json2table' tool you used.

Lua index all arrays starting from 1.

Edited November 6, 2021 by jgab