I am not seeing the data I expect in the Perceptor Management Console
For security, the Perceptor application does not have a direct connection to the SQL database. Instead, it securely connects to the DataAPI which in turn connects to the SQL database.
We have a couple of API endpoints that can be useful for checking the Data API and the underlying database availability:
- GET {data api path}/api/ping checks that the Data API is up and running, and returns Success (200) if available
- GET {data api path}/api/health runs a simple query on the database and returns Success (200) if successful, Service Unavailable (503) if the connection to the database fails.