AnsweredAssumed Answered

PI Web API: Query AF Table

Question asked by Doddabasappa Champion on Feb 16, 2017
Latest reply on Sep 19, 2017 by Marcos Vainer Loeff


I would like to know syntax to pass where condition parameters while making web api query to AF Table along with selected fields.


https://<PIweb api machinename>/piwebapi/tables/ afTablewedid /data?selectedFields=Rows.Equipment Class;Rows.EquipmentTagName;Rows.Monitoring




select equipment class, EquipmentTagname, Rows monitoring from aftable

where Rows monitoring=1