Thank you for the prompt reply, but I think you misunderstand where my question originates from. 'why do you think it's a good idea to introduce elements into your environment that less experienced users will need additional knowledge to implement?'. The answer to this question is rather simple. Thi...

@skyehansen say we already have n number of objects with special characters in their names, do you know if it is absolutely impossible to create prompts on them? Or is it something that could come in the future. We could simply wrap the string in quotes.

I wanted to post an update on this question. I have found a solution to my problem. I owe it partly to @Kurt_Jones. I used the concept of url encoding to get to this solution. Everything remains the same, except for the parameter i am passing to the Base URL. Instead of 'DE:Initiative Name'. i am no...

Did you figure this out? If yes, please post your solution here. Thanks in advance.

Thanks @Kurt_Jones for the detailed explanation. This does shed some light onto my problem but not fully. The field I am querying is Project Name and not a Dropdown Field Option Value and so it is not possible for me to write calculated logic for individual items. But with your answer I will try to ...

I am trying to fetch the Program associated to a Project. The Project is selected using a typeahead and the name of the Project is used in the URL to fetch the associated Program. The issue is that the External Lookup field is not returning any value when the Project name has special characters. Thi...