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.

		http://<host>:<port>/data/rest/dataservice/tables
		

		http://<host>:<port>/data/rest/dataservice/columns/<tableName>
		

The variables in the previous examples should be replaced with the following information:

• <host>: The name of the host on which the application is deployed. This is the URL for the Oracle Primavera Cloud application.
• <port>: The port number assigned to the application on the application host. The port is either included in the URL or is not required.
• <tableName>: The name of a database table listed in the response of the tables endpoint. For example, SM_ACTIVITY. This value is case insensitive.