How to fetch values of multi row variables through Rest API ?

Rutuja Lambat
Giga Contributor

Hello,

we are using table API to fetch values of variables related to catalog item.

I am able to fetch values for all the variables except multirow variables.

Can anyone suggest on how to achieve this ?

 

Regards,

Rutuja 

1 ACCEPTED SOLUTION

@Rutuja Lambat 

for this table it would look like this

Variable Ownership [sc_item_option_mtom]

Query: request_item=RITM SYS ID

Output:

find_real_file.png

find_real_file.png

Actual RITM:

find_real_file.png

Regards
Ankur

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

View solution in original post

10 REPLIES 10

Willem
Giga Sage
Giga Sage

Hi Rutuja,

Can you share the call you are making now? Can you tell us which variables are in the variable set and what is the name of the variable set?

Ankur Bawiskar
Tera Patron
Tera Patron

@Rutuja Lambat 

Data for MRVS is stored in another table

MRVS Multi Row Question Answer [sc_multi_row_question_answer]

So you need to have API on that table with parent_id=RITMSYSID

Sample below

find_real_file.png

find_real_file.png

Regards
Ankur

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

HI Ankur,

Thanks for the response .

Can you as well let me now for variable with type checkbox where are the values stored ?

 

find_real_file.png

Regards,

Rutuja

@Rutuja Lambat 

Thanks for marking my response as helpful.

This table stores the RITMs variable data.

Variable Ownership [sc_item_option_mtom]

Let me know if I have answered your question.

If my response helped you please mark my response as correct and close the thread so that it benefits future readers.

Regards
Ankur

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