Add an Invoke for Oracle Primavera Cloud Data Service

To fetch all in-progress activities from all projects across a workspace, add the Oracle Primavera Cloud Data Service connection to the integration. When you drag the adapter into the invoke area of an integration, the adapter endpoint configuration wizard appears. This wizard guides you through the configuration of the adapter endpoint properties.

To add an invoke:

  1. On the integration page, hover over an arrow and click the icon.
  2. From the list of available connections, select the Primavera Cloud Data Service connection.
  3. In the adapter endpoint configuration wizard, complete the following steps:
    1. Basic Info Page:
      1. What do you want to call your endpoint?: Enter runQuery.

        Note: Provide a meaningful name so that others can understand the purpose of this connection. You can include English alphabetic characters, numbers, underscores, and hyphens in the name. You cannot include blank spaces, special characters, or multibyte characters.

      2. What does this endpoint do?: Enter Runs a query against the Primavera Cloud Data Service runQuery endpoint.
      3. What is the endpoint's relative resource URI?: Enter /dataservice/runquery/.
      4. What action do you want to perform on the endpoint?: Select POST.
      5. Select the Configure a request payload at this endpoint and Configure this endpoint to receive a response check boxes.
    2. Request Page:
      1. From the Select the request payload format drop-down list, select JSON sample, and then enter the following sample JSON.
    {
    "name": "Project Activity",
    "pageSize": "10",
    "nextTableName": "SM_ACTIVITY",
    "tables": [
        {
            "tableName": "SM_ACTIVITY",
            "columns": [
                "ACTIVITY_NAME",
                "ACTIVITY_CODE",
                "PROJ_ID",
                "STATUS"
            ],
            "condition": {
                "operator": "AND",
                "conditions": [
                    {
                        "columnName": "STATUS",
                        "operator": "EQUALS",
                        "value1": "IN_PROGRESS"
                    },
                    {
                        "columnName": "PROJ_ID",
                        "operator": "IN",
                        "val-ue1": "(SELECT PROJ_ID FROM CO_PROJECT PROJ, WS_WORKSPACE WS WHERE PROJ.WORKSPACE_ID=WS.WORKSPACE_ID AND WS.NAME='OICWS')"
                    } ]            }
        } ]
}
    1. Response Page:
      1. From the Select the response payload format drop-down list, select JSON sample, and then enter the following sample JSON.
    {
    "data": {
        "SM_ACTIVITY": [
            {
                "ACTIVITY_NAME": "Act1",
                "ACTIVITY_CODE": "A1000",
                "PROJ_ID": "124101",
                "STATUS": "IN_PROGRESS
            }
        ],
        "pagination": [
            {
                "nextTableName": "-1",
                "queryName": "Inprogress Activities",
                "nextKey": "0",
                "rowCount": "8",
                "sinceDate": "20230720T142903.000Z"
            }
        ],
        "safetyDate": [
            {
                "queryName": "Inprogress Activities",
                "sinceDate": "20230720T142903.000Z"
            }
        ],
        "tableList": [
            {
                "rowCount": "2",
                "tableName": "SM_ACTIVITY"
            }
        ]
    }
}
    1. Summary Page:
      1. View the summary and click Finish.
  4. Click Save.

Last Published Tuesday, November 28, 2023