Question: I have a JSON object which I want to flatten before exporting it to CSV. I'd like to use the flatten\_json module for this.

My JSON input looks like this:

```
{
    "responseStatus": "SUCCESS",
    "responseDetails": {
        "total": 5754
    },
    "data": [
        {
            "id": 1324651
        },
        {
            "id": 5686131
        },
        {
            "id": 2165735
        },
        {
            "id": 2133256
        }
    ]
}

```

Easy so far even for a beginner like me, but what I'm interesting in exporting is only the data array. So, I would think of this:

```
data_json = json["data"]
flat_json = flatten_json.flatten(data_json)

```

Which doesn't work, since data is an array, stored as a list in Python, not as a dictionary:

```
[
    {
        "id": 1324651
    },
    {
        "id": 5686131
    },
    {
        "id": 2165735
    },
    {
        "id": 2133256
    }
]

```

How should I proceed to feed the content of the data array into the flatten\_json function?

Thanks!

R.

Answer: 
A Virtual Machine that is part of the backend pool of a *Standard* (not Basic) Internal Load Balancer can not make outgoing connections to the Internet.

To make outgoing connections it is necessary to create a second Load Balancer with a public IP with the same backend pool and a dummy rule with a dummy probe. Once the rule is created then it will trigger the creation of an outbound SNAT.

<https://learn.microsoft.com/en-us/azure/load-balancer/load-balancer-outbound-connections#defaultsnat>
By default, Azure VM behind an Azure internal load balancer, that VM can access the internet, but you can't access it from internet.

If you want to access it, you can create a VM in that VM with a public IP address, use that VM work as jumpbox. Also you can assign a public IP address to that VM, then use that public IP address to access it.