I want use JSON/XML Driver in VTScada A to read a tag from VTScada B.

The VTScada B has configured the corresponding parts. So I can get tag1 data in browser with URL "http://192.168.1.2:8080/web/REST/SQLQuery?query=select timestamp,'MyTest\Machine1\CommDriver\Tag1:value' from history ORDER BY Timestamp DESC limit 5" from VTScada B.

The data is as below:
{"results":{"fieldNames":["timestamp","MyTest\Machine1\CommDriver\Tag1:value"],"fieldTypeNames":["TIMESTAMP","DOUBLE"],"values":[[1635834093.209,22512],[1635834092.201,22510],[1635834091.194,22509],[1635834090.209,22507],[1635834089.2,22506]]},"returnCode":0,"errorMessage":null,"nextPageToken":null,"paginationStats":{"numRetrieved":5,"numResults":5,"timestampRetrieved":1635834089.2}}

Now I want use the JSON/XML Driver in VTScada A to read the tag1 data. My config is as below:

But I can`t get the data. What is wrong? Maybe do I need a new "Processor"? Whould you like to give me a sample with my data structure?

Thank you.

Firstly you will have to "escape" the URL by % encoding it, as per the URL in the browser.

Secondly you can only retrieve one of the values in the array and would need a custom processor to also retrieve the associated timestamp.

In general, to retrieve SQL data from VTScada (or elsewhere) you should use the SQL data driver and for VTScada this also requires the VTScada ODBC Driver.

@Graham Bloice thank you.

Did you try to read data via SQL data driver between two VTScada systems? I'm trying to do that right now, but am having issues with the \ in the SQL query.

@Careyh

Best to ask this as a new question rather than piggy-backing on to a different question.