How to get RITM stage status details through REST API?

[Sravani36]

Hi Team,

I have a requirement to expose the status of a Service Catalog RITM through REST API.

I am using the Table API on sc_req_item with the GET method to retrieve the ticket details. I am able to get the normal field-level values like:

• number

• state

• approval

• stage

However, the issue is with the stage/status details shown in the list view.

In the list view, ServiceNow shows the complete stage progress like:

Request Approval - Completed
Pre-Checks - Completed
AWS Account Provisioning - Completed
Network - Completed
Infra Pre-Requisites - Completed
Infra Provisioning - Completed
Database Configuration - Completed
Application Pre-Requisites - In Progress
Application Deployment - Pending / Has not started
Assessment - Pending / Has not started
URL Publishing - Pending / Has not started

But on the RITM form, the stage field only shows the current stage, for example:

Application Deployment

My question is:

Is there any supported way to get the full stage progress/status details through REST API, the same way it is visible in the list view?

I want to know whether this data is available through:

1. sc_req_item Table API itself,

2. any related workflow/flow context tables,

3. any Service Catalog stage history table,

4. or whether a custom Scripted REST API is required to return this information.

The requirement is to return each stage name along with its status, such as Completed, In Progress, or Pending / Has not started, for a given RITM.

Please suggest the correct table/API or recommended approach.

Thanks,
Sravani C