AnsweredAssumed Answered

Bug in streamsets Controller?

Question asked by ChristopherWeh on Jun 27, 2019
Latest reply on Jul 12, 2019 by jwu

I am trying to use selectedFields as much as possible, with the streamsets Controller I encounter a strange behavior to retrieve the UnitsAbbrevation Fields using selected Fields. I can use:

 

PIServerURL/piwebapi/streamsets/interpolated?webid=I1AbEHDs7QMD6G0aidrJFCv1gIAQMgcCNex6BGA-gBQVplZogwRnvOFcvrEGLCDr3dLsD8g&starttime=*-2h&selectedFields=Items.Items

 

To get:

{   "Items": [     {       "Items": [         {           "Timestamp": "2019-06-27T13:06:51.9161355Z",           "Value": 1034.21313,           "UnitsAbbreviation": "mbar",           "Good": true,           "Questionable": false,           "Substituted": false,           "Annotated": false         },         {           "Timestamp": "2019-06-27T14:06:51.9161355Z",           "Value": 110.706566,           "UnitsAbbreviation": "mbar",           "Good": true,           "Questionable": false,           "Substituted": false,           "Annotated": false         },         {           "Timestamp": "2019-06-27T15:06:51.9161355Z",           "Value": 1022.0,           "UnitsAbbreviation": "mbar",           "Good": true,           "Questionable": false,           "Substituted": false,           "Annotated": false         }       ],       "UnitsAbbreviation": "mbar"     }   ] }

 

 

But If I use:

PIServerURL/piwebapi/streamsets/interpolated?webid=I1AbEHDs7QMD6G0aidrJFCv1gIAQMgcCNex6BGA-gBQVplZogwRnvOFcvrEGLCDr3dLsD8g&starttime=*-2h&selectedFields=Items.Items.Value;Items,UnitsAbbrevatio

The UnitsAbbrevation field is missing. I'm getting:

 

{   "Items": [     {       "Items": [         {           "Value": 666.511658         },         {           "Value": 115.604385         },         {           "Value": 1022.0         }       ]     }   ] }

 

 

Is this a bug or am I doing something wrong?

Outcomes