POST /api/admin/audit-log/export/

Creates a job to export the filtered audit log to a CSV file.

This is a enterprise feature.

Servers

Request headers

Name Type Required Description
ClientSessionId String No

An optional header that marks the action performed by this request as having occurred in a particular client session. Then using the undo/redo endpoints with the same ClientSessionId header this action can be undone/redone.

Content-Type String Yes The media type of the request body.

Default value: "application/json"

Request body fields

Name Type Required Description
filter_user_id Integer No

Optional: The user to filter the audit log by.

filter_from_timestamp String No

Optional: The start date to filter the audit log by.

csv_column_separator String No

The value used to separate columns in the resulting csv file.

  • , - ,
  • ; - ;
  • | - |
  • tab -
  • record_separator -
  • unit_separator -

Possible values:

  • "unit_separator"
  • ","
  • "|"
  • ";"
  • "tab"
  • "record_separator"

Default value: ","

url String Yes
filter_workspace_id Integer No

Optional: The workspace to filter the audit log by.

export_charset String No

The character set to use when creating the export file.

  • utf-8 - utf-8
  • iso-8859-6 - iso-8859-6
  • windows-1256 - windows-1256
  • iso-8859-4 - iso-8859-4
  • windows-1257 - windows-1257
  • iso-8859-14 - iso-8859-14
  • iso-8859-2 - iso-8859-2
  • windows-1250 - windows-1250
  • gbk - gbk
  • gb18030 - gb18030
  • big5 - big5
  • koi8-r - koi8-r
  • koi8-u - koi8-u
  • iso-8859-5 - iso-8859-5
  • windows-1251 - windows-1251
  • x-mac-cyrillic - mac-cyrillic
  • iso-8859-7 - iso-8859-7
  • windows-1253 - windows-1253
  • iso-8859-8 - iso-8859-8
  • windows-1255 - windows-1255
  • euc-jp - euc-jp
  • iso-2022-jp - iso-2022-jp
  • shift-jis - shift-jis
  • euc-kr - euc-kr
  • macintosh - macintosh
  • iso-8859-10 - iso-8859-10
  • iso-8859-16 - iso-8859-16
  • windows-874 - cp874
  • windows-1254 - windows-1254
  • windows-1258 - windows-1258
  • iso-8859-1 - iso-8859-1
  • windows-1252 - windows-1252
  • iso-8859-3 - iso-8859-3

Possible values:

  • "gb18030"
  • "iso-8859-10"
  • "shift-jis"
  • "iso-8859-14"
  • "koi8-u"
  • "euc-jp"
  • "windows-1253"
  • "windows-1255"
  • "windows-874"
  • "windows-1257"
  • "iso-8859-4"
  • "iso-2022-jp"
  • "iso-8859-2"
  • "gbk"
  • "iso-8859-8"
  • "iso-8859-6"
  • "windows-1251"
  • "x-mac-cyrillic"
  • "macintosh"
  • "iso-8859-1"
  • "koi8-r"
  • "big5"
  • "windows-1254"
  • "euc-kr"
  • "windows-1256"
  • "windows-1258"
  • "iso-8859-5"
  • "iso-8859-16"
  • "iso-8859-3"
  • "windows-1250"
  • "utf-8"
  • "iso-8859-7"
  • "windows-1252"

Default value: "utf-8"

exclude_columns String No

Optional: A comma separated list of column names to exclude from the export. Available options are user_email, user_id, workspace_name, workspace_id, type, description, timestamp, ip_address.

filter_action_type String No

