Endpoints Available for the P6 Reporting User Configuration Name for OCI
The endpoints described below are examples and you must modify them before you can use them. You must replace the text <customer> with your customer identifier. You must replace the text <data_center> with the code for your data center. For the columns endpoint, you must replace the text <table_name> with the name of the table you want to query.
Production environment:
Metadata Tables Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/pds/rest-service/dataservice/metadata/tables?configCode=ds_p6reportuser
Metadata Columns Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/pds/rest-service/dataservice/metadata/columns/<table_name>?configCode=ds_p6reportuser
Metadata Refresh Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/pds/rest-service/dataservice/metadata/refresh?configCode=ds_p6reportuser
Metadata Refresh Status Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/pds/rest-service/v1/config/status/seed?configCode=ds_p6reportuser
Runquery Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/pds/rest-service/dataservice/runquery?configCode=ds_p6reportuser
Stage environment:
Metadata Tables Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/stage/pds/rest-service/dataservice/metadata/tables?configCode=ds_p6reportuser
Metadata Columns Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/stage/pds/rest-service/dataservice/metadata/columns/<table_name>?configCode=ds_p6reportuser
Metadata Refresh Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/stage/pds/rest-service/dataservice/metadata/refresh?configCode=ds_p6reportuser
Metadata Refresh Status Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/stage/pds/rest-service/v1/config/status/seed?configCode=ds_p6reportuser
Runquery Endpoint
- https://<data_center>.p6.oraclecloud.com/<customer>/stage/pds/rest-service/dataservice/runquery?configCode=ds_p6reportuser