Dump Zendesk Audit Logs

dump_zendesk_auditlog.py

import requests
import pandas as pd
from pandas.io.json import json_normalize
import time

url = 'https://ZENDESKDOMAIN.zendesk.com/api/v2/audit_logs.json?sort_order=desc'
user = 'ZENDESK_EMAIL'  + '/token'
pwd = 'ZENDESK_APIKEY'

session = requests.Session()
session.auth = (user, pwd)

auditlog_results = []

while url:
  response = session.get(url)

  if response.status_code == 429:
      print('Rate limited! Please wait.')
      time.sleep(int(response.headers['retry-after']))
      continue

  if response.status_code != 200:
      print('Status:', response.status_code, 'Problem with the request. Exiting.')
      exit()

  data = response.json()

  auditlog_results.extend(data['audit_logs'])

  url = data['next_page']

p = json_normalize(auditlog_results)
p.to_csv('audit.csv')

How to run

pip install pandas
python dump_zendesk_auditlog.py

This script export Zendesk auditlogs to CSV file (audit.csv)

Ref. https://developer.zendesk.com/rest_api/docs/core/audit_logs