(Note this URL string has extra spaces for formatting purposes) Here is the query URL and its components: Here, we will use a relatively simple browser query in this example. The ODATA interface allows developers to either POST or GET data to/from the Historian while either consuming or producing data structures in the JSON format. The API is fully documented and examples can be found in the InSight online help. The can be accomplished via the provided REST API for both data and charts. The idea is to use an automated system to periodically connect to the OnLine Historian and extract the last Day/Week/Month of data for a specific set of tags at a particular resolution. While it is possible to use the InSight charting apps to export data to Excel for external use, this is a very manual process.

However, advanced users may need to Extract - Transform - Load data into other enterprise applications such as Material and Planning systems, Maintenance Management systems or enterprise reporting repositories to name a few. There is also mobile access to this data repository from mobile devices via the SmartGlance Apple or Android app. Wonderware's OnLine Historian has a default user interface for data visualization called InSight and is accessible from most any browser. This article from InSource shows how to use the Wonderware OnLine Historian InSight API to Extract, Transform and Load (ETL) data for use in other customized applications.

Wonderware online insight download