Back

Topic

[KB1183]REST provider – Version 1

Tags: Provider, Rest, Web Services

UDC
2 years ago
By NK
Options
Print
Applies to:

PcVue 16 onwards
Summary:

This article contains attached files at the end.

This provider allows direct interaction with a multitude of REST API.

Note that some APIs do not respect the standards or require an unsupported authentication mode. In this case, a specific provider should be considered.
Status:

This provider has the status: Release
Details:

Download the latest version of the provider proposed in the table at the end of this article and unzip it to execute the msi file.

Follow the instruction given in the ADO.Net Providers installation procedure article to install this provider.

To declare a connection into PcVue, goto General -> Data connections -> Add a SQL connection and select the Data source Built-in providers, then you can choose .NET Framework Data Provider for REST Data provider:

REST Provider declaration part 1

Finally go to the second tab (Built-in) to configure the connection:

REST Provider declaration part 2

The connection string will depend on the API you are using. Please refer to the documentation of the API to find the good parameters. Also refer to the documentation of the provider (in the table at the end of this article) to get more details and examples.

Few sample queries:

SELECT * FROM [get_message] QUERYSTRING(“chat_id=abcd)

SELECT * FROM [get_message] HEADER(“Accept: application/json”)

SELECT Time.Value  FROM [get_RealtimeData/v2/values/Time] MaxDepth(2)

Files attached consist in the:

Attached file Description
sv-adonet-provider_Rest_1.0.609.zip Version 1.0.609 of REST provider
Provider Rest – GuideLine – draft The documentation
The Release Notes

Created on: 02 Feb 2023 Last update: 25 Sep 2024