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

Subhajit Mukhe1 · ‎12-15-2020

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.

Ankur Bawiskar · ‎12-15-2020

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

Shoheb Shaikh · ‎03-31-2021

So if I want to share api with client then it should be two api? one on catalog item table and other one on sc_multi_row_question_answer?

Regards,

Shoheb

Ankur Bawiskar · ‎03-31-2021

single api for MRVS table

but remember data in that table has sys_id and not display value for reference variables

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

Shoheb Shaikh · ‎04-06-2021

@Ankur Bawiskar

So I created first rest api on requested item table and got the variable values.

Now, i have created another api for MRVS but the variables data present in it are not accessible :

Output:

Where am I going wrong?

Regards,

Shoheb

Ankur Bawiskar · ‎04-06-2021

Hi,

not accessible means?

Regards
Ankur

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

Shoheb Shaikh · ‎04-06-2021

Means i want to get the variable data that are present in the variable set. What will be the value/code that we will pass for this?

Regards,

Shoheb