Optional: The action type to filter the audit log by.

  • create_group - create_group
  • delete_group - delete_group
  • update_group - update_group
  • order_groups - order_groups
  • create_application - create_application
  • update_application - update_application
  • delete_application - delete_application
  • order_applications - order_applications
  • duplicate_application - duplicate_application
  • install_template - install_template
  • create_group_invitation - create_group_invitation
  • delete_group_invitation - delete_group_invitation
  • accept_group_invitation - accept_group_invitation
  • reject_group_invitation - reject_group_invitation
  • update_group_invitation_permissions - update_group_invitation_permissions
  • leave_group - leave_group
  • create_initial_workspace - create_initial_workspace
  • export_applications - export_applications
  • import_applications - import_applications
  • create_snapshot - create_snapshot
  • delete_snapshot - delete_snapshot
  • restore_snapshot - restore_snapshot
  • empty_trash - empty_trash
  • restore_from_trash - restore_from_trash
  • create_user - create_user
  • update_user - update_user
  • schedule_user_deletion - schedule_user_deletion
  • cancel_user_deletion - cancel_user_deletion
  • sign_in_user - sign_in_user
  • change_user_password - change_user_password
  • send_reset_user_password - send_reset_user_password
  • reset_user_password - reset_user_password
  • send_verify_email - send_verify_email
  • verify_email - verify_email
  • create_db_token - create_db_token
  • update_db_token_name - update_db_token_name
  • update_db_token_permissions - update_db_token_permissions
  • rotate_db_token_key - rotate_db_token_key
  • delete_db_token_key - delete_db_token_key
  • create_webhook - create_webhook
  • delete_webhook - delete_webhook
  • update_webhook - update_webhook
  • export_table - export_table
  • import_database_from_airtable - import_database_from_airtable
  • create_table - create_table
  • delete_table - delete_table
  • order_tables - order_tables
  • update_table - update_table
  • duplicate_table - duplicate_table
  • create_row - create_row
  • create_rows - create_rows
  • import_rows - import_rows
  • delete_row - delete_row
  • delete_rows - delete_rows
  • move_row - move_row
  • update_row - update_row
  • update_rows - update_rows
  • create_view - create_view
  • duplicate_view - duplicate_view
  • delete_view - delete_view
  • order_views - order_views
  • update_view - update_view
  • create_view_filter - create_view_filter
  • update_view_filter - update_view_filter
  • delete_view_filter - delete_view_filter
  • create_view_sort - create_view_sort
  • update_view_sort - update_view_sort
  • delete_view_sort - delete_view_sort
  • create_view_group - create_view_group
  • update_view_group - update_view_group
  • delete_view_group - delete_view_group
  • submit_form - submit_form
  • rotate_view_slug - rotate_view_slug
  • update_view_field_options - update_view_field_options
  • create_decoration - create_decoration
  • update_decoration - update_decoration
  • delete_decoration - delete_decoration
  • create_view_filter_group - create_view_filter_group
  • update_view_filter_group - update_view_filter_group
  • delete_view_filter_group - delete_view_filter_group
  • create_data_sync_table - create_data_sync_table
  • update_data_sync_table - update_data_sync_table
  • sync_data_sync_table - sync_data_sync_table
  • create_field - create_field
  • delete_field - delete_field
  • update_field - update_field
  • duplicate_field - duplicate_field
  • change_primary_field - change_primary_field
  • create_widget - create_widget
  • update_widget - update_widget
  • delete_widget - delete_widget
  • update_dashboard_data_source - update_dashboard_data_source
  • generate_formula_with_ai - generate_formula_with_ai
  • create_row_comment - create_row_comment
  • delete_row_comment - delete_row_comment
  • update_row_comment - update_row_comment
  • rotate_calendar_ical_view_slug - rotate_calendar_ical_view_slug
  • create_team - create_team
  • update_team - update_team
  • delete_team - delete_team
  • create_team_subject - create_team_subject
  • delete_team_subject - delete_team_subject
  • batch_assign_role - batch_assign_role
  • update_periodic_data_sync_interval - update_periodic_data_sync_interval

Possible values:

  • "delete_group"
  • "delete_view"
  • "duplicate_view"
  • "update_dashboard_data_source"
  • "update_user"
  • "create_widget"
  • "update_webhook"
  • "delete_team_subject"
  • "create_initial_workspace"
  • "create_view_sort"
  • "rotate_db_token_key"
  • "update_view_filter"
  • "update_widget"
  • "batch_assign_role"
  • "update_application"
  • "create_team_subject"
  • "update_rows"
  • "update_view_sort"
  • "update_data_sync_table"
  • "delete_widget"
  • "update_view_group"
  • "send_reset_user_password"
  • "create_view_filter_group"
  • "verify_email"
  • "order_applications"
  • "move_row"
  • "update_field"
  • "update_team"
  • "delete_view_sort"
  • "delete_db_token_key"
  • "reset_user_password"
  • "rotate_view_slug"
  • "sign_in_user"
  • "change_user_password"
  • "send_verify_email"
  • "create_snapshot"
  • "create_view_filter"
  • "delete_row_comment"
  • "install_template"
  • "order_views"
  • "leave_group"
  • "update_group_invitation_permissions"
  • "create_view_group"
  • "update_db_token_name"
  • "update_periodic_data_sync_interval"
  • "delete_decoration"
  • "reject_group_invitation"
  • "import_database_from_airtable"
  • "update_group"
  • "import_applications"
  • "empty_trash"
  • "update_decoration"
  • "create_row_comment"
  • "delete_team"
  • "delete_rows"
  • "restore_from_trash"
  • "delete_row"
  • "submit_form"
  • "update_table"
  • "create_group"
  • "update_db_token_permissions"
  • "delete_webhook"
  • "create_row"
  • "order_tables"
  • "create_db_token"
  • "create_webhook"
  • "update_view_field_options"
  • "export_table"
  • "update_view"
  • "delete_table"
  • "duplicate_field"
  • "create_user"
  • "delete_group_invitation"
  • "create_field"
  • "accept_group_invitation"
  • "delete_view_filter"
  • "update_row"
  • "duplicate_application"
  • "create_group_invitation"
  • "delete_view_filter_group"
  • "delete_application"
  • "create_view"
  • "generate_formula_with_ai"
  • "sync_data_sync_table"
  • "create_rows"
  • "create_data_sync_table"
  • "rotate_calendar_ical_view_slug"
  • "order_groups"
  • "import_rows"
  • "delete_snapshot"
  • "change_primary_field"
  • "delete_view_group"
  • "create_decoration"
  • "create_application"
  • "export_applications"
  • "create_table"
  • "create_team"
  • "restore_snapshot"
  • "delete_field"
  • "duplicate_table"
  • "schedule_user_deletion"
  • "cancel_user_deletion"
  • "update_view_filter_group"
  • "update_row_comment"
csv_first_row_header Boolean No

Whether or not to generate a header row at the top of the csv file.

Default value: true

filter_to_timestamp String No

Optional: The end date to filter the audit log by.

How to start integrating

  1. Add HTTP Task to your workflow definition.
  2. Search for the API you want to integrate with and click on the name.
    • This loads the API reference documentation and prepares the Http request settings.
  3. Click Test request to test run your request to the API and see the API's response.