Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How to insert data in different REST response level to one ATP table in OIC?

Hi All,

As the following screenshot, I'd like to insert data the REST response data to a ATP table.

For this example, the response payload with one parent level 'item' and some child level.

I'd like to insert the phone data in child level into one table and insert the person_id and person number from parent level at the same time.

e.g., One person have 2 phones, then there will be two record in the table with same person id and person number while the phone number is different like:

person_id person_number phone_number

1 A1 1234567

1 A1 7654321

When I use the map in the screenshot it will duplicated the person id and person number like:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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