the output of the table will have 200-300 rows (scenarios) and a column called Scenario_API_URL stores the string which is URL address for the nested API call which will return details about the selected scenario.
I wrote a function called scenariograbber
Source = Csv.Document(Web.Contents(url, [Headers=[Authorization="Token token=""xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"""]]))
which it will return the result if I invoke the function manually and enter one of the URLs retruned by the first result set.
I want to combaine all the sub API calles as one table!