Page 1 of 1

database details

Posted: Thursday 11 September 2025 22:15
by 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

Re: database details

Posted: Friday 12 September 2025 7:03
by waltervl
Use the APIs for this.

Re: database details

Posted: Friday 12 September 2025 7:21
by BartSr
Thanks Walter.
Can you give me some more specific info?
Thanks

Re: database details

Posted: Friday 12 September 2025 7:48
by gizmocuz
Have a look at the documentation here

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

Re: database details

Posted: Friday 12 September 2025 8:04
by BartSr
thanks Rob. Lot to dig in

Re: database details

Posted: Saturday 13 September 2025 11:22
by 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

Re: database details

Posted: Saturday 13 September 2025 17:34
by 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

Re: database details

Posted: Saturday 13 September 2025 18:49
by BartSr
Thanks Walter. Any idea about 2nd Q?

Re: database details

Posted: Saturday 13 September 2025 19:17
by waltervl
Read the timer/schedules section of the API wiki
https://wiki.domoticz.com/Domoticz_API/ ... _Schedules

It is all there.

Re: database details

Posted: Saturday 13 September 2025 19:59
by BartSr
Walter, maybe you missed that 2nd Q is about notifications.

Re: database details

Posted: Saturday 13 September 2025 20:50
by waltervl
There is a notifications section in the API wiki https://wiki.domoticz.com/Domoticz_API/ ... ifications

Re: database details

Posted: Saturday 13 September 2025 23:06
by BartSr
Thanks Walter
I am looking for a command that lists ALL notifications just as is possible for timerschedules

Re: database details

Posted: Saturday 13 September 2025 23:10
by 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.