Hey @akrus, I can advise it via custom code, with the most similar example.
See the example of function in JavaScript that extracts the visible value for the “country” property:
function getVisibleCountry(internalValue) {
switch (internalValue) {
case “us”:
return “United States”;
case “ca”:
return “Canada”;
case “mx”:
return “Mexico”;
default:
return internalValue;
}
}
And in this example, the function takes in the internal value for the “country” property and returns the corresponding visible value. If the internal value is not found in the lookup table, the function returns the internal value as is.
You can then use this function to extract the visible value for each record in your HubSpot account. Here’s an example of how you might use this function to retrieve the visible country value for a set of contacts:
// Get the contacts from HubSpot
const contacts = await hubspot.contacts.get();
// Loop through the contacts and extract the visible country value
const visibleCountries = contacts.map(contact => {
const internalValue = contact.properties.country.internalValue;
const visibleValue = getVisibleCountry(internalValue);
return visibleValue;
});
console.log(visibleCountries);
Hope this help! Try with this same and let me know if this dosen’t work.
All the best. Cheers!