Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Read CSV line by Line, transform rows and pass data to SOAP API call — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Read CSV line by Line, transform rows and pass data to SOAP API call

Received Response
16
Views
1
Comments
edited Jul 3, 2021 10:49PM in Integration 1 comment

Content

We have incremental exports of data from Oracle EDM RestAPI.

The data is in the form of a CSV file to a staging area.

An example of CSV file rows....

Node Parent  Description Level AllowPosting
1000   Balance Sheet 1 Y
1001 1000 Total Assent 2 Y

OIC reads the CSV file via Oracle EDM restAPI.

Each row of data needs to be convert by column and passed to a DRM Web Service API call.

Below is an example of the output data passed to the DRM SOAP call. The SOAP API calls  these ActionItems.

ChangeProp DefaultCurrentVersion Entity 1000 Description Balance Sheet
ChangeProp DefaultCurrentVersion Entity 1000 Level 1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!