A small, but very useful improvement has been delivered in the latest release of the Windows and Web user interfaces and the Indicium Service tier. It is now possible to use process flow variables in the constant value of input parameters of process flow actions!
To create the request URL for an HTTP connector based on user input, for example, instead of having to create the URL in the process action logic like this:
set @url = 'https://api.overheid.io/bag?filterstpostcode]=' + @postcodeYou can just set the value of the URL parameter like this:
The user interfaces and service tier will automatically substitute {postcode} with the current value of the postcode process flow variable when the HTTP action is executed.
Be careful when using this feature in the SQL parameter of a Database connector, as this increases the risk of SQL injection. When using the Database connector process action, we strongly advice to use ODBC question mark placeholders with the JSON or plain text Parameters input option instead. More info here.