Consume servicenow endpoint to get list of change requests

[bchandala]

Hi,

As part of my POC, I need to display the number of Change Requests associated with a specific release. To achieve this, I plan to consume the ServiceNow API.
Could someone please help me identify the correct API endpoint to use for retrieving the list of Change Requests for a given release, and the endpoint to call for displaying the details of a selected Change Request?

Thanks You.

[Swapna Abburi]

Hi @bchandala 

if release is a field in change request table, then you can use direct table level APIs. You can build the API endpoint using REST API explorer.

The endpoint will look like below and you can update the query as per your requirement.

https://instanceName.service-now.com/api/now/table/change_request?sysparm_query=number%3DCHG0012345&sysparm_display_value=true

[Ankur Bawiskar]

@bchandala 

If there is a direct linkage between Change and Release table then you can use OOTB Table API

But remember OOTB Table API exposes all the fields to 3rd party so it's not recommended.

You can use Scripted REST API which gives you full control on what API response to be given to 3rd party

Scripted REST APIs 

Scripted REST API examples 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