1. Get StartedOracle Primavera Cloud Data Service API
  2. Oracle Primavera Cloud Data Service Introduction

Oracle Primavera Cloud Data Service Introduction

The Oracle Primavera Cloud Data Service exposes a set of endpoints that enable you to extract data from the application database. You can use the data service endpoint to discover which database tables and columns are accessible and run queries against them. Create JSON objects to specify database queries and submit them using the service's runquery endpoint. Upon processing a POST request and resolving a query, the runquery endpoint returns a JSON object containing application data that satisfies the query specified in the request body. You can use the JSON data returned by the service to analyze your application data.

Accessing the Data Service

The data service uses a different base URL than other API services. To access the data service send requests to the following base URL:

https://<host>:<port>/data/rest/dataservice/<endpoint>

The variables in the previous example URL should be replaced with the following information when accessing the data service:

  • <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.
  • <endpoint>: A valid data service endpoint, excluding the data service base URL. For example, runquery.

Example curl Request

The following example demonstrates accessing the data service tables endpoint using curl:

curl -X GET -H "Accept:application/json" -u "<username>:<password>" https://<host>:<port>/data/rest/dataservice/tables

The variables in the previous example should be replaced with the following information when accessing the data service:

  • <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.
  • <username>: The username of an application user. This user will be used to access the data service and must be assigned the application administrator privilege to access application data. For example, jsmith.
  • <password>: The password associated with the user account used to access the data service.