- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2020 04:35 AM
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.
Solved! Go to Solution.
- Labels:
-
Request Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2020 05:55 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2020 06:23 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2020 06:44 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2020 06:45 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2021 04:40 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2021 04:50 AM
Not possible with 1 API for MRVS as the data is stored in other table
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader