Retrieve custom variables from ServiceNow Task

[emarzanoBNY]

Hi There,

I'm using Get-ServiceNowRecord to retrieve all the fields for a task. This works great for all the default fields, but I don't see any of my custom variables in there.

Is there anyway to retrieve my custom variables using Get-ServiceNowRecord?

Thanks for your help!

[gdbarron]

Hi @emarzanoBNY. I've put something together to grab these values. Do you mind putting it through it's paces? The branch is https://github.com/Snow-Shell/servicenow-powershell/tree/get-custom-variables and the new property is -IncludeCustomVariable on Get-ServiceNowRecord. I've tested on PSv5, but not 7 yet, and working well.

[gdbarron]

Awesome! Glad you got it working.

Do you like the custom vars as is or should we put them under a 'CustomVariable' property? I'm almost leaning towards another property so they can easily be looped through, but would definitely like your thoughts.

[emarzanoBNY]

The custom vars work great as is for me. I can load the contents of the whole RITM into a single $ticket object. Once in there, I can grab $ticket.regularVar and $ticket.customVar.

How would you envision it to work with the CustomVariable property?

[gdbarron]

Perhaps $ticket.CustomVariable would be a pscustomobject with properties Name, DisplayName, and Value. The custom vars would then be separated so they could be easily enumerated and you'd have the benefit of the DisplayName as well. I'm going to give it some more thought as determining which vars are custom by checking for 'variables.' prepended doesn't feel very user friendly, but perhaps I'm wrong.

[gdbarron]

I've updated the branch and created a CustomVariable property which looks like

If this looks good I'll create a release and get it out there. Let me know what you think.

[gdbarron]

added to version 2.4.1