Modify $HOST$ variable before open

Hi!
I have use-case where I have an SSH entry. That SSH entry has Before Open event to prompt for the hostname to connect to. Then $PROMPT_VARIABLE$ is used in Host field in General section.
All that is fine... when you have working DNS. I don't :)

I have a Netbox (IPAM system) to which I can do an API call with the curl bash command to retrieve IP of the hostname.

Is there any way to do the following:

• Get prompted to input hostname
• Make an API call to Netbox with $PROMPT_VARIABLE$ argument
• Use returned value to override Host variable in SSH entry

I have a dirty workaround which I don't like - since I have different credentials for different subset of hosts I can use the following:

• Command line entry in RDM which prompts for the hostname and run a bash script "myscript.sh $PROMPT_VARIABLE$"
• myscript.sh has commands to make an API call to Netbox to get an IP ($hostip below)
• Then myscript.sh invokes RDM Template via command open -a "/Applications/Remote Desktop Manager.app" "rdm://open?DataSource=dad2.....Template=$templateid&Host=$hostip&Title=$host"

But that is hard to maintain because for every connection with different creds I need to have a separate RDM Template, and also additional logic in bash script to use that specific Template when connecting to specific hostnames....

So my question is, how on MacOS to overwrite Host variable with something what can be returned from a command line (or from external bash script?)

Thanks!