Hello,
I'm developing a Power BI connector which queries some api endpoints. The api endpoints are defined in multiple json files. The first input parameter shall take a url to a json file. In the next step a second input parameter is populated based on the first selection as a dropdown. To do so, I'd like to create two UI popups before calculating and showing the results in Power BI.
With this documentation https://docs.microsoft.com/en-us/power-query/handlingdocumentation it's a piece of cake to create a UI. However I fail miserably trying to chain both UIs together. I'm able to pass the values from the first UI to the second, however I only see the first UI. The second function isn't invoked and is only shown as a function info. It's still working but as the documentation suggests it's a better user experience showing a UI popup. I also prefer using a multiline multiselect UI in order to query multiple endpoints at once.
Is there any way to achieve my idea? It looks like it's support in Power Query given the fact, that querying a SQL Server also chains UI input fields together (first step: select database, second step: select table in database).
Here is my code:
[DataSource.Kind="Connector", Publish="Connector.Publish"]
shared Connector.Contents = Value.ReplaceType(FirstImpl, FirstType);
FirstType = type function(
url as (type text meta [
Documentation.Name = "text",
Documentation.FieldCaption = "Enter json schema url",
Documentation.FieldDescription = "Please enter a url to a json schema file.",
Documentation.SampleValues = {"https://path.to.json.url.com/swagger/v1/swagger.json"}
]))
as text;
FirstImpl = (url as text) =>
let
urls = // Create urls...
result = Value.ReplaceType(SecondImpl, SecondType(urls))
in
result;
SecondType = (uris as list) => type function(
url as (type text meta [
Documentation.Name = "text",
Documentation.FieldCaption = "Choose url",
Documentation.FieldDescription = "Please choose a url from the list below to query.",
Documentation.SampleValues = {"https://path.to.api.com/api/"},
Documentation.AllowedValues = uris,
Formatting.IsMultiLine = true
])) as table;
SecondImpl = (url as text) =>
let
result = // Query and parse API passed as url
in
result as table;
