Python for loop API request

Question

I am extracting data from this API I was able to save the JSON file on my local machine. I want to run the requests for several stocks. How do I do it? I tried to play with for loops but not good came out of this. I attached the code below. the out put is:

AAPL
[]
TSLA
[]

Thank you, Tal

try:
# For Python 3.0 and later
from urllib.request import urlopen
except ImportError:
# Fall back to Python 2's urllib2
from urllib2 import urlopen
import requests
import json
import time


def get_jsonparsed_data(url):
"""
Receive the content of ``url``, parse it as JSON and return the object.

Parameters
----------
url : str

Returns
-------
dict
"""
stock_symbol = ["AAPL","TSLA"]
for symbol in stock_symbol:
print (symbol)
#Sending the API request
r = requests.get('https://financialmodelingprep.com/api/v3/income-statement/symbol={stock_symbol}?limit=120&apikey={removed by me})
packages_JSON = r.json()
print(packages_JSON)
#Exporting the data into JSON file
with open('stocks_data321.json', 'w', encoding='utf-8') as f: 
    json.dump(packages_JSON, f, ensure_ascii=False, indent=4)

Try copy the url in your get request, paste it in the browser and see if you get a response. If yes, instead of r.json(), do r.text If you want async support to query multiple api at the same time, use aiohttp. python3 only. — collinsuz
– collinsuz, Commented Mar 12, 2021 at 10:02
Does this answer your question? Python requests with multithreading — Stan Reduta
– Stan Reduta, Commented Mar 12, 2021 at 10:10

Stan Reduta · Accepted Answer · 2021-03-12 10:07:41Z

1

Querying multiple APIs iterativelly will take a lot of time. Consider using theading or AsyncIO to do requests simultaniously and speed up the process.

In a nutshell you should do something like this for each API:

import threading

for provider in [...]:  # list of APIs to query
    t = threading.Thread(target=api_request_function, args=(provider, ...))
    t.start()

However better read this great article first to understand whats and whys of threading approach.

edited Mar 12, 2021 at 10:07

answered Mar 12, 2021 at 9:59

Stan Reduta

3,5225 gold badges34 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python for loop API request

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related