Json parse - how to get value?

[tomes]

Hi,
I have a JSON string:

Code: Select all

{"folder":{"testA":{"isTalker":false,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1},"testB":{"isTalker":false,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1},"testC":{"isTalker":false,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1}}}

How can I get 2nd lever names using DzVents? I want to print testA testB testC
In my case these names may be different, so i must know all path to get for example item.json.folder.testA.tg
Or maybe there is a simpler way to extract these values?
I will be grateful for any hint.

Tom

[waaren]

I have a JSON string:
How can I get 2nd lever names using DzVents?

In my case these names may be different, so i must know all path to get for example item.json.folder.testA.tg

Not sure I completely understand the question but this should get you going.

Code: Select all

return
{
    on =
    {
        devices =
        {
            'jsonTrigger' -- virtual switch to start the script.
        },
    },
       
    logging =
    {
        level = domoticz.LOG_DEBUG,
        marker = 'json converter',
    },
   
    execute = function(dz)
        local lodash = dz.utils._ -- set of very useful tools
       
        myJSON = '{"folder":{"testA":{"isTalker":false,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1},"testB":{"isTalker":false,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1},"testC":{"isTalker":false,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1}}}'
        myTable = dz.utils.fromJSON(myJSON)
       
        dz.utils.dumpTable(myTable) -- dumps the complete json (converted  to a table)
       
        for key, subTable in pairs(myTable.folder) do
            dz.log(key ..': ' .. lodash.str(subTable), dz.LOG_DEBUG) -- key are the tableNames below 'folder'
        end
       
    end
}

[tomes]

Works perfectly! Thanks a lot.
So, i have another question. How to get KEY which have set isTalker:true?

Tom

[waaren]

Works perfectly! Thanks a lot.
So, i have another question. How to get KEY which have set isTalker:true?

Tom

Code: Select all

return
{
    on =
    {
        devices =
        {
            'jsonTrigger' -- virtual switch to start the script.
        },
    },
       
    logging =
    {
        level = domoticz.LOG_DEBUG,
        marker = 'json converter',
    },
   
    execute = function(dz)
        local lodash = dz.utils._ -- set of very useful tools
       
        myJSON = '{"folder":{"testA":{"isTalker":false,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1},"testB":{"isTalker":true,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1},"testC":{"isTalker":false,"monitoredTGs":[],"protoVer":{"majorVer":1,"minorVer":0},"tg":1}}}'
        myTable = dz.utils.fromJSON(myJSON)
        dz.utils.dumpTable(myTable) --

        for key, subTable in pairs(myTable.folder) do
            if subTable.isTalker then -- if true
                dz.log(lodash.str(key),dz.LOG_DEBUG)
            end
        end
    end
}

[tomes]

Great! Thanks again. Everything works perfectly!