Analytics API 500 on custom report query

General Discussion
1

Having some issues getting my configuration to work…

Running Terraform plan for genesyscloud_report_custom. The CLI throws a generic server error when querying the definition endpoint.

  • GC CLI v2.15
  • Terraform provider v1.30
  • Org: AU-East

Error: Failed to get custom report genesyscloud_report_custom "kpi_summary": 500 Internal Server Error

The report exists in the UI. API call works manually. Is this a known issue with the provider or a transient backend bug?

2

This is caused by…

Cause: The provider likely fails when the custom report definition contains complex nested filters or unsupported SQL clauses that the API rejects during validation.

Solution: Simplify the report definition in the UI first. Verify it works via Postman. Then, use the genesyscloud_report_custom data source to import the existing config rather than creating a new one. Avoid complex joins in the initial Terraform apply.

3

Make sure you verify the report definition structure before importing.

data "genesyscloud_report_custom" "kpi_summary" {
 name = "kpi_summary"
}

Complex filters often cause validation failures during the initial Terraform apply.