Hello,
I'm trying to create some of the function parameters using a json file.
If I set the JSON file as "Compile", I can generate the documentation value using the JSON, however,
if I'm getting the JSON from an absolute path("Content"), I can't generate the documentation values.
GetServersContent = (filename as text) as list =>
let
json = Json.Document((File.Contents(filename)),
servers = json[Servers],
table = Table.FromList(servers, Splitter.SplitByNothing()),
expanded = Table.ExpandRecordColumn(table, "Column1", {"Name", "URL"}),
tolist = expanded[URL]
in tolist;
GetServersCompile = (filename as text) as list =>
let
json = Json.Document(Extension.Contents(filename)),
servers = json[Servers],
table = Table.FromList(servers, Splitter.SplitByNothing()),
expanded = Table.ExpandRecordColumn(table, "Column1", {"Name", "URL"}),
tolist = expanded[URL]
in tolist;
{
"Servers": [{
"Name": "Localhost",
"URL": "http://localhost:5980"
},
{
"Name": "Localhost1",
"URL": "http://localhost:5981"
},
{
"Name": "Localhost2",
"URL": "http://localhost:5982"
}
]
}
This is my json file, I'm just trying to get the server URL's and set Documentation.AllowedValues using them.
shared SampleConnector.Connector = Value.ReplaceType(ConnectorImpl, Params);
Params = type function(
ServerUrl as ( type text meta[
Documentation.FieldCaption = "Server URL",
Documentation.FieldDescription= "Enter the server URL to connect",
Documentation.AllowedValues = GetServersContent("C:\powerbi.json")
// Documentation.AllowedValues = GetServersCompile("powerbi.json")
])
) as table meta [
Documentation.Name="Sample Connector",
Documentation.LongDescription = "Connects to Sample."
];
ConnectorImp = () => ...
If I use
Documentation.AllowedValues = GetServersCompile("powerbi.json"), everything works properly.
But,
Documentation.AllowedValues = GetServersContent("C:\powerbi.json") doesn't generate the allowedvalues.
