Sending Telemetry Data with API

[abdullah123456789]

Hello,

I need to send telemetry records collected by our SCADA system from the field to another server via an API. My goal is to prepare and send this data in JSON format directly from within Geo SCADA Expert 2023 November 2024, without exporting it first as CSV. Is it possible to achieve this using a Script Task or a similar method inside Geo SCADA? Any guidance or experiences from those who have done this would be greatly appreciated.

[BevanWeiss]

I wouldn't recommend it.

The formatting options within GeoSCADA are really limited to CSV type things as part of the SQL Exports.

If you have an external API that wants JSON, then you likely want to do more work to put that JSON in a nice hierarchy.. so you'll want to start using custom code.  You most as well commit to writing an external interface application, you can use things like .NET / Python / Node.js without too much difficulty.  I personally prefer .NET (C#) and this does tend to be the more commonly used interface amongst others that are doing similar things with GeoSCADA Expert also.

[sbeadle]

If you prefer scripting, then you could use Python and the .Net API.

See this example which shows how to connect up.

https://github.com/GeoSCADA/Utilities-and-Examples/blob/main/PythonSamples/Geo%20SCADA%20Samples.py

The 'dumps' method in the Python json library will output json directly:

from json import load, loads, dumps

Note that there's a new Python library coming soon, will make things even easier.