azure sql database – Dynamically update filed value in ADF Copy activity

I am trying to perform copy activity in ADF. Source for the pipeline is API(Json response) and Sink is Azure Sql data base.

I want to check, if the enddat is null then only i have take name field and map to sink column. Kindly note that i am using copy activity not data flow.

Response from API is in below format:

[
{
        "id": "8d6c",
        "customsiteid": "wew",
        "country": "US",
        "state": "CA",
        "city": "San Jose",
        "sampleIds": [
            {
                "name": "klio",
                "acceptedat": "2016-02-02T00:00:00.000Z",
                "enddat": null
            },
            {
                "name": "jkdsjks",
                "acceptedat": "2011-12-23T00:00:00.000Z",
                "enddat": "2016-01-26T00:00:00.000Z"
            }
        ]
    },
    {
        "id": "kjkj",
        "customsiteid": "iuewi",
        "country": "UK",
        "state": "Na",
        "city": "Mnv",
        "sampleIds": [
            {
                "name": "asa",
                "acceptedat": "2017-02-02T00:00:00.000Z",
                "enddat": "2019-01-26T00:00:00.000Zx"
            },
            {
                "name": "wer",
                "acceptedat": "2021-12-23T00:00:00.000Z",
                "enddat": null
            }
        ]
    }
    ]

Please let me know the approach to achieve this scenario.

Read more here: Source link