Forum Discussion

SebbyP333's avatar
SebbyP333
Helper I
4 years ago
Solved

How to use an API string with reference to a dynamic table column?

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 url in red, bold and underlined is the stock code a...
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Super User
4 years ago

SebbyP333 create a list of stock codes as you mentioned, and then create a function and pass stock code as the parameter, and in the function use function parameter to create the API string, let's call it GetSourceCodeData

 

 

(stockcode) =>
let
  Source = "https://eodhistoricaldata.com/api/eod/" & stockcode & "?from=2006-01-05&period=d&fmt=json&api_token=OeAFFmMliFG5orCUuwAKQ8l4WWFQ67YX"
in
  Source

 

 

in the source code table add a new column:

 

 

GetSourceCodeData([SourceCodeColumn])

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