API calls for multiple parameter values, ingest to a single table

Connector Development
1

Hi everybody,

I’m very new to API and Building connector so sorry if any notation is wrong.

I’m tryinh to fetch stock prices daily and store them in a Postgres database. One of the required parameters are Stock symbol

An example:
stock/bars-long-term?ticker={symbol}&type=stock&resolution=D&from={start_time}&to={end_time}

Now what I want to do is to have a list of symbol like [‘ABC’, ‘DEF’, ‘GHI’] and my stream will fetch the data from url with the corresponding symbol, then store them in a single Postgres table

Like this:
stock-insight/v1/stock/bars-long-term?ticker=ABC&type=stock&resolution=D&from=1649955600&to=1650560400
stock-insight/v1/stock/bars-long-term?ticker=DEF&type=stock&resolution=D&from=1649955600&to=1650560400
stock-insight/v1/stock/bars-long-term?ticker=GHI&type=stock&resolution=D&from=1649955600&to=1650560400

Since there are thousands of symbol to cover so i can’t create separate streams for each of them, is there anyway I can’t achieve it with a single stream?

Thank you in advance!