Approaches to Encrypt Sensitive Columns in BIP Data Model Results

Summary:

We need to include an Apex URL in the email generated by BIP. The URL should be constructed using the host component and encrypted values from specific columns, such as the requisition number and candidate number. How can these column values be encrypted using a specific key?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):