Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Global Variable

 I am developing a custom connector ,  There are various methods which needs to have a same variable as parameter . Is there an way to declare a  variable global  , whose value keeps on changing afte...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous  thanks , but I want to use it in my Custom Connector , not for report .  Is  there any way like this in custom connector? or power query?

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous,

It is possible to setting an optional parameter with default value in your connector, but you cant write back and change the default value which is defined in the custom connector. (New connector only existed the default value, changed new value not able sync to connections used the same connector)
For query parameters, you only need to invoke it in connections. These invoked parameter values will update if you modify the current value of query parameter.

For example:

Query parameter:

QP1=1, QP value will sync to all connectors who invoked it.

Your query tables:

Source1=CustomConnecotor(connectionstring1, QP1)

Source2=CustomConnecotor(connectionstring2, QP1)

Regards,

Xiaoxin Sheng