Python read json data from API

import pandas as pd

import requests

d = requests.get("https://www.yourwebsite.com/controller?ApiKey=value").json()

df = pd.DataFrame.from_dict(d['records'])

df.shape