Rest call to get associated catalog variables for a Request Item

Patrick Delaney · ‎11-05-2018

I am looking for a way to verify the content of a catalog variable table that is associated with a Request item. I;'m new to ServiceNow and REST. I am using Postman to query ServiceNow and I am using the following command. I am not getting the data I was expecting.

GET https://xxhelpdesk.service-now.com/api/now/table/sc_item_option_mtom?sysparm_query=number%3DRITM0170655

Im not sure I have syntax correct for the second part of the command.

It's my understanding that the sc_item_optio_mtom is the variables table and I was hoping that:

?sysparm_query=number%3DRITM0170655 would pull the catalog variables for the RITM0170655.

But it returns 140,000 lines, that is not what I am looking for.

Any thoughts?

Thanks

Patrick Delaney · ‎11-29-2018

Thanks for your reply, it returns the following, but I am a ServiceNow newby and that doesn't look like what I am expecting.

I'm was for some sort of a JSON string that looks like:

{"requester":"60d3f0f36f946e00d82607321c3ee490","pts_lob":"Corporate","pts_work_around_desc":"","comments":"The string should be placed in c\dev_outputs","pts_product_line":"Family Care","requested_for":"60d3f0f36f946e00d82607321c3ee490","wps_req_title":"This is a test","pts_ce2":"","pts_require_req_type":"yes","pts_ce1":"","pts_olli_msg":"","pts_config_type":"","pts_req_type":"Defect","pts_cs1":"","pts_csp1":"","pts_work_around":"No","pts_cs2":"","pts_csp2":""}

But instead I get this, (maybe it's my lack of Servicenow knowledge)

{
"result": [
{
"sys_id": "335f1baddbc6e700958876721f96191a",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/8a0fd76ddbc6e700958876721f961968",
"value": "8a0fd76ddbc6e700958876721f961968"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "375f1baddbc6e700958876721f961919",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/860fd76ddbc6e700958876721f961967",
"value": "860fd76ddbc6e700958876721f961967"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "3b5f1baddbc6e700958876721f961918",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/0e0fd76ddbc6e700958876721f961967",
"value": "0e0fd76ddbc6e700958876721f961967"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "3f5f1baddbc6e700958876721f961917",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/060fd76ddbc6e700958876721f961968",
"value": "060fd76ddbc6e700958876721f961968"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "735f1baddbc6e700958876721f961919",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/820fd76ddbc6e700958876721f961968",
"value": "820fd76ddbc6e700958876721f961968"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "775f1baddbc6e700958876721f961918",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/0e0fd76ddbc6e700958876721f961966",
"value": "0e0fd76ddbc6e700958876721f961966"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "7b5f1baddbc6e700958876721f961917",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/060fd76ddbc6e700958876721f961967",
"value": "060fd76ddbc6e700958876721f961967"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "7f5f1baddbc6e700958876721f961919",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/8a0fd76ddbc6e700958876721f961967",
"value": "8a0fd76ddbc6e700958876721f961967"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "b35f1baddbc6e700958876721f961917",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/020fd76ddbc6e700958876721f961967",
"value": "020fd76ddbc6e700958876721f961967"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "b35f1baddbc6e700958876721f961918",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/0a0fd76ddbc6e700958876721f961968",
"value": "0a0fd76ddbc6e700958876721f961968"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "b75f1baddbc6e700958876721f961917",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/020fd76ddbc6e700958876721f961968",
"value": "020fd76ddbc6e700958876721f961968"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "b75f1baddbc6e700958876721f96191a",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/8e0fd76ddbc6e700958876721f961967",
"value": "8e0fd76ddbc6e700958876721f961967"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "bb5f1baddbc6e700958876721f961919",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/8a0fd76ddbc6e700958876721f961966",
"value": "8a0fd76ddbc6e700958876721f961966"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "bf5f1baddbc6e700958876721f961918",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/820fd76ddbc6e700958876721f961967",
"value": "820fd76ddbc6e700958876721f961967"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "f35f1baddbc6e700958876721f96191a",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/8e0fd76ddbc6e700958876721f961966",
"value": "8e0fd76ddbc6e700958876721f961966"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "f75f1baddbc6e700958876721f961919",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/860fd76ddbc6e700958876721f961968",
"value": "860fd76ddbc6e700958876721f961968"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "fb5f1baddbc6e700958876721f961918",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/0e0fd76ddbc6e700958876721f961968",
"value": "0e0fd76ddbc6e700958876721f961968"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
},
{
"sys_id": "ff5f1baddbc6e700958876721f961917",
"sys_updated_by": "0019247",
"sys_created_on": "2018-11-28 12:48:32",
"sys_mod_count": "0",
"request_item": {
"link": "https://instance_name.service-now.com/api/now/table/sc_req_item/3b5f1baddbc6e700958876721f96190a",
"value": "3b5f1baddbc6e700958876721f96190a"
},
"sc_item_option": {
"link": "https://instance_name.service-now.com/api/now/table/sc_item_option/0a0fd76ddbc6e700958876721f961967",
"value": "0a0fd76ddbc6e700958876721f961967"
},
"sys_updated_on": "2018-11-28 12:48:32",
"sys_tags": "",
"sys_created_by": "0019247"
}
]
}