Custom Connector Dynamic Parameters

Greg_Deckler 

I get the parameters for the TEST_VIEW view in the TEST schema via the native query:
Value.NativeQuery(Source, ‘SELECT SCHEMA_NAME, OBJECT_NAME, PARAMETER_NAME, IS_MANDATORY, DEFAULT_VALUE FROM SYS.CS_VIEW_PARAMETERS WHERE SCHEMA_NAME = “TEST” AND OBJECT_NAME = “TEST_VIEW”;’)

If the parameter IP_2 has the value 2, you can use this when querying the TEST_VIEW view:
b = Value.NativeQuery(Source, ‘SELECT * FROM TEST.TEST_VIEW (placeholder.$$IP_2$$=>2);’)

Beginna Right, so when populating the "Data" portion of your navigation table, you should know the table name so you could create a function for getting the data that passed the table name into the function as a parameter and then based on that table name you would know how many parameters to use when retrieving the data. It seems somewhat similar to this from The Definitive Guide to Power Query (M):

Note that I get the guilds (tables in your case) and then for the data for that guild/table I then call a function with, in this case the id of the guild (table name in your case). That function then uses the information build the correct API string to execute. In your case, you would know how many parameters to use.

TDGTPQM_Discord.MemberNavigation = () as table =>
    // Navigation
    //** Membership Navigation
    let
        servers = Table.ExpandRecordColumn(TDGTPQM_Discord.GetGuilds(), "Column1", {"name", "id"}, {"Name", "Key"}),
        addDataColumn = Table.AddColumn(servers, "Data", each TDGTPQM_Discord.GetGuildMember([Key])),
        addItemKindColumn = Table.AddColumn(addDataColumn, "ItemKind", each "Record"),
        addItemNameColumn = Table.AddColumn(addItemKindColumn, "ItemName", each "Function"),
        addIsLeafColumn = Table.AddColumn(addItemNameColumn, "IsLeaf", each true),

        Navigation = Table.ToNavigationTable(addIsLeafColumn, {"Key"}, "Name", "Data", "ItemKind", "ItemName", "IsLeaf")       
 
    in
        Navigation;


// ** Member User
TDGTPQM_Discord.GetGuildMember = (guildid as text) as table =>
    let
        apiCall = Json.Document(
            Web.Contents(
                api_uri,
                [
                    RelativePath = "users/@me/guilds/" & guildid & "/member"
                ]
            )
        ),
        output = Table.FromRecords({apiCall})
    in
        output;