Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI Web API Reference

Table GetData

Table GetData

Get the table's data.

Request

GET tables/{webId}/data

URL Parameters

  • webId

    The ID of the table. See WebID for more information.

  • parameters

    Optional. Parameters to be used when retrieving data for a parameterized Linked Table. When including AF Table parameters, the names must start with '@' such as '@StartTime'. Any parameters provided that are not configured for the table are ignored. If parameters configured for the table are not submitted, the configured default values are used. See Dictionary Parameters for more information.

  • selectedFields

    List of fields to be returned in the response, separated by semicolons (;). If this parameter is not specified, all available fields will be returned. See Selected Fields for more information.

Status Codes

200: The data for the specified table.

Sample Response Body

{
  "Columns": {
    "Model": "String",
    "4WD": "Boolean",
    "TopSpeed": "Int32"
  },
  "Rows": [
    {
      "Model": "CarModel1",
      "4WD": true,
      "TopSpeed": 100
    },
    {
      "Model": "CarModel2",
      "4WD": false,
      "TopSpeed": 80
    }
  ]
}
In This Topic
TitleResults for “How to create a CRG?”Also Available in