What is the format for adding optional parameters to MakeResourcePath?

[stevelord]

I have a connector that currently has two parameters.

MakeResourcePath = (projectId, optional server) =>

When I add an additional optional parameter adding something like this, the connector fails to load:

MakeResourcePath = (projectId, optional server, optional customServer) =>

How do I specify extra parameters? These are all named in 

FunctionType = Type.ForFunction(
    [
        Parameters = [

            server = (type text) meta [...],

            projectId = (type text) meta [...],

            customServer = (type text) meta [...]

    ]

[stevelord]

Thanks Support Team,

Unfortunately that does not answer the question. I would like to see an example of MakeResourcePath with more than one optional parameter. Would you have that example?

[v-yanjiang-msft]

Hi @stevelord ,

Please see if this document helps:

Using a resource path for Power Query connectors - Power Query | Microsoft Docs

Power Query dynamic file path | Excel Quick Help

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.