Table GetData
- Last UpdatedJun 15, 2023
- 1 minute read
- PI System
- PI Web API Reference
- Developer
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
}
]
}