Get variable values from RITM using REST API

[Akshaya R]

Hi All,

I am trying to read the variable values from a requested item using REST API. I queried the table "sc_item_option_mtom" with the below context.

sc_item_option_mtom.request_item=<<sys_Id of the corresponding RITM>>

The output response from postman looked something like below:

{

   "result": [

                  {},

                  {},

                  {},

                  {},

                  {}

                  ]

}

What does this response mean? What is the mistake that am making here? I would like to capture the values of the custom variables in a request item. 

Thank you!

[Swapna Abburi · Accepted solution]

Hope you are using name of the variable?

[Swapna Abburi]

@Akshaya R 

I think you don't need to query sc_item_option_mtom table. You can directly use "variables.<variable name>" to get the value of RITM variables.

[Akshaya R]

Hi Swapna,

Just tried the way you suggested as below. "Department" is one of the variables of the RITM and sys_id corresponds to the RITM.

https://<<instance>>.service-now.com/api/now/table/sc_req_item?sysparm_query=sys_id%3Dcf8e87f61b13dd...

The response was still empty.

[Akshaya R]

@Swapna Abburi  - Attaching the URI as an image for more clarity.

[Swapna Abburi]

The API looks fine. Is Department variable present on the Requested Item in variables section? Please share the screenshot of the variable.