Building Integration to Transform Data through Lookups in OIC

 https://ift.tt/3o4hfmx

UseCase: Data transformation on database column through rest payload

Table Script

CREATE TABLE xx_emp_job_description (

    id          NUMBER,

    first_name  VARCHAR2(100),

    last_name   VARCHAR2(100),

    desgination VARCHAR2(100)

)

{

  "id" : "",

  "FirstName" : "",

  "LastName" : "",

  "Designation" : ""

}

----------------------------------------------------------------------

{

"status":""

}

INSERT INTO XX_EMP_JOB_DESCRIPTION( ID,FIRST_NAME,LAST_NAME,DESGINATION) VALUES (#ID,#FIRSTNAME,#LASTNAME,#DESGINATION)