I have connected to a REST API and the data is structured in a nested JSON format that requires some transformation before I can insert into a SQL table. I am trying to use Azure Data Factory (Copy into) to facilitate the transformation.

Each UserID is an Object, so when I try to map the fields, it gives me an error that I have duplicate field mappings.
[see screenshot of mapping](https://i.stack.imgur.com/p3YMR.png)

I do not know how to trim off the unnecessary data. This is what it looks like:

```
 {
    "count": 216,
    "results": [
        {
            "key": "users",
            "id": "18603444"
        },
        {
            "key": "users",
            "id": "18603297"
        },
        {
            "key": "users",
            "id": "18603298"
        },
        {
            "key": "users",
            "id": "18603445"
        },
        {
            "key": "users",
            "id": "16407315"
        },
        {
            "key": "users",
            "id": "18636176"
        },
        {
            "key": "users",
            "id": "18588630"
        },
        {
            "key": "users",
            "id": "18588941"
        },
        {
            "key": "users",
            "id": "18603301"
        },
        {
            "key": "users",
            "id": "18603302"
        },
        {
            "key": "users",
            "id": "18603303"
        },
        {
            "key": "users",
            "id": "18588634"
        },
        {
            "key": "users",
            "id": "18722305"
        },
        {
            "key": "users",
            "id": "18603446"
        },
        {
            "key": "users",
            "id": "18604710"
        },
        {
            "key": "users",
            "id": "18624916"
        },
        {
            "key": "users",
            "id": "18625925"
        },
        {
            "key": "users",
            "id": "18603447"
        },
        {
            "key": "users",
            "id": "18603448"
        },
        {
            "key": "users",
            "id": "18603305"
        }
    ],
    "users": {
        "18603444": {
            "full_name": "",
            "photo_path": "",
            "email_address": "",
            "headline": "",
            "generic": false,
            "disabled": false,
            "update_whitelist": [
                "full_name",
                "headline",
                "email_address",
                "external_reference",
                "linkedin_url",
                "bio",
                "website",
                "company_name",
                "address1",
                "address2",
                "city",
                "state",
                "zip"
            ],
            "account_id": "",
            "id": "18603444"
        },
  "18603302": {
            "full_name": "",
            "photo_path": "",
            "email_address": "",
            "headline": "",
            "generic": false,
            "disabled": false,
            "update_whitelist": [
                "full_name",
                "headline",
                "email_address",
                "external_reference",
                "linkedin_url",
                "bio",
                "website",
                "company_name",
                "address1",
                "address2",
                "city",
                "state",
                "zip"
            ],
            "account_id": "7600865",
            "id": "18603302"
        },
  "18603303": {
            "full_name": "",
            "photo_path": ",
            "email_address": "",
            "headline": "",
            "generic": false,
            "disabled": false,
            "update_whitelist": [
                "full_name",
                "headline",
                "email_address",
                "external_reference",
                "linkedin_url",
                "bio",
                "website",
                "company_name",
                "address1",
                "address2",
                "city",
                "state",
                "zip"
            ],
            "account_id": "7600865",
            "id": "18603303"
        },
    "meta": {
        "count": 216,
        "page_count": 11,
        "page_number": 1,
        "page_size": 20
    }}

```

Each user is structured with their ID and their respective data. I want to remove the first part with the count and results and the last part with the meta and ONLY keep the data in each ID object. I think i can delete those two pieces in the mapping of the Copy into step, but I am not sure the best practice.

How do I do this with Azure Data Factory and SQL? Or should I use an Azure Function? I am not allowed to use python or any other scripting (if it is possible). Can someone please assist?