Thanks for your message.
We have recently added support for the GOES 16 and 17 X-ray data in sunpy which will be available in our 2.1 release (scheduled in the next few weeks).
In the meantime, if you want you can use the development version of sunpy (details are described
here), the functionality to query and download the new GOES data and read the files into a `sunpy.timeseries.TimeSeries` is available there.
However if you are just looking for the 1m data from the NOAA site as shown, the recent json files can be read through something like:
import pandas as pd
from astropy import units as u
from sunpy import timeseries as ts
from sunpy.time import parse_time
from collections import OrderedDict
noaa_file = "
https://services.swpc.noaa.gov/json/goes/primary/xrays-7-day.json"
units = OrderedDict([('xrsa', u.W/u.m**2),
('xrsb', u.W/u.m**2)])
data = pd.read_json(noaa_file)
data_short = data[data['energy']=='0.05-0.4nm']
data_long = data[data['energy']=='0.1-0.8nm']
time_array = [parse_time(x).datetime for x in data_short['time_tag'].values]
df = pd.DataFrame({'xrsa': data_short['flux'].values, 'xrsb': data_long['flux'].values}, index=time_array)
df.sort_index(inplace=True)
goes_data = ts.TimeSeries(df, units, source="xrs")