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: