Exercise 1: PI Web API

Document created by Milanez on May 28, 2020Last modified by Milanez on May 29, 2020
Version 2Show Document
  • View in full screen mode
  1. What Authentication method you are using to connect to the PI Web API? Kerberos
  2. What is the Windows account used to connect to the PI Web API? administrator@pisystem
  3. What is the version of the PI Web API?
    "ProductTitle": "PI Web API 2019 SP1",   "ProductVersion": "1.13.0.6518",
  4. What is the version of the AF Server? 
    "ServerVersion": "2.10.8.440",
  5. How many databases are there in the AF Server? 11
  6. Using the links, navigate through the hierarchy to the \\PIAF\Nugreen\Nugreen\Wichita\Cracking Process\Equipment\P-723|Motor Amps Attribute. What type of Data Reference is it using? What is the current value of the attribute? PI POINT SINUSOID,
    {   "Timestamp": "2020-05-28T11:53:07Z",   "Value": 46.998111724853516,   "UnitsAbbreviation": "A",   "Good": true,   "Questionable": false,   "Substituted": false,   "Annotated": false }
  7. What is the Server ID of the PI Data Archive? Help pages: PI Web API Help > DataServer > List, Id property
  8. Using the point list link, find the Point ID and WebId of point 'CDT158' If you have more than 1000 points, you must use the maxCount parameter at URL.
     "WebId": "F1DPX3HQF38D5UCGzSdDA7DQ_QAwAAAAU0VSVkVSXENEVDE1OA",       "Id": 3,       "Name": "CDT158",       "Path": "\\\\SERVER\\CDT158",       "Descriptor": "Atmospheric Tower OH Vapor",       "PointClass": "classic",       "PointType": "Float32",       "DigitalSetName": "",       "EngineeringUnits": "DEG. C",       "Span": 200.0,       "Zero": 50.0,       "Step": false,       "Future": false,       "DisplayDigits": -5,
  9. Using the Interpolated data link for CDT158 determine what is the default start time, end time, and time interval for the interpolated data? Default start time is yesterday, and end time is now. Both in UTC. Time interval is one hour.

    {   "Links": {},   "Items": [     {       "Timestamp": "2020-05-27T12:08:53.7189363Z",       "Value": 101.435127,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T13:08:53.7189363Z",       "Value": 84.77892,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T14:08:53.7189363Z",       "Value": 96.81891,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T15:08:53.7189363Z",       "Value": 55.8212967,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T16:08:53.7189363Z",       "Value": 60.299614,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T17:08:53.7189363Z",       "Value": 66.5827,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T18:08:53.7189363Z",       "Value": 61.53206,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T19:08:53.7189363Z",       "Value": 74.03626,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T20:08:53.7189363Z",       "Value": 98.0490646,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T21:08:53.7189363Z",       "Value": 105.240791,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T22:08:53.7189363Z",       "Value": 100.051514,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-27T23:08:53.7189363Z",       "Value": 87.41311,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T00:08:53.7189363Z",       "Value": 86.64315,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T01:08:53.7189363Z",       "Value": 56.96948,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T02:08:53.7189363Z",       "Value": 76.976,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T03:08:53.7189363Z",       "Value": 58.9088936,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T04:08:53.7189363Z",       "Value": 84.3005,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T05:08:53.7189363Z",       "Value": 53.3664551,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T06:08:53.7189363Z",       "Value": 78.93682,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T07:08:53.7189363Z",       "Value": 91.92295,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T08:08:53.7189363Z",       "Value": 102.260544,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T09:08:53.7189363Z",       "Value": 76.50007,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T10:08:53.7189363Z",       "Value": 69.35433,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T11:08:53.7189363Z",       "Value": 85.52141,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     },     {       "Timestamp": "2020-05-28T12:08:53.7189363Z",       "Value": 70.50954,       "UnitsAbbreviation": "",       "Good": true,       "Questionable": false,       "Substituted": false,       "Annotated": false     }   ],   "UnitsAbbreviation": "" }

Attachments

    Outcomes