Forum Discussion
Custom Connector Dynamic Parameters
Hello, I am developing a custom connector. Is there a way to dynamically generate the parameters that a user selects? Specifically, I want to identify which table is selected in the navigator and ...
Greg_Deckler
Community Champion
Community ChampionBeginna So this sounds possible but not sure I have enough information to provide specific help. Can you provide an example of a native query that gets these parameters? And then once you have the parameters, how do you use them?
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);’)