JMJ CLOUD
  • Home
  • Projects
  • Blog
  • About Us
  • Contact Us

Our Blog

PPM Cloud REST API - Assigning Team Members using cURL

6/6/2017

0 Comments

 

Overview

This article will show you how to use the PPM Cloud REST API, illustrating how it can used to automate a manual task.

One of the challenges in Oracle PPM is maintaining worker assignments to projects - with a small number of workers and a handful of projects, this is simple, but can more onerous in larger organizations.

The PPM REST API allows you to assign workers to projects from the command line.  This gives the potential to script multiple updates,  saving time navigating in and out of each project’s team member list to perform manual assignments.

Getting Started

The first thing required is an ERP Cloud user account with the "Projects Integration Specialist" role - this allows the PPM REST APIs to be called. 

You will also need the base URL for your cloud instance, which is in the form:

    https://<pod>.prj.<region>.oraclecloud.com:443

For example, if your pod is abcd-dev1, and the region is em3 then the base url is:

    https://abcd-dev1.prj.em3.oraclecloud.com:443

We will use URL in the examples below.


Retrieving The Project Id

The Team Members REST API is driven by the Project Id and not the Project Number or Project Name.   So if we want to assign someone to project 1100100, we need to know Oracle’s internal ID for this project.  
​
One way to find this out would be to use Oracle BI Publisher to create a custom Data Model with a simple SQL statement such as:
SELECT project_id
,      segment1           project_number
FROM   pjf_projects_all_v
WHERE  segment1 = '1100100';

When run, this would return the Project Id and Project Number.
​

Alternatively, sticking to our theme of running from the command line, we can use the PPM REST web service to do the same thing.  To call a REST web service from the command line, we’ll use cURL.   ​

The Projects GET URL is constructed from the following elements:
Picture

These are then used in the cURL command below.
curl --user USERNAME:PASSWORD -X GET \
"https://abcd-dev1.prj.em3.oraclecloud.com:443/projectsFinancialsApi/resources/latest/projects?fields=ProjectId,ProjectNumber&onlyData=true&limit=50&q=ProjectNumber=1100100"

This gives returns the Project Id for the Project Number.

Read More
0 Comments

    RSS Feed

    Popular Posts

    - APEX Dog Food
    - Cloud ERP & APEX Mashup
    - Modernizing EBS with APEX
    - Easy APEX_WEB_SERVICE
    - Running APEX in RDS
    - ORDS What & Why?

    Categories

    All
    APEX
    AWS
    Fusion Cloud ERP
    INTEGRATION
    MS GRAPH
    OCI
    ORDS
    PaaS
    RAD
    REST
    SOAP

    Archives

    October 2021
    February 2021
    January 2021
    October 2020
    September 2020
    June 2020
    May 2020
    April 2020
    February 2020
    January 2020
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    September 2017
    August 2017
    July 2017
    June 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016

Company

About
Contact
Blog
  • Home
  • Projects
  • Blog
  • About Us
  • Contact Us