Access multi-row variable set from RITM using Rest API explorer

Subhajit Mukhe1
Kilo Expert

Can anyone suggest me how I can access multi row variable set using REST API explorer.

For single variables, variables.variable_name is working in sysparm_fields. But no luck with multirow variable set.

1 ACCEPTED SOLUTION

Hi,

Responses below

1. how can I fetch display value of a reference type variable in the multi row variable set.

- not possible as the table only stores sys_id and not display value

2. currently there is a sysparm_limit which is 1 or 10. Can I customize the value. My requirement will exceed 10 for sure.

- this should be fine; when you consume from postman/3rd party tool and don't set the sysparm_limit it should give you all the records

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

17 REPLIES 17

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

data for MRVS is stored in this table

Multi Row Question Answer [sc_multi_row_question_answer]

So you will have to use that TABLE for API

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Subhajit,

Example below

find_real_file.png

find_real_file.png

find_real_file.png

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur,

This worked perfectly fine for me.

I have 2 queries now:

1. how can I fetch display value of a reference type variable in the multi row variable set.

find_real_file.png

 

2. currently there is a sysparm_limit which is 1 or 10. Can I customize the value. My requirement will exceed 10 for sure.

Hi,

Responses below

1. how can I fetch display value of a reference type variable in the multi row variable set.

- not possible as the table only stores sys_id and not display value

2. currently there is a sysparm_limit which is 1 or 10. Can I customize the value. My requirement will exceed 10 for sure.

- this should be fine; when you consume from postman/3rd party tool and don't set the sysparm_limit it should give you all the records

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader