API URL 数据无法获取，状态码 401

huangapple
go评论139阅读模式
英文:

API URL data not able to fetch, status code 401

问题

我正在尝试从API URL获取数据到Excel文件中，nseindia api，这只是Nifty指数的OHLC值。

我已经创建了用于日期输入的变量。

我遇到了以下错误：

> 无法从URL获取数据：状态码：401

  1. import requests
  2. import pandas as pd
  3. import xlwings as xw
  5. def NseHistoricalData(index_type, from_date, to_date):
  6.     url = f"https://www.nseindia.com/api/historical/indicesHistory?indexType={index_type}&from={from_date}&to={to_date}"
  7.     headers = {
  8.         'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36',
  9.         'Referer': 'https://www.nseindia.com/',
  10.         'Accept-Language': 'en-US,en;q=0.9',
  11.         'Accept-Encoding': 'gzip, deflate, br'}
  12.     session = requests.Session()
  13.     response_session = session.get(url, headers=headers)
  15.     try:
  16.         if response_session.status_code == 200:
  17.             data = response_session.json()['data']['indexCloseOnlineRecords']
  18.             if data:
  19.                 # 提取所需的值
  20.                 eod_open_index_val = data[0]['EOD_OPEN_INDEX_VAL']
  21.                 eod_high_index_val = data[0]['EOD_HIGH_INDEX_VAL']
  22.                 eod_close_index_val = data[0]['EOD_CLOSE_INDEX_VAL']
  23.                 eod_low_index_val = data[0]['EOD_LOW_INDEX_VAL']
  25.                 # 打开Excel文件
  26.                 file_name = r"C:\Users\vhind\Desktop\a\Zerodha\Version_v0\Zerodha\NSE_data.xlsm"
  27.                 wb = xw.Book(file_name)
  28.                 sheet_name = "Main"
  30.                 # 将提取的值写入工作表
  31.                 wb.sheets[sheet_name].range('M8').value = eod_open_index_val
  32.                 wb.sheets[sheet_name].range('M9').value = eod_high_index_val
  33.                 wb.sheets[sheet_name].range('M10').value = eod_close_index_val
  34.                 wb.sheets[sheet_name].range('M11').value = eod_low_index_val
  36.                 # 保存对Excel文件的更改
  37.                 wb.save(file_name)
  39.                 print("已成功将历史数据写入工作表。")
  40.             else:
  41.                 print("未找到指定日期范围的数据。")
  42.         else:
  43.             print(f"无法从URL获取数据。状态码：{response_session.status_code}")
  44.     except Exception as e:
  45.         print(f"发生错误：{str(e)}")
  47. # 从Excel表格中读取日期范围
  48. file_name = r"C:\Users\vhind\Desktop\a\Zerodha\Version_v0\Zerodha\NSE_data.xlsm"
  49. wb = xw.Book(file_name)
  50. sheet_name = "Main"
  51. from_date = wb.sheets[sheet_name].range('C15').value
  52. to_date = wb.sheets[sheet_name].range('C16').value
  54. # 指定历史数据的指数类型（例如，NIFTY 50）
  55. index_type = "NIFTY%2050"
  57. # 调用函数以获取并写入历史数据
  58. NseHistoricalData(index_type, from_date, to_date)
英文:

