Custom Variable 'Reference' Type Value is Incorrect

[RichardMawdsley]

Discussed in https://github.com/Snow-Shell/servicenow-powershell/discussions/217

^{Originally posted by **RichardMawdsley** December 7, 2022} Hi There, Been using the CustomVariable option on the Get-ServiceNowRecord function for some time and it's working great. However, I'm unsure if I've found a bug or if it's just pulling the wrong information back, but what I'm getting is incorrect when the Type is 'Reference'. ``` $RITM = Get-ServiceNowRecord -ID $SNNumber -IncludeCustomVariable -New $RITM.CustomVariable ``` Returns: ``` @{Value=ddf18f001b217700dfa575d6cc4bcb47; DisplayName=Location; Type=Reference} ``` When if I look in ServiceNow, the actual value is: ``` London - Main Office ``` Same is resulted without '-New' too. Unsure if it's related to the -DisplayValue parameter or this was supposed to resolve this very problem, but seemingly adding it causes the .customvariable to be empty. I assume that what it's pulling is the ID or something of that value, but I'm not a ServiceNow admin so unsure on that. Thanks in advance.

[gdbarron]

Hi @RichardMawdsley. I assume the value being returned is the sysid for 'London - Main Office' in the Location lookup/table. If you can confirm, we can add this as an enhancement. This is expected as reference lookups for the underlying value require dot sourcing, if possible, or another call to the referenced table.

[RichardMawdsley]

Hi @gdbarron , yes had it confirmed that this is the sysid. Much appreciated if this enhancement could be added!

[gdbarron]

@RichardMawdsley the update is in. Would you mind testing?

[RichardMawdsley]

Perfect! Values are now getting returned exactly as expected. Thanks @gdbarron !