database details

[BartSr]

hi!
anyone who can point me to table/column of:
-timers of switches and the enable/disable timer switch
-same for switching notifications on off

thanks
Bart

[waltervl]

Use the APIs for this.

[BartSr]

Thanks Walter.
Can you give me some more specific info?
Thanks

[gizmocuz]

Have a look at the documentation here

https://wiki.domoticz.com/Domoticz_API/JSON_URL%27s

[BartSr]

thanks Rob. Lot to dig in

[BartSr]

I digged into the API and found e.g. for timers the command:

Code: Select all

/json.htm?type=command&param=getschedules&filter=device

That's nice! But now I'm looking for the syntax to set e.g. active to false
Can I use this command?

Code: Select all

/json.htm?type=command&param=updatetimer&idx=timerID&active=true&timertype=3&hour=0&min=20&randomness=true&command=0&days=12345</source>

So I can retrieve a full overview of all timer schedules. Did I miss same for notifications? (something like GetAllNotifications).

Or did I overlook that.


Thanks so far again.
Bart

[waltervl]

NO, first retrieve the timers and states with the getschedules command.
Then you can enable or disable the timer you want with the call

Code: Select all

/json.htm?type=command&param=enabletimer&idx=timerID

Or

Code: Select all

/json.htm?type=command&param=disabletimer&idx=timerID

[BartSr]

Thanks Walter. Any idea about 2nd Q?

[waltervl]

Read the timer/schedules section of the API wiki
https://wiki.domoticz.com/Domoticz_API/ ... _Schedules

It is all there.

[BartSr]

Walter, maybe you missed that 2nd Q is about notifications.

[waltervl]

There is a notifications section in the API wiki https://wiki.domoticz.com/Domoticz_API/ ... ifications

[BartSr]

Thanks Walter
I am looking for a command that lists ALL notifications just as is possible for timerschedules

[waltervl]

There seems no such query, only per device.
It is also not needed for the normal user interface as notifications are only handled per device.

The API is created for linking the web user interface with the core program.