Skip to main content
Question

Dynamic update user param

  • October 28, 2024
  • 2 replies
  • 349 views

kanhan1
Contributor
Forum|alt.badge.img+4

Hi,

I want to fill the User Param Choice with data from a table in MS SQL. This works fine with the 'Import->From dataset...' option. but this function only populates data statically. Is there any way to 'hack' this to fetch data dynamically? The idea is that this Workspace should work in a App in FME Flow.

 

 

2 replies

emma.at.safe
Safer
Forum|alt.badge.img+10

Hi @kanhan1

You might find it helpful to look into Scripted Selection. This feature is available in FME version 2024.0 and later. This parameter type allows users to select from a dynamic list of options based on a Python callback. You can read more about it here: 

Hope this helps!

Emma


kanhan1
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • November 5, 2024

Hi, Emma.

Thank you for your reply. Will look a little closer at this option. Does Safe plan to create a suitable function for this in the future?

Hans Ove