There are certain objects like Variable Ownership(sc_item_option_mtom), Options(sc_item_option) which are available in the Servicenow API but missing in the Servicenow integration service activities. How can these values be retrieved?
Issue Description:
There are certain objects like Variable Ownership(sc_item_option_mtom), Options(sc_item_option) which are available in the Servicenow API but missing in the Servicenow integration service activities. How can these values be retrieved?
Resolution: These values can be retrieved as follows:
- Variable Ownership sc_item_option_mtom
Specifies relationship between item (e.g. sc_req_item) and variables. There is an entry for each variable on an item. This is just a reference table for foreign keys. Use the sys_id for sc_req_item to get a list of all of the variables for that item. Use that list to look up entries in the Options table.
- Options sc_item_option
Contains the friendly/readable value for a variable. Use the sys_id for sc_item_option from the Variable Ownership table to get the friendly value.