Skip to main content
  • EN

I need to have a choice parameter offering all the database tables of a specific database for the user to choose from before running the workspace.

I do have the Python code ready, and created a scripted parameter, returning a list of all table names.

I referenced the scripted parameter as input for the choice parameter, but that only gives me a dropdownbox with the name of the parameter linked to it.

 

Is it possible to populate a choice parameter from a Python script (scripted parameter), and if so how?

Unfortunately, I don't think you'll be able to populate the choice parameter with a scripted parameter automatically. the closest option available is importing the choices from a dataset and the importing process has to be done manually, each time you want to update the choices

image

Thank you for your answer, even though that's a bummer...

Hello @Thomas Becker​ 

@carmijo​ is correct. The reason being parameter values are set at the very start of a workspace (at runtime) plus it is not possible to modify the value of a parameter after it has been set. So it is not possible for the Python scripted parameter to pass its values to the choice parameter and modify the choice parameter within the same workspace.

 

However, this post on dynamic but hacky updates to published parameter choices contains a workaround that might suit your use case.

 

I would definitely recommend voting on this Idea about dynamic lookup parameters if you want to this functionality within FME natively.

Reply


Community Stats

30,352
Posts
115,344
Replies
38,087
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.