1 About This Guide

This guide describes how to create an integration flow to fetch all in-progress activities across all projects within a workspace in Oracle Primavera Cloud.

This integration uses the Oracle Primavera Cloud Data Service REST API Adapter to fetch the in-progress activities from all projects in a workspace. After the activities are fetched, the output data from the Oracle Primavera Cloud Data Service API is saved in a file. This file is then stored at a Secure File Transfer Protocol (SFTP) location.

This integration requires two connections: an Oracle Primavera Cloud Data Service connection and an SFTP connection. The connection to the Oracle Primavera Cloud Data Service is established through the REST Adapter, while the connection to the SFTP service is established through the FTP Adapter in Oracle Integration.

The process of fetching all in-progress activities across all projects within a workspace includes the following:

  • Creating an Oracle Primavera Cloud Data Service connection using the REST Adapter
  • Creating an SFTP connection using the FTP Adapter
  • Constructing a JSON request body for the runQuery() API
  • Creating an Oracle Primavera Cloud Data Service integration flow
  • Adding the required mappings