We would like to export the conversations our customers are having with our Sales agent. Breeze can access these tables, but it provides inconsistent data. Here is some additional context from HubSpot support:
Why you can’t reproduce it in Custom Report Builder: The CONVERSATION and CUSTOMER_AGENT_INTERACTION objects expose metadata (thread ID, timestamps, status, channel, owner, feedback counts, etc.), but neither object has properties for the actual text content of individual messages. That text lives in HubSpot’s Conversations platform message store, which is not exposed as reportable CRM properties. I tried recreating the custom report similar how you did on your call, but I could not find any field resembling similar names.
Currently, the only way we can reproduce the report that Breeze provides is by going through the Conversations API.