Zendesk Connector¶

CREATE CONNECTOR zendesk_support
TYPE 'zendesk'
CONFIG {
    "subdomain": "mycompany",
    "email": "{{secrets.zendesk_email}}",
    "api_token": "{{secrets.zendesk_token}}"
};

SELECT id, subject, status, priority, assignee_id, created_at
FROM zendesk_support.tickets
WHERE status = 'open'
  AND priority IN ('high', 'urgent')
ORDER BY created_at DESC;

SELECT id, name, email, role, organization_id
FROM zendesk_support.users
WHERE role = 'end-user';

SELECT id, name, domain_names, tags
FROM zendesk_support.organizations;

SELECT id, body, author_id, created_at
FROM zendesk_support.comments
WHERE ticket_id = 12345;

CONNECTOR_EXEC zendesk_support.tickets.create({
    "subject": "Automated ticket from Moltler",
    "description": "This ticket was created automatically",
    "priority": "normal",
    "tags": ["automated", "moltler"]
});

CONNECTOR_EXEC zendesk_support.tickets.update(
    ticket_id => 12345,
    data => {
        "status": "solved",
        "assignee_id": 67890
    }
);

CONNECTOR_EXEC zendesk_support.tickets.comment(
    ticket_id => 12345,
    body => 'Automated response from Moltler',
    public => false
);

CREATE SKILL auto_respond_zendesk
VERSION '1.0.0'
DESCRIPTION 'Auto-responds to tickets matching common patterns'
PARAMETERS (
    connector STRING,
    pattern STRING,
    response STRING
)
RETURNS NUMBER
BEGIN
    DECLARE tickets CURSOR FOR
        SELECT id, subject
        FROM connector.tickets
        WHERE status = 'new'
          AND subject LIKE pattern;

    DECLARE count = 0;
    OPEN tickets;
    FOR ticket IN tickets LOOP
        CONNECTOR_EXEC connector.tickets.comment(
            ticket_id => ticket.id,
            body => response,
            public => true
        );
        SET count = count + 1;
    END LOOP;
    CLOSE tickets;

    RETURN count;
END SKILL;