View Supported Tables and Columns

The Oracle Primavera Cloud Data Service provides endpoints that return a list of currently supported database tables and columns. You should send a request to these endpoints to discover the types of application data you can retrieve using the data service. Each database table or column returned by the data service stores a particular piece of application data. For example, the SM_ACTIVITY table stores columns that contain activity data, such as ACTIVITY_NAME and ACTIVITY_TYPE. If you want to use the data service to extract activity names and types from the application, you can specify the SM_ACTIVITY table and the ACTIVTY_NAME and ACTIVITY_TYPE columns in your request body to the runquery endpoint.

The following data service endpoints return responses that list supported tables or columns. These requests use the GET method. You should send requests to these endpoints periodically to determine what application data is accessible.

tables endpoint:

https://<SERVER_URL>/data/rest/dataservice/tables

columns endpoint:

https://<SERVER_URL>/data/rest/dataservice/columns/<tablename>

Where:

• <SERVER_URL> is the server URL where Oracle Primavera Cloud is deployed. For example, primavera.oraclecloud.com.
• <tableName> is the name of a database table listed in the response of the tables endpoint. For example, SM_ACTIVITY. This value is case insensitive.