Getting Started with Oracle EPM REST APIs - Part 1: Use Postman To Test REST APIs

In Part 1 of the Getting Started with Oracle EPM REST APIs tutorial series, you will learn how to use Postman to test two EPM REST APIs :
1. Get REST API Versions for Planning
2. Get Applications

You will also learn how to download the code snippet to invoke the API and execute it in Windows PowerShell.

Connect with me
--------------------------

[manickams]

Great Video Arun. Kindly post more videos related to API

[cdawg]

This was fantastic! Thank you for posting!

[wilmerhernanvaleromolina]

Hi Arun, thanks for the video, I would like to know some video about scripts in groovy in order to refresh database in Oracle Cloud due to a tried to do it but it was not possible. I am using calc script. Thank you very much for your help.

[AGBDej]

Thank you. How was you able to find details on the service name, tenant name, service type and Dcx while logged into p6?

[juhiagarwal]

Hi Arun... Did you try automating it in java... I am getting connection timed out error while using rest assured... And surprisingly not getting this error while trying with postman... Any idea?

[prakashbhatylp]

Hi Arun, do we need to install any other softwares to run REST API jobs? I mean is Postman tool mandatory?

[jaikrishnapitti]

Hi Arun, Nice informative video, Can we create bulk sales orders at a time using rest api's or soap webservices?

[Katkootahmed]

Where are these APIs being stored from the EPM end? How will we be able to view them?

[MrPrateek]

Hi Arun, I'm trying to get data from planning as you did above and i seem to get an error 'You are not authorized to access the requested resource'. I seem to have systemadmin access and still getting forbidden error... any idea why?

[ManojSharma-egxz]

Hi Arun ! I have a requirement to extract the data from ARCS tables, for e.g. ARM_RECONCILIATIONS, and may be export it as csv and put it at some location so that I can load the csv in some database like ATP or MySQL.
I tried the option of calling the ARCS report REST API but that doesn’t give me the output in response, instead it emails the output as attachment hence I’m unable to automate the insertion of output into some target db.
I explored the epmautomate options for ARCS but could not find the command which can run the report or extract the data from table and download the file.
Basically I want to connect ARCS with Oracle Analytics Cloud and then run analysis on top of that but unfortunately OAC only supports connect with EPM planning, FCCS and tax reporting but not ARCS. So I’m looking for other options to automate the data extraction from ARCS at a frequency and then run my analysis on top of it.
Let me know if you can help me with your expertise. I’m new to ARCS.
Looking forward. Thanks in advance.

[chaitanyarawat]

I just started using Primavera


How could i extract tenant name, service name, service type and further...

Please help.... Request to audience also