Dynamically find and replace a specific string within text while using interface tools

[mtryba]

Hello!

I am building a workflow which is importing data from WorkDay using CSV URL's in order to export specific report data.  Currently, I am running this report once a month from my desktop designer and created a formula to find and replace the specific string of text I am looking to change.  Ideally, I would like to save this report into the gallery to give our team the ability to run it without my intervention.  

The WD URL is attached as an image (highlighted string would need to be updated monthly). 

The current formula I have in Alteryx is:
Replace([WD API], "677618225fe5015d3fdf15eef111acb8", "42dc187536ce01015c1fc9de1ae00001")

I have a list of fiscal months and integration IDs in Alteryx which I would like to turn into a selection with the interface tools.  For example, the string highlighted in the WD URL screenshot is for "2024 Fiscal Schedule-12 - December (TripAdvisor Fiscal Schedule)".  I would like that text to be displayed as a dropdown for employees running it in the gallery but the Alteryx workflow needs the "Workday ID" to update the URL before our download and JSON tools.  

[KGT]

In the Dropdown tool, the default way to pass it parameters is NAME:VALUE, so the name is what you want displayed and the value is what you want passed into the workflow. It sounds like the default way the Dropdown Interface Tool works for external source, is what you want.