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

[Harsh Vardhan]

can you add more details about your use case here ? you asked initially about scripted rest api on this thread and now you want to use table API, it would be good for us to understand your need and then guide you in right direction , of-course you can use table API as well.

[Rajesh Mushke]

Hi Harsha,

sorry about that, now i have updated the my question.

here is the use case: Automate process to create Microsoft team sites. Our app that we we have developed uses Microsoft Flow/Power Automate which has a connector for ServiceNow but need help figuring out how we can retrieve the data out of SNOW related to approved requests and create Teams and then update the ticket when done, or if it already exists, etc.

as part of this we need to get the RITM variables data.

Thanks for your support Harsha.

Thanks,

Rajashekhar Mushke

[Harsh Vardhan]

one point here, if you will use table API here then you will get all the variable either they have filled or they are blank, if its ok then you can consider the table API. else scripted rest api will give you the exact output which you want and you can use script here to get only filled variables details. 

[Rajesh Mushke]

Hi Harsha,

Yes I need rest API function to pass the variables to Microsoft Flow. could you help me to create a function for the same.

Thanks,

Rajashekhar Mushke 

[Harsh Vardhan]

so are you going to consume service-now api in  Microsoft end ? if yes then what are the operation you want to perform ? 

lets first try with get method, have you successfully build the connection ? if yes then while using the get api ( either scripted or table API ) are you having an issue ?