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

View solution in original post

Ankur Bawiskar · ‎04-06-2021

Hi,

to get MRVS data table is different sc_multi_row_question_answer

Regards
Ankur

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

Shoheb Shaikh · ‎04-06-2021

Yes, based on the below screenshot, i am referring to sc_multi_row_question_answer table. Issue i am facing in what data should i pass to get the variables value eg: Item MRSP ID

Regards,

Shoheb

Ankur Bawiskar · ‎04-06-2021

Hi,

like this to get 1 variable value

item_option_new.<variableName>

Regards
Ankur

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