Support Forums
Retrieve & decrypt operator notes via API?

Hi,

We have operators leaving notes on the screens of their assigned stations.
We are also connecting a database system to our VTScada server via API, for automated data analysis & statistics of our stations.

We would now like to import the operator notes into our analytics system.

We have managed to import the notes payload from a selected station, by querying the "notebook" tag.
However, this returns an encrypted payload.

How can we decrypt the notes payload to read the plain text left by operators?

Thanks!

Hi, We have operators leaving notes on the screens of their assigned stations. We are also connecting a database system to our VTScada server via API, for automated data analysis & statistics of our stations. We would now like to import the operator notes into our analytics system. We have managed to import the notes payload from a selected station, by querying the "notebook" tag. However, this returns an encrypted payload. **How can we decrypt the notes payload to read the plain text left by operators?** Thanks!

Yes, they are encrypted, and it is a known issue. Luckily, there is a simple workaround.

You can query the notebook directly using a query similar to the following:

SELECT Timestamp, Value FROM "System Notes" WHERE Value IS NOT NULL LIMIT 100
Yes, they are encrypted, and it is a known issue. Luckily, there is a simple workaround. You can query the notebook directly using a query similar to the following: ```` SELECT Timestamp, Value FROM "System Notes" WHERE Value IS NOT NULL LIMIT 100 ````

Trihedral Engineering Ltd.

30
2
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft