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

Extract json output in Integration Cloud

edited Apr 14, 2020 5:46AM in Integration 5 comments

Content

Hi Experts,

There is API which sends the json response. The json response contains the json keys are dynamic as below:

"custom_fields": {
        "100147": {
            "updated_at": "2019-05-14T08:23:21-07:00",
            "created_at": "2016-01-15T14:38:40-08:00"
},
        "100197": {
            "updated_at": "2019-05-14T08:23:43-07:00",
            "created_at": "2016-01-15T14:39:41-08:00"},
        "100307": {
            "updated_at": "2019-05-14T08:25:59-07:00",
            "created_at": "2016-01-15T14:55:36-08:00"
   }
  }

Notice the bold values, these are dynamic in nature and wanted to extract the updated_at and created_at values from all nodes.

Can we achieve the same in Oracle Integration if yes please guide.

Regards,

Ankur

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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