insert mutiple rows in to a view table

[prashanthi1]

Hi,

I am able to do insert in to a single view table made out of multiple source tables by update procedures.

for the below request:

{

"table1Field":"table1Value",

"table2Field":"table2Value"

}

My insert query is :

FOR EACH ROW

BEGIN ATOMIC

  INSERT INTO OracleConn.table1 (OracleConn.table1.table1Field) VALUES ("NEW".table1Field);

  INSERT INTO OracleConn.table2(OracleConn.table2.table2Field) VALUES ("NEW".table2Field);

END

If i have multiple rows for table 2 like the below request:

{

    "table1Field": "table1Value",

    "table2": [

        {

            "table2Field": "table2Value1"

        },

        {

            "table2Field": "table2Value2"

        }

    ]

}

How to insert the above data? Do i need to change my view?

Thanks in advance,

Prashanthi.

[rareddy]

Can "table2Field" be an array on the view?

[prashanthi1]

how do i make it an array on the view? i am doing an inner join for select transformation, will my select also change?

[rareddy]

You can use "string[]" as the data type, and then your select transformation use "ARRAY_AGG" to create an array value.