How to make an API call which replaces a part in the key and automatically references a table column

[SebbyP333]

Hello Power BI Forum,

I have the following API url to pull in stock price data using the web function on Power BI Desktop.  The part of the API key in red, bold and underlined is the stock code and you can only have one stock code called at a time.  I would like to have a seperate table with a complete list of my stock codes and then automatically replace the stock code in the API key to the list i have created.

https://eodhistoricaldata.com/api/eod/MCD.US?from=2006-01-05&period=d&fmt=json&api_token=

Any advice on how to do this would be much appreciated.

[v-yalanwu-msft]

Hi, @SebbyP333 ;

As far as I know,
1. You can try it in a Power Query
2. Refer to the following link.

https://zappysys.com/blog/howto-import-json-rest-api-power-bi/?gclid=EAIaIQobChMI0NTF4Ofp9AIVNZlmAh1...

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.