This page lists the prerequisites , entities involved and steps to reproduce customer issues related to RestAPI.

1. Check if you have all the Entities Involved in reproducing the issue
2. If yes then follow the steps given under Set up the environment to launch the Rest API
3. Enter the URI whose results are incorrect / inconsistent and click on Submit. Identify the query leading to the issue using the steps given in the page, start from Step7 - Report Generator - Information - How to identify SQL query related to a specific block in the report generator

Entities Involved in reproducing the issue

1. Databases (Central Database or Measurement Database)
   This is fetched by Sherlock if the option Export CAST Bases is checked - <Shelock.zip>\Backup\
2. RestAPI war
   This can be found in the CAST Installation folder - < CAST Installation folder > \WARS\CAST-RestAPI.war

Set up the environment to launch the Rest API

1. Import the Central/Measurement Database on support server
2. Deploy the CAST-RestAPI.war, see Installing and configuring the CAST-RestAPI.war for more information
3. Activate the Show SQL traces by following the steps in the page Health Dashboard - Information - How to activate SQL traces on AAD and RestAPI logs