Catalog items variables converted to JSON object and commit to Azure DevOps git repo

[Page22]

Hi All,

I have this client requirement and would like to know how this can be implemented.

How can we get the values of a submitted service catalog request form after all the approvals in

JSON format to commit directly to the Azure DevOps git repo

[Tony Chatfield1]

Hi, the approach you take will be dependent on definition of 'get the values of a submitted service catalog request ' and the required content. Are you looking for all the fields, some of the fields, an exact replica but JSON...or are you looking to include related data IE details form the approval process and\or the variables submitted with the request?

There are a number of posts floating about the community that contain details of ways to convert a SNC record to JSON format, but I think the easiest solution to get a complete record would be to simply make a REST 'get' call using table API, you would possibly then need to query for variables relevant to the ritm and populate these into the payload, and append anything else you wanted before submitting\posting the payload to your integration.

If you are not looking for full content, then a scripted solution that creates you JSON payload based on individual field requirements would be the cleanest way to achieve.