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

Hi Ankur,

Yeah thanks a lot. Through postman I can access all the data, the is limit is not there. But for an integration user with webservice and REST API roles, the sc_multi_row_question_answer table is not accessible.

Hi,

They will require that to get the data.

Create a new Table level READ on that Table and give the role which you have give to the integration user like snc_internal etc

Regards
Ankur

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

Did my reply answer your original question?

If so, please mark appropriate response as correct & helpful so that the question will appear as resolved for others who may have a similar question in the future.

Thanks!
Ankur

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

@Ankur Bawiskar,

Hi Ankur,

If we want to fetch MRVS values using RITM table? Is it achievable?

We want to build only one rest API explorer where we want to fetch RITM details including variable and variable set.

I am able to fetch variable details using variables.variablename, but how can i get mrvs data in it?

Regards,

Shoheb

Not possible with 1 API for MRVS as the data is stored in other table

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