Read CSV line by Line, transform rows and pass data to SOAP API call
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
0