AssetDatabase GetTables

Retrieve tables for given Asset Database.

Request

GET assetdatabases/{webId}/tables

URL Parameters

• webId

  The ID of the database. See WebID 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.

• webIdType

  Optional parameter. Used to specify the type of WebID. Useful for URL brevity and other special cases. Default is the value of the configuration item "WebIDType". See WebID Type for more information.

Status Codes

200: The tables on the specified database.

Sample Response Body

{
  "Items": [
    {
      "WebId": "I1BlDqD5loBNH0erqeqJodtALAmLr4X86Jmkeynt3QVwlqXw",
      "Id": "5ff8ba98-89ce-479a-b29e-ddd057096a5f",
      "Name": "CarInfo",
      "Description": "Table of car info.",
      "Path": "\\\\MyAssetServer\\MyDatabase\\Tables[CarInfo]",
      "CategoryNames": [
        "Table Category"
      ],
      "TimeZone": "Eastern Standard Time",
      "ConvertToLocalTime": "false",
      "Links": {
        "Self": "https://localhost.osisoft.int/piwebapi/tables/I1BlDqD5loBNH0erqeqJodtALAmLr4X86Jmkeynt3QVwlqXw"
      }
    },
    {
      "WebId": "I1BlDqD5loBNH0erqeqJodtALAmLr4X86Jmkeynt3QVwlqXw",
      "Id": "5ff8ba98-89ce-479a-b29e-ddd057096a5f",
      "Name": "CarInfo",
      "Description": "Table of car info.",
      "Path": "\\\\MyAssetServer\\MyDatabase\\Tables[CarInfo]",
      "CategoryNames": [
        "Table Category"
      ],
      "TimeZone": "Eastern Standard Time",
      "ConvertToLocalTime": "false",
      "Links": {
        "Self": "https://localhost.osisoft.int/piwebapi/tables/I1BlDqD5loBNH0erqeqJodtALAmLr4X86Jmkeynt3QVwlqXw"
      }
    }
  ],
  "Links": {}
}