Google开发人员工具的JSON链接在Python（或浏览器中）不起作用

Question

我正在尝试在表中提取 https：// www。 ecoregistry.io/emit-certifications/ra/10

使用Google开发人员工具＆gt;网络选项卡，我能够获取该表数据的JSON链接： https://api-front.ecoregront.ecoregistry.io/api/api/api/project/project/project/10/ememitcertificationation < /a>

我能够手动复制此JSON数据并使用我编写的此代码提取信息：

import json
import pandas as pd
data = '''PASTE JSON DATA HERE'''
info = json.loads(data)
columns = ['# Certificate', 'Carbon offsets destination', 'Final user', 'Taxpayer subject','Date','Tons delivered']
dat = list()
for x in info['emitcertifications']:
dat.append([x['consecutive'],x['reasonUsingCarbonOffsets'],x['userEnd'],x['passiveSubject'],x['date'],x['quantity']])
df = pd.DataFrame(dat,columns=columns)
df.to_csv('Data.csv')

我想自动化它，以便可以从JSON链接中提取数据： https://api-front.ecoregront.ecoregistry.io/api/api/api/project/project/project/10/ememitcertificationation < /a> 直接而不是手动粘贴JSON数据：

data = '''PASTE JSON DATA HERE'''

该链接在Python中甚至直接在浏览器中工作：

import requests
import json
url = ('https://api-front.ecoregistry.io/api/project/10/emitcertifications')
response = requests.get(url)
print(json.dumps(info, indent=4))

我收到的错误输出是： {'状态'：0，'codemessages'：[{'codemessage'：'error_401'，'param'：'nivalid'，'message'：'no autorizado'}]}}

当我从开发人员工具下载数据时，然后该词典具有“状态”：1之后，所有数据都在那里。

编辑：我尝试将请求标头添加到URL中，但仍然没有起作用：

import requests
import json
url = ('https://api-front.ecoregistry.io/api/project/10/emitcertifications')
hdrs = {"accept": "application/json","accept-language": "en-IN,en;q=0.9,hi-IN;q=0.8,hi;q=0.7,en-GB;q=0.6,en-US;q=0.5","authorization": "Bearer null", "content-type": "application/json","if-none-match": "W/\"1326f-t9xxnBEIbEANJdito3ai64aPjqA\"", "lng": "en", "platform": "ecoregistry","sec-ch-ua": "\" Not A;Brand\";v=\"99\", \"Chromium\";v=\"100\", \"Google Chrome\";v=\"100\"", "sec-ch-ua-mobile": "?0", "sec-ch-ua-platform": "\"Windows\"", "sec-fetch-dest": "empty","sec-fetch-mode": "cors", "sec-fetch-site": "same-site" }
response = requests.get(url, headers = hdrs)
print(response)
info = response.json()
print(json.dumps(info, indent=4))

打印（响应）将输出作为'＆lt;响应[304]＆gt;'当info = wendment.json（）给出追溯错误'期望值：第1行1（char 0）'

有人可以指向我的方向正确吗？

提前致谢！

Answer 1

发表评论作为答案：

该API所需的标题才能检索数据
是平台：生态学。

import requests as req
import json
req = req.get('https://api-front.ecoregistry.io/api/project/10/emitcertifications', headers={'platform': 'ecoregistry'})
data = json.loads(data)
print(data.keys())
# dict_keys(['status', 'projectSerialYear', 'yearValidation', 'project', 'emitcertifications'])
print(data['emitcertifications'][0].keys())
# dict_keys(['id', 'auth', 'operation', 'typeRemoval', 'consecutive', 'serialInit', 'serialEnd', 'serial', 'passiveSubject', 'passiveSubjectNit', 'isPublicEndUser', 'isAccept', 'isCanceled', 'isCancelProccess', 'isUpdated', 'isKg', 'reasonUsingCarbonOffsetsId', 'reasonUsingCarbonOffsets', 'quantity', 'date', 'nitEnd', 'userEnd'])