-IncludeCustomVariables Param of Get-ServiceNowRecord Does Not Include MRVS Information #287
Description
Summary of the new feature/enhancement
When variable sets are configured on catalog items the values are not returned when using -IncludeCustomVariables parameter of Get-ServiceNowRecord because the data is stored in a different table. The variables are included in the initial response from sc_item_option_mtom, however they are filtered out of the response because sc_item_option.value is null/empty.
The actual variable set data is stored in sc_multi_row_question_answer table and can be located by using parent_id. It is possible to configure multiple variable sets on a catalog item which can be discovered and subsequent filtering of sc_multi_row_question_answer table by querying io_set_item table by using sc_cat_item and including the desired sys_id(s) by using variable_set.
Proposed technical implementation details (optional)
Add a new parameter -IncludeVariableSets to Get-ServiceNowRecord to extend the functionality and allow opt-in retrieval of this data through the REST API to a new property on the returned data using a similar methodology as the existing -IncludeCustomVariables parameter.