Working with tables and GlobalVars

[RonS 0]

I am building this for my own educational purpose and got stuck thinking I was almost there.

I build a table that holds my devices and their id’s. The table tutorial helped a great deal.

Please login or register to see this image.

/uploads/monthly_2021_11/image.png.6d663f504fed1c1881de45b42d665435.png" />

I can traverse through the table. I store the table via an encode into a GlobalVar. Which seem to succeed.

Next I do a Get on the GlobalVar which is successful (status 200), I get a table when I extract the response (response.value). 

 

But when I traverse with the “in pairs” construct I receive an error. Apparently, the response is now a string.

 

function getDeviceTable()

 

  response, status = api.get("/globalVariables/DeviceTable/",

    {

    name="DeviceTable"

    });

  

  fibaro:debug(status); 

  fibaro:debug(response);

  fibaro:debug(response.value);

 

  local table = response.value;

 

  --local jtable = json:decode(table);

  --fibaro:debug(jtable);

  

  for k,v in pairs(table) do

    print("first level key: " ..k..", first level value: ".. tostring(v))

    --for k2,v2 in pairs(v) do -- This works because we KNOW v is a table.

      --print(" second level key: " ..k2..", second level value: "..v2)

    --end;

  end;

 

 

 

If I json:decode response.value the outcome is the same.

So, how do I get a response from the GlobalVar that I can work with? 

Thanks for your help.

 

[jgab 2,642]

You don't end the path with a slash or add the extra table value....

response, status = api.get("/globalVariables/DeviceTable/",

    {

    name="DeviceTable"

    });

You do 

response, status = api.get("/globalVariables/DeviceTable")

or simpler

fibaro.getGlobalVariable("DeviceTable") and you get the value directly - and then you json.decode the value.

[RonS 0]

Thanks! However, the code both give the same output and result. For whatever reason this picture did not make it into the post.

Please login or register to see this image.

/monthly_2021_11/image.png.97e3c228b23e330b99a3c9052df81a9a.png" />

I just do not understand how to work with the output as I keep getting errors.

Ron

[jgab 2,642]

local table = response.value

local jtable = json.decode(table)   --- json.decode, not json:decode

for k,v in pairs(jtable) do   -- jtable, not table

    print("first level key: " ..k..", first level value: ".. tostring(v))

end

 

[RonS 0]

@jgabI am flabbergasted. Spend day and a half on this and it turned out I should use json.decode instead of json:decode. I tried so many variations ...

So how does this work in terms of convention? I use fibaro:debug but must use json.decode; when to use a ":" and when a ".".

But thanks a lot for your help .. small things do matter.

[jgab 2,642]

51 minutes ago, RonS said:

@jgabI am flabbergasted. Spend day and a half on this and it turned out I should use json.decode instead of json:decode. I tried so many variations ...

So how does this work in terms of convention? I use fibaro:debug but must use json.decode; when to use a ":" and when a ".".

But thanks a lot for your help .. small things do matter.

Please login or register to see this code.

 

: is used when calling function in an object oriented way, passing on the object as the first argument (self)

On the HC2 fibaro used the : calling convention even though they really didn't leverage the objeeecet model. On the HC3 it's the dot notation again. fibaro being just a table with functions. You use : when  calling QuickApp functions  as QuickApp is a class that creates the runtime QuickApp object. Inside QuickApp function you refer to the  object with the variable 'self'

You could also do

Please login or register to see this code.

 

but it's more elegant to do

Please login or register to see this code.