Where Can I Find Zendesk Ticket Links in the Destination?

Question

Where can I find Zendesk ticket links in the destination?

Environment

Connector: Jira

Answer

Fivetran doesn't store Zendesk ticket links in the ISSUE_REMOTE_LINK table because the Jira API does not classify them as native remote issue links. Instead, we syncs Zendesk ticket URLs as a custom field.

To find the field ID and the associated ticket URLs, query the FIELD and ISSUE_FIELD_HISTORY tables:

SELECT 
    f.name, 
    ifh.*
FROM database.schema.field AS f
INNER JOIN database.schema.issue_field_history AS ifh
    ON f.id = ifh.field_id
WHERE f.name = 'Zendesk Ticket URL' 
  AND ifh.value IS NOT NULL;

The value column contains the Zendesk ticket URLs.

For more information about custom fields, see Custom Fields and Field Tables.