Variable Table inquiry (sc_item_option & sc_item_option_mtom)

[Matt Campbell1]

Hello, I was able to figure out how to query from the sc_item_option & sc_item_option_mtom

But the results show the SYS_ID with the answers to the variable. not the actual question if that makes sense. 

Is their a way to query these tables or variables without using the sysid? I believe the sys_id is randomly generated.

Here is an output from the query. 

RITM RITM0049524
RITM sys_id: 8ff2c7c4db0393805f7f72e9af961973
Option items: 71
Sys ID: 03f2c7c4db0393805f7f72e9af96196f
Value:
Please provide the billing cost centre number
cost_center

Please provide the billing cost centre number

Sys ID: 0bf2c7c4db0393805f7f72e9af96196f
Value:
Please provide more information regarding the existing device.
ExistingCorporateMobileDeviceDetails

Please provide more information regarding the existing device.

Sys ID: c7f207c4db0393805f7f72e9af9619ed
Value: Matthieu
First Name
first_name

First Name

Sys ID: 8ff2c7c4db0393805f7f72e9af96197d
Value: Yes

Sys ID: 8ff2c7c4db0393805f7f72e9af961980
Value: No

Sys ID: 0bf2c7c4db0393805f7f72e9af96196b
Value:
End Date
EndDate

End Date

Sys ID: c3f207c4db0393805f7f72e9af9619ed
Value:
User Information
a_start

User Information

Sys ID: 83f2c7c4db0393805f7f72e9af961980
Value: Yes

Thanks,

Matt

[Mark Stanger · Accepted solution]

Great!  Please mark my answer above as correct if I've answered your question.

FYI, you should check out 'System Web Services -> REST -> REST API Explorer' in the left nav of your ServiceNow instance.  It allows you to graphically set up different requests like this and then send the request to the local instance.  It makes it very easy to see what URL parameters, etc. should look like.