Forum Discussion
Merge 2 queries directly from 2 API calls (without creating tables)
Hi,
I am trying to merge these 2 queries, but dont know the syntaxis, could you help me please?
let
Query1 = let
Source1 = Json.Document(Web.Contents("https://api-v2.intrinio.com/securities/AAPL/historical_data/52_week_high?frequency=daily&start_date=2018-01-01&end_date=2019-12-31&sort_order=desc&page_size=10000&api_key=xx=")),
Source2 = Json.Document(Web.Contents("https://api-v2.intrinio.com/securities/AAPL/historical_data/52_week_low?frequency=daily&start_date=2018-01-01&end_date=2019-12-31&sort_order=desc&page_size=10000&api_key=xx="))
in
Source1,
historical_data = Query1[historical_data],
#"Converted to Table" = Table.FromList(historical_data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"date", "value"}, {"date", "value"}),
#"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",{{"value", "High"}})
in
#"Renamed Columns"
let
Query2 = let
Source1 = Json.Document(Web.Contents("https://api-v2.intrinio.com/securities/AAPL/historical_data/52_week_high?frequency=daily&start_date=2018-01-01&end_date=2019-12-31&sort_order=desc&page_size=10000&api_key=xx=")),
Source2 = Json.Document(Web.Contents("https://api-v2.intrinio.com/securities/AAPL/historical_data/52_week_low?frequency=daily&start_date=2018-01-01&end_date=2019-12-31&sort_order=desc&page_size=10000&api_key=xx="))
in
Source2,
historical_data = Query1[historical_data],
#"Converted to Table" = Table.FromList(historical_data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"date", "value"}, {"date", "value"}),
#"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",{{"value", "Low"}})
in
#"Renamed Columns"
1 Reply
Hi Anonymous ,
Based on my test, We cannot call multi api at the same time. As in Power query, we can only get the data step by step. So, althought your code is ok, but you cannot get the excepted result. You can try to come up a new idea and add your comments there to make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
