How to get RITM variables display value using REST API?

[Rajesh Mushke]

Hi All,

How to get RITM variables display value using REST API with out using scripted REST API.

Can someone help on this.

Thanks,

Rajashekhar Mushke

[Ankur Bawiskar]

Hi,

please check steps & screenshot below

1) in left nav open rest api explorer

2) open the table API; give table as sc_req_item

3) query I have given is number=RITM0010298

URL: https://instanceName.service-now.com/api/now/table/sc_req_item?sysparm_query=number%3DRITM0010298&sysparm_fields=variables.group

HTTP Method: GET

give all the variables name in the sysparm_fields as variables.<variableName>

separate each variable with %2C

Ensure you set this as true

sysparm_display_value -> true

Screenshots:

RITM: Having group as reference variable with value as "Security Managers"

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Rajesh Mushke]

Hi Ankur,

I will try it and get back to you. Thank you so much for you support!!

Thanks,

Rajashekhar Mushke

[Ankur Bawiskar]

Sure do keep posted

Regards
Ankur

[Rajesh Mushke]

Hi Ankur, Could you please help me to create API function to pass the variables to Microsoft Flow. Thanks, Rajashekhar Mushke

[Ankur Bawiskar]

Hi,

Is this for inbound or outbound?

Did microsoft flow provide some endpoint to which variable information can be shared?

Regards
Ankur