Load a data from json into a fibaro global variable

[pixys 1]

Hello

 

I'm trying to do a virtual devise with load a json data with the current date. I'm currently stuck with LUA programming, If you could help me , it would be nice.

www.mysite.com/json/data.json
is looking like this

Please login or register to see this code.

 

Please login or register to see this code.

 

What I'm trying to do is in theory quite simple.

I do read my json

with the current date, I try to see if I can get a value for the date in my json,
if yes, I do set the Variable in Fibaro named "Today" with the value of my json.

 

Thanks a lot

Christophe

[jgab 2,642]

Please login or register to see this code.

 

Edited January 28, 2020 by jgab

[pixys 1]

Thanks a lot for your code.

 

I did try It, it is working when I manually define

Please login or register to see this code.

 

but if I do take res from

res = HC2:GET("/ical/test.json") with the same content, it is not working anymore, it says

[DEBUG] 14:54:41: { d20200201="A", d20200204="A", d20200128="B", d20200207="C"}
[DEBUG] 14:54:41: Value for d20200128 not found

 

it looks like it does not recognise the type of the array anymore. Any idea why ?

 

[jgab 2,642]

5 minutes ago, pixys said:

Thanks a lot for your code.

 

I did try It, it is working when I manually define

Please login or register to see this code.

 

but if I do take res from

res = HC2:GET("/ical/test.json") with the same content, it is not working anymore, it says

[DEBUG] 14:54:41: { d20200201="A", d20200204="A", d20200128="B", d20200207="C"}
[DEBUG] 14:54:41: Value for d20200128 not found

 

it looks like it does not recognise the type of the array anymore. Any idea why ?

 

 

res = json.decode(HC2:GET("/ical/test.json"))

[pixys 1]

Thanks you so much

 

After checks when you load it from json without the decode, it is a string

the json.decode convert the json to an array

 

In order to work I had to

 

response = HC2:GET("/json/myjson.json")
response = json.decode(response)

 

change my file from

Please login or register to see this code.

 

to

Please login or register to see this code.