PI World 2019 Lab Programmability in the PI Connector for UFL
PI World 2019 Lab Programmability in the PI Connector for UFL
OSIsoft, LLC 1600 Alvarado Street San Leandro, CA 94577 USA Tel: (01) 510-297-5800 Web: ? 2019 by OSIsoft, LLC. All rights reserved. OSIsoft, the OSIsoft logo and logotype, Analytics, PI ProcessBook, PI DataLink, ProcessPoint, Asset Framework (AF), IT Monitor, MCN Health Monitor, PI System, PI ActiveView, PI ACE, PI AlarmView, PI BatchView, PI Vision, PI Data Services, Event Frames, PI Manual Logger, PI ProfileView, PI WebParts, ProTRAQ, RLINK, RtAnalytics, RtBaseline, RtPortal, RtPM, RtReports and RtWebParts are all trademarks of OSIsoft, LLC. All other trademarks or trade names used herein are the property of their respective owners. U.S. GOVERNMENT RIGHTS Use, duplication or disclosure by the U.S. Government is subject to restrictions set forth in the OSIsoft, LLC license agreement and as provided in DFARS 227.7202, DFARS 252.227-7013, FAR 12.212, FAR 52.227, as applicable. OSIsoft, LLC. Published: March 20, 2019
2|Page
Table of Contents
1. Introduction .................................................................................................................................................................... 4 1.1 Overview ................................................................................................................................................................. 4 1.2 Setup ....................................................................................................................................................................... 4
2. Background ..................................................................................................................................................................... 5 2.1 What is the PI Connector for UFL............................................................................................................................ 5 2.2 Terminology and Important Concepts .................................................................................................................... 5 2.3 REST API .................................................................................................................................................................. 6 2.4 Data Flow ................................................................................................................................................................ 7 2.5 PI Connector for UFL vs PI Interface for UFL........................................................................................................... 8 2.6 Tools and Utilities.................................................................................................................................................... 8
3. Data Parsing in the PI Connector for UFL...................................................................................................................... 10 3.1 Basic INI configuration file structure .................................................................................................................... 10 3.2 Collections............................................................................................................................................................. 10 3.3 Predefined Variables ............................................................................................................................................. 10 3.4 Main Functions to Interact with the PI Server ...................................................................................................... 11 3.5 Native Functions for CSV & JSON .......................................................................................................................... 12
4. Exercise 1 ? Parsing a CSV File with Variable Number of Columns............................................................................... 14 4.1 Objectives.............................................................................................................................................................. 14 4.2 Step 1: Add a PI Data Archive and PI Asset Framework Server ............................................................................ 14 4.3 Step 2: Configure data sources ............................................................................................................................. 17 4.4 Step 3: Start the connector ................................................................................................................................... 21 4.5 INI Configuration file contents .............................................................................................................................. 24
5. Exercise 2 ? Capture data from a REST API endpoint ................................................................................................... 25 5.1 Step 1 ? Explore the REST API ............................................................................................................................... 25 5.2 Step 2 ? Exploring the JSON response .................................................................................................................. 26 5.3 Step 3 ? Configure the Data Source ...................................................................................................................... 27 5.4 Step 4 ? Inspect the AF Structure created and the PI Vision display .................................................................... 28 5.5 Step 5 ? Parsing the JSON response...................................................................................................................... 29 5.6 Step 6 ?Multiple Cities Using the UFL_Placeholder.............................................................................................. 31 5.7 Step 7 ? Explore the Changes Made to the AF Structure and PI Vision Display ................................................... 32
6. Reference list ................................................................................................................................................................ 33
1. Introduction
1.1 Overview
This lab will explore the new features of the PI Connector for UFL to parse multi-column data files and using RESTful data sources with the PI Connector for UFL to collect information from a public REST API, and then send the data to a PI Server (Data Archive and AF server.) In this lab, users will gain the knowledge required to perform basic setup, configuration and troubleshooting for this connector to be able to parse data from REST APIs and data files.
1.2 Setup
This lab assumes the following: ? Running instances of the PI Server (Data Archive, AF Server) and PI Vision ? Running instance of a PI Connector for UFL
4|Page
2. Background
2.1 What is the PI Connector for UFL
The PI Connector for UFL allows the transfer of contextual and time-series data from ASCII files, REST clients and REST servers to the OSIsoft PI Server (Data Archive, Asset Framework).
2.2 Terminology and Important Concepts
2.2.1 REST ? REpresentational State Transfer is an architectural style for providing standards between RESTful systems. There are 3 HTTP verbs (kind of operation) that can be used with the PI Connector for UFL to interact between REST server and a REST client: ? PUT ? updates the specific resource ? POST ? creates a new resource ? GET ? retrieves a specific resource
2.2.2 HTTPS ? Encrypted adaptation of HTTP for secure communication across a network.
2.2.3 JSON ? JavaScript Object Notation (JSON) is a lightweight data-interchange format that is easy for both humans and machines to read. It has widely replaced XML since it is easier to read and parse. ? JSON is built on two structures: Object: collection of string/value pairs Array: collection of values ? {Object} ? unordered data held in curly braces
? [Array] ? ordered list of objects held in square brackets
5|Page
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- 20100105 ajax and json with jquery
- understanding json schema
- faq for and supplychain object
- working with json in rpg scott klement
- experiences with json and xml transformations
- application programming interfaces api 101
- json developer s guide oracle
- the json libname engine real world applications using
- json performance features in oracle 12c release 2
- pi world 2019 lab programmability in the pi connector for ufl
Related searches
- what s happening in the world today
- technology in the world today
- issues in the world today
- biggest problems in the world today
- things happening in the world today
- what s going on in the world today
- current events in the world 2019
- best education system in the world 2018
- issues in the world 2018
- best universities in the world for business
- calculator with the pi button
- all the words in the world list