I want to query some data from vtscada by RESTFull WebAPI. For example : http://192.168.1.2:80/web/REST/SQLQuery?query=select timestamp,'Station 1\CommChannel\Level:value' from history

But how I should Authenticate with username and password for REST API ? Thanks.

When you query the API, you will receive a username and password request as part of the initial HTTP(s) handshake.

Hi, Dave, thank u.

If I use postman tool that is like below picture. How should I do the Authenticate with username and password? Thanks.

Just click into the Authorization tab and set the type to 'Basic Auth'. Then enter the username and password for a user with the 'Remote Data Access' privilege in VTScada.

You may want to add a touch more to your query to get the data you are expecting. Here is an example query I dug up from my history. In this case, I was looking for the records for two tags from the time of my query to the date given, or the latest 100 records in 1s intervals:

https://vtsdemo.trihedral.com/exceldemo/REST/SQLQuery?query=select timestamp,'Liftstations\LS1\Well\Level:Value:Average' AS LS1_Level, 'Liftstations\LS2\Well\Level:Value:Average' AS LS2_Level from history_1S where timestamp > '2021-04-21 12:57:00' limit 100 ORDER BY Timestamp DESC

@Dave - VTScada I have got the tag data by postman as your guidance. Thank U.

@flagshang - Thanks for following up on this, I'm glad it worked out for you.

Hello @ArghDave ,

Can we also write to the tag from a rest api? If so, how?
TIA!

VTScada's REST API is read only (For security) but you can write to tags by creating a server for JSON, XML, or MQTT and using the built-in drivers for either.