Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Transformations: New feature in Zendesk for ticket_audit and ticket_audit_event

Devin Loputra User

I see in the documentation that there're some data that not included in the Zendesk connector?

Is it possible to implement the pull the data from ticket_audit_event and ticket_audit? 

Also I still can join all of the tables but still I missing some PK `ticket_audit_event_id` and `ticket_audit_id`. I need this for implement creating ticket monitoring dashboard

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Ray User

    Hi Devin,

    I believe everything from the audit tables is supported inherently in other tables like TICKET. For example, author_id relevant to ticket comment and shows up as user_id. Could you perhaps give a more concrete example of what you'd expect to be available that isn't?

  • Devin Loputra User

    Need the author_id also for knowing who create the audit
    https://developer.zendesk.com/api-reference/ticketing/tickets/ticket_audits/#json-format

  • Devin Loputra User

    I listed all the column that I need from the table

    Can you help this one?

    --ticket_audit

    SELECT id as ticket_id,

    assignee_id,

    created_at,

    --ticket_audits.id

    --ticket_audits.author_id ,

    --ticket_audits.events

    FROM`zendesk_fivetran.ticket`;


    --ticket_audit_events

    SELECT id as ticket_id,

    assignee_id,

    created_at,

    --ticket_audits_events.id

    --ticket_audits_events.*random_numbers (custom_field)

    --ticket_audits_events.author_id

    --ticket_audits_events.public

    --ticket_audits_events.type

    --ticket_audits_events,status

    group_id

    FROM`zendesk_fivetran.ticket`