时间戳

首页 > 解决方案 > SeatGeek 刮擦证书问题

python - SeatGeek 刮擦证书问题

问题描述

我有以下代码曾经在我的旧计算机上工作，但现在我切换了笔记本电脑，它正在推动与 client_id 相关的证书问题。知道如何解决这个问题吗？

gameIds = [5316872]

url = 'https://seatgeek.com/rescraper/v2/listings'
headers = {'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36'}
writer = pd.ExcelWriter(final, engine='xlsxwriter')

tables = []
for gameId in gameIds:
    payload = {
    '_include_seats': '1',
    'client_id': 'MTY2MnwxMzgzMzIwMTU4',
    'id': '%s' %gameId,
    'sixpack_client_id': '93d1ab10-07dc-4482-bb89-b87c2b144e33'}
    
    jsonData = requests.get(url, headers=headers, params=payload).json()
    df = pd.json_normalize(jsonData['listings'])
    df.to_excel(writer, sheet_name=gameId)
    tables.append(df)
    print(gameId)

table = pd.concat(tables)

writer = pd.ExcelWriter(final, engine='xlsxwriter')
table.to_excel(writer, sheet_name='Tickets')
writer.save()
print('Done')

错误：

requests.exceptions.SSLError: HTTPSConnectionPool(host='seatgeek.com', port=443): Max retries exceeded with url: /rescraper/v2/listings?
_include_seats=1&client_id=MTY2MnwxMzgzMzIwMTU4&id=5316872&sixpack_client_id=93d1ab10-07dc-4482-bb89-b87c2b144e33 
(Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')))

标签： pythonselenium

解决方案

推荐阅读