How Can I Upsert an array of objects by straming h… – Adobe Experience League Community

Hi,

 

{

    “tenant”: {

        “cardDetails”: [

            {

                “cardId”: “30”,

                “cardNumber”: “30”,

                “status”: “ativo00s”

            }

        ],

        “cardsList”: [

            {

                “cardId”: “100”,

                “cardNumber”: “500”,

                “status”: “ativo0”

            }

        ],

        “identities”: {

            “myId”: “Marcelo”

        }

    }

}

 

I have this schema, i have it enabled for profile, also its dataset is enable for profile and upsert. 

I have tried data prep upsert_array_append but also no lucky.

 

All I want is to have an array of credit cards being upserted by streaming events.

 

cardId should be unique in the array.

 

can anyone please help me?