Nest JSON - id as column name, value as value
#### Code Sample, a copy-pastable example if possible
JSON example
```
{
    "tickets": [
        {
            "url": "https://domain.zendesk.com/api/v2/tickets/10001.json",
            "id": 10001,
            "custom_fields": [
                {
                    "id": 360007982393,
                    "value": "Some Value"
                },
                {
                    "id": 360008063134,
                    "value": "Foo"
                },
                {
                    "id": 360007982273,
                    "value": "Bar"
                },
                {
                    "id": 360007982293,
                    "value": null
                }
            ],
            "satisfaction_rating": null
        },
        {
            "url": "https://domain.zendesk.com/api/v2/tickets/10002.json",
            "id": 10002,
            "custom_fields": [
                {
                    "id": 360007982393,
                    "value": "Another value"
                },
                {
                    "id": 360008063134,
                    "value": "Bar"
                },
                {
                    "id": 360007982273,
                    "value": "Foo"
                },
                {
                    "id": 360007982293,
                    "value": null
                }
            ],
            "satisfaction_rating": null
        }
    ],
    "count": 2,
    "next_page": "https://domain.zendesk.com/api/v2/incremental/tickets.json?start_time=1541167467",
    "end_time": 1541167467
}
```

```
DATA = requests.request("GET", url, headers=headers)
jdata = json.loads(DATA.content.decode('utf8'))

tickets_json = jdata['tickets']
result = json_normalize(data=tickets_json, sep='_')

df=pd.DataFrame(result)

```


#### Query description
So with the above, I get a dataframe that comes out as:
url, id, custom_fields, satisfaction_rating

Custom_Fields is where I am struggling, as I need to get:
url, id, custom_fields_360007982393,custom_fields_360008063134,custom_fields_360007982273,custom_fields_360007982293, satisfaction_rating

Or similar to the above, as effectively I need the id's from within the custom values to part of or become the names of the columns in the main dataframe.

I have tried to use the record_path with meta, but this flips the data frame into an unusable format for what I am trying to achieve here.  I tried pulling out custom_fields and then appending it back, but all I could find was to just have a random number as the column name and then just have the same id, value pair as the value on each row.

This data will get imported into MySQL.