Get variable values from RITM via API

[ShAn21]

Hi Team,

I have a requirement where the client wants to get all the variable values by sending the RITM number.

Do we have any OOB APIs available right now to fetch all the catalog variables from a RITM. I dont see any option in the sn_sc service catalog API. Is table API a feasible Option?

Thanks

[Ankur Bawiskar]

@ShAn21 

Don't use TABLE API. It will expose other fields also although it's possible to get the variable data using it.

better to use scripted REST API and ask them to use GET method and send the RITM number

get the variable data, form the response JSON and give that as API response

check this link and enhance

Scripted REST APIs & Retrieving RITM Variables via SRAPI 

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

[ShAn21]

Hi Ankur,

Thanks a lot for getting back. I understand the concern but we are asked to utilize the OOB API as much as possible.

One additional point to the same thing. Is it possible to fetch the Multi row variable set using the OOB API as well? I understand we can use variable.variable_name for standard variable.

Thanks

[Ankur Bawiskar]

@ShAn21 

you can fetch the MRVS but it will return JSON string as the value for MRVS is actually stored in other table (sc_multi_row_question_answer)

Using Table API will expose all the RITM fields hence I don't recommend

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

[ShAn21]

Hi Ankur,

That means the consumers need to use the Table API separately twice? For 2 different tables.

Thanks