I am trying to get data from the API URL to Excel file
[https://www.nseindia.com/api/historical/indicesHistory?indexType=NIFTY%2050&from=28-07-2023&to=28-07-2023][nseindia api]
it is just OHLC value for nifty index.

I have made variable to date input.
I am getting this error:

> Failed to fetch data from the URL: Status Code: 401

  1. import requests
  2. import pandas as pd
  3. import xlwings as xw
  5. def NseHistoricalData(index_type, from_date, to_date):
  6.     url = f"https://www.nseindia.com/api/historical/indicesHistory?indexType={index_type}&from={from_date}&to={to_date}"
  7.     headers = {
  8.         'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36',
  9.         'Referer': 'https://www.nseindia.com/',
  10.         'Accept-Language': 'en-US,en;q=0.9',
  11.         'Accept-Encoding': 'gzip, deflate, br'}
  12.     session = requests.Session()
  13.     response_session = session.get(url, headers=headers)
  15.     try:
  16.         if response_session.status_code == 200:
  17.             data = response_session.json()['data']['indexCloseOnlineRecords']
  18.             if data:
  19.                 # Extract the required values
  20.                 eod_open_index_val = data[0]['EOD_OPEN_INDEX_VAL']
  21.                 eod_high_index_val = data[0]['EOD_HIGH_INDEX_VAL']
  22.                 eod_close_index_val = data[0]['EOD_CLOSE_INDEX_VAL']
  23.                 eod_low_index_val = data[0]['EOD_LOW_INDEX_VAL']
  25.                 # Open the Excel file
  26.                 file_name = r"C:\Users\vhind\Desktop\a\Zerodha\Version_v0\Zerodha\NSE_data.xlsm"
  27.                 wb = xw.Book(file_name)
  28.                 sheet_name = "Main"
  30.                 # Write the extracted values to the sheet
  31.                 wb.sheets[sheet_name].range('M8').value = eod_open_index_val
  32.                 wb.sheets[sheet_name].range('M9').value = eod_high_index_val
  33.                 wb.sheets[sheet_name].range('M10').value = eod_close_index_val
  34.                 wb.sheets[sheet_name].range('M11').value = eod_low_index_val
  36.                 # Save the changes to the Excel file
  37.                 wb.save(file_name)
  39.                 print("Historical data has been written to the sheet successfully.")
  40.             else:
  41.                 print("No data found for the specified date range.")
  42.         else:
  43.             print(f"Failed to fetch data from the URL. Status Code: {response_session.status_code}")
  44.     except Exception as e:
  45.         print(f"An error occurred: {str(e)}")
  47. # Read the date range from the Excel sheet
  48. file_name = r"C:\Users\vhind\Desktop\a\Zerodha\Version_v0\Zerodha\NSE_data.xlsm"
  49. wb = xw.Book(file_name)
  50. sheet_name = "Main"
  51. from_date = wb.sheets[sheet_name].range('C15').value
  52. to_date = wb.sheets[sheet_name].range('C16').value
  54. # Specify the index type for historical data (e.g., NIFTY 50)
  55. index_type = "NIFTY%2050"
  57. # Call the function to fetch and write the historical data
  58. NseHistoricalData(index_type, from_date, to_date)

答案1

得分: 1

尝试在发送请求时使用API密钥。您可以从 https://scrapeops.io/app/register/proxy 创建一个免费帐户。

  1. import urllib
  3. def get_scrapeops_url(url):
  4.     API_KEY = 'YOUR_API_KEY'
  5.     payload = {'api_key': API_KEY, 'url': url}
  6.     proxy_url = 'https://proxy.scrapeops.io/v1/?' + urllib.parse.urlencode(payload)
  7.     return proxy_url
  9. def NseHistoricalData(index_type, from_date, to_date):
  10.     # url and headers
  11.     session = requests.Session()
  12.     response_session = requests.get(get_scrapeops_url(url), headers=headers)
  14.     # rest of the code
英文:

Try using an API Key when you make your request. You can create a free account from https://scrapeops.io/app/register/proxy

  1. import urllib
  2. def get_scrapeops_url(url):
  3. API_KEY = 'YOUR_API_KEY'
  4. payload = {'api_key': API_KEY, 'url': url}
  5. proxy_url = 'https://proxy.scrapeops.io/v1/?' + urllib.parse.urlencode(payload)
  6. return proxy_url
  7. def NseHistoricalData(index_type, from_date, to_date):
  8. # url and headers
  9. session = requests.Session()
  10. response_session = requests.get(get_scrapeops_url(url), headers=headers)
  11. # rest of the code

huangapple
  • 本文由 发表于 2023年7月31日 20:57:39
  • 转载请务必保留本文链接：https://go.coder-hub.com/76803865.html
  • excel
  • python
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定