CODE EXAMPLE FOR PYTHON

json url to dataframe python

import requests
import pandas as pd

URL = 'http://some_address/some_file.json'
data = json.loads(requests.get(URL).text)

# Flattening JSON data
pd.json_normalize(data)