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 opens. This wizard guides you through the configuration of the adapter endpoint properties.

To add the invoke:

  1. On the integration page, hover over an arrow and click Add Add icon.
  2. From the Available connections list, select Oracle Primavera Cloud Data Service Connection.
  3. In the Adapter Endpoint Configuration Wizard, do the following:
    1. On the Basic Info page:
      1. In the What do you want to call your endpoint? field, enter runQuery.

      2. In the What does this endpoint do? field, enter an optional description.

        For example: Runs a query against the Oracle Primavera Cloud Data Service runQuery endpoint.

      3. In the What is the endpoint's relative resource URI? field, enter /dataservice/runquery/.
      4. From the What action do you want to perform on the endpoint? list, select POST.
      5. Select the Configure a request payload at this endpoint and Configure this endpoint to receive a response check boxes.
    2. On the Request page:
      1. From the Select the request payload format list, select JSON sample, and then enter the following JSON sample:
        {
            "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')"
                            } ]            }
                } ]
        }
    3. On the Response page:
      1. From the Select the response payload format list, select JSON sample, and then enter the following JSON sample:
        {
            "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"
                    }
                ]
            }
        }
    4. On the Summary page, view the summary and click Finish.
  4. Click Save.