Why Can’t I Join the CONTACT_CALL and CONTACT Tables?

Question

Why are no matching records returned when I try to join the CONTACT_CALL and CONTACT tables using the contact_call.contact_id and contact_id columns?

Environment

Connector: Talkdesk

Answer

We use the Talkdest Execute a Report endpoint to populate the CONTACT_CALL table. In the reports returned by this endpoint, the contact_id field identifies the call record. However, the contact_id field in the CONTACT table represents the contact itself. Since these columns represent different entities, their values don't align, and joins between the tables don't return results.