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 these endpoints to discover which database tables and columns are accessible and run queries against them. You can create JSON objects to specify database queries and submit them using the data 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://<SERVER_URL>/data/rest/dataservice/<endpoint>

Where:

• <SERVER_URL> is the server URL where Oracle Primavera Cloud is deployed. For example, primavera.oraclecloud.com.
• <endpoint> is 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 https://<SERVER_URL>/data/rest/dataservice/tables \
-H "Authorization: Bearer <OAuth-Access-Token>" \
-H "x-prime-tenant-code: <tenant-code>" \
-H "<x-param1>: <param1-value>" \
-H "<x-param2>: <param2-value>" \
-H "<x-paramN>: <paramN-value>"

Note:

For more information about using curl to send requests to the Data Service, see curl Examples.