Confim alarm with API or SQL

[ggre]

Hello,

I am trying to confirm an alarm via an external supervision system.

To do this, I found an Events API that would confirm an alarm but I can't get it to work. I manage to generate a Token with the RequestType "Events", but when I send the confirm command with Events.ashx, it gives me an error.
Do you know how to use this API?


Then, I noticed that there was possibility to confirm an alarm directly in SQL. I did an insert in the Confirms table and an Update in the AlarmItems table, but I don't know how to generate the Hash column. Is there a way to generate this Hash code via a script? Without this Hash, the alarm line in the RMS turns red.

For integration into the supervision system, the solution with SQL is preferred.

Thanks in advance for your feedback

[James]

Hi,

You cannot extract the events via the API, only historical measurement data: https://service.rotronic.com/manual/data-request.html.

There is no way to confirm the alarm directly within the SQL database. Any direct changes in the SQL database are manipulations and will be shown as such within the RMS interface.

For integration into the supervision system, if you want to extract data via the SQL database, then we can give you the table overview.

Please reach out to rms@rotronic.ch for more details.

Regards,
James

[donna1205]

Hi,

You cannot extract the events via the API, only historical measurement data: https://service.rotronic.com/manual/data-request.html. Retro Bowl Unblocked

There is no way to confirm the alarm directly within the SQL database. Any direct changes in the SQL database are manipulations and will be shown as such within the RMS interface.

For integration into the supervision system, if you want to extract data via the SQL database, then we can give you the table overview.

Please reach out to rms@rotronic.ch for more details.

Regards,
James

Thank you for sharing it

[pieceequally]

The API is really appreciated. Not having to write and compile any code is possible with the API Builder. It lets you call and try API functions. The screen shows the results of the action and any error codes that came up. This gets rid of the need to try things out and see what works and what doesn't. It helps you apply with confidence and get it right the first time.

[sprunki]

Hi,

You cannot extract the events via the API, only historical measurement data: https://service.rotronic.com/manual/data-request.html.

There is no way to confirm the alarm directly within the SQL database. sprunki mustard Any direct changes in the SQL database are manipulations and will be shown as such within the RMS interface.

For integration into the supervision system, if you want to extract data via the SQL database, then we can give you the table overview.

Please reach out to rms@rotronic.ch for more details.

Regards,
James

Thank you so much for sharing this information! I really appreciate it and found it incredibly helpful.