Skip to main content
Planview Customer Success Center

Is it possible to use the API to run ad hoc SQL queries on the Changepoint database?

You cannot use the API to run ad hoc SQL queries on the Changepoint database.

However, you can use a call (LookupIds: GetLookupFields) to query a database table by using a free SQL Where clause. You can use this call to retrieve the IDs of entities such as projectID, timeID, requestID, and so on. You can then use further calls (for example, Time.GetTimebyID) to retrieve the full object data.