We are requesting a new table in the existing Forethought connector for human-agent QA results returned by the AgentQA Analytics API.

Fivetran Support confirmed that the current connector only uses the Forethought Solve Analytics API:

https://dashboard-api.forethought.ai/analytics/solve/v0

The existing connector does not call the AgentQA /scored-tickets endpoint. Its current AI_QA_INSIGHT table is populated from Solve conversation data and does not provide the human-agent custom-rubric results required for our use case.

We need the proposed table to include, where available:

- Ticket and agent identifiers
- Scored-ticket and evaluation timestamps
- Custom rubric and scorecard results
- Rubric criteria, labels, reasoning and scores
- Rubric weights and final weighted score
- Fields required to identify updated or re-scored evaluations

The integration should support Bearer-token authentication, pagination, incremental synchronization and upserts for updated or re-scored records.

Our business requirement is to ingest Forethought human-agent QA results into Snowflake and combine them with Salesforce Case QA data in a centralized reporting dashboard.

This request is time-sensitive because the AgentQA/custom-rubric API data has a rolling 90-day availability window. A managed connector would allow us to retain this history and avoid losing older QA results.