Software Toolbox Technical Blog

2 min read

Connect RESTful Web Services to Databases, OPC UA / DA & More Systems

Jun 4, 2020 2:00:00 PM

Accessing various industrial data via RESTful web services has become increasingly necessary over the past decade.  From devices with self-hosted web services to relevant market data such as weather information and pricing for commodities and energy, there is a host of relevant data to be integrated from such web services.

In this video, we will cover step-by-step how to easily connect to RESTful web services and perform reads and writes, as well as, logging data to and reading data from a database or connecting that data to other systems such as OPC UA - all with the OPC Router.Watch this video to see how easy it is to get connected to RESTful web services and databases using OPC Router, including logging web services data to a database, reading data back out of a database and then writing it to a RESTful web service.

In this video, we've shown you:

  1. How to configure a connection to any RESTful web service.
  2. How to configure request and response parameters for the web service connection.
  3. How to use the test function to confirm the proper RESTful response format from the web service.
  4. How to configure the JSON Read transfer object to properly process responses from the web service.
  5. Mapping web service data parameters into corresponding columns of a database using OPC Router's Visual Workflow capability.
  6. How to configure the JSON Write transfer object to write OPC Router data to a RESTful web service.

While this how-to video specifically demonstrates transferring RESTful web service data to and from databases, the OPC Router supports many other interfaces (including OPC UA and OPC DA) and can take any data in OPC Router and expose your own RESTful web service API for integration to systems that are RESTful clients.

Don't forget to subscribe to our blog to find out about the latest updates regarding OPC Router and for other how-to videos on using OPC Router.  Try OPC Router on your own connectivity and integration projects with the fully-functional free trial.

Click Now to Subscribe

Kevin Rutherford
Written by Kevin Rutherford

Join Our Journey

Working in industrial automation since 1996, the Software Toolbox team has seen a lot. The level of automation system sophistication of our integrators and users has evolved, each driven by the demands of their market and clients.  Everyone's learning continues as technological change accelerates.

This blog is about sharing from these journeys.  From tips on implementing software, successes our clients have experienced, or new ideas and things to consider in your journey, we'll be sharing them here.

Subscribe to our Blog

Recent Posts

Posts by Topic

See all