Quick script to read in a json file and export to CSV using Pandas.

cme_api_csv.py

from pandas import json_normalize
from pathlib import Path
import json

# place the .json file in the same dir as this script
p = Path(r'products.json')

# read json
with p.open('r', encoding='utf-8') as f:
    data = json.loads(f.read())

# Create the pandas data frame, dig in to the "_embedded key" this contains the products.
df = json_normalize(data['_embedded'], record_path='products')

# render the data frame to a CSV file
df.to_csv('results.csv', index=False, encoding='utf-8')

# See the pandas data frame
print(df)