Get Data of submitted RITM's Multi Row Variable Set

[WaseemM]

Hi All,

I have a catalog with Muti Row variable set, I want the information stored in the multi row variable set of submitted RITM. I can extract this information using flow designer's get catalog variable action but I want to get this using PowerShell RESTAPI.

I've tried using below code but I'm not able to get the values from it.

$instance = "https://servicenow.com"
$snowuser = "user"
$snowpassword = "password"
$ritmNumber = "RITMXXXXXXX"

# Authentication setup
$pair = "${snowuser}:${snowpassword}"
$encodedAuth = [Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes($pair))
$headers = @{
    Authorization  = "Basic $encodedAuth"
    "Content-Type" = "application/json"
    Accept         = "application/json"
}

# Get RITM sys_id
$ritmUrl = "$instance/api/now/table/sc_req_item?sysparm_query=number=$ritmNumber&sysparm_fields=sys_id"
$ritmResponse = Invoke-RestMethod -Uri $ritmUrl -Headers $headers -Method Get
$ritmSysId = $ritmResponse.result.sys_id

# Get MRVS sys_id from sc_item_option_mtom
$mtomUrl = "$instance/api/now/table/sc_item_option_mtom?sysparm_query=request_item=$ritmSysId"
$mtomResponse = Invoke-RestMethod -Uri $mtomUrl -Headers $headers -Method Get

[WaseemM]

Hi Ankur,

Thanks for your support. I've tried this already. I was able to get the field information not the values of submitted RITM.