Instrument key from json file

Instrument = pd.read_json(‘https://assets.upstox.com/market-quote/instruments/exchange/NSE.json.gz’)
Instrument

Error show

URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)>

@ANAND_1674204 This issue seems to be specific to your local environment. This error occurs when the pandas library attempts to read data from “https://assets.upstox.com” but fails to verify the SSL certificate. The system is unable to retrieve the local issuer certificate, indicating that your machine is either missing the required root Certificate Authority (CA) or unable to verify it.

If your system is missing root certificates, try below and let me know if it works, Thanks

pip install --upgrade certifi
1 Like

pip install --upgrade certifi

Requirement already satisfied: certifi in [c:\users\anand\appdata\local\programs\python\python312\lib\site-packages](file:///C:/users/anand/appdata/local/programs/python/python312/lib/site-packages) (2024.7.4)Note: you may need to restart the kernel to use updated packages. Collecting certifi Downloading certifi-2025.1.31-py3-none-any.whl.metadata (2.5 kB) Downloading certifi-2025.1.31-py3-none-any.whl (166 kB) Installing collected packages: certifi Attempting uninstall: certifi Found existing installation: certifi 2024.7.4 Uninstalling certifi-2024.7.4: Successfully uninstalled certifi-2024.7.4 Successfully installed certifi-2025.1.31

[notice] A new release of pip is available: 24.2 → 25.0.1 [notice] To update, run: python.exe -m pip install --upgrade pip

import pandas as pd

stock = ‘IRFC’

Instrument = pd.read_json(‘https://assets.upstox.com/market-quote/instruments/exchange/NSE.json.gz’)

#InstrumentKey = Instrument[Instrument[‘tradingsymbol’] == stock]

#InstrumentKey

Instrument

URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)>