All possible data tables in the Zammad REST/JSON api

[rtebbnc]

I am trying to create a script that is capable of exporting the entirety of Zammad to spreadsheets that can be manually uploaded at any point in the future.

What are all of the possible data tables that can be exported from zammad through the REST/JSON api?

For example,
https://zammad.mydomain.net/api/v1/users
or
https://zammad.mydomain.net/api/v1/tickets

I would like to be able to export all of the tables, tickets, users…etc. The main reason being that we would like to not only be able to manually make changes to the data, but to have backups that can be reimported if we ever chose to use mysql over postgresql.

Better yet, is there a way to get into the zammad sql database?

[MrGeneration]

Zammad does never, at any point, return all available information.
Your best friend in that case is pagination: Introduction — Zammad documentation

[rolfschmidt]

Rolfs-TableSearch - Search your database tables via REST (Package)

Hi, here is another new feature I’m currently working on. It is a bit like a Table API. It provides a generic endpoint to search database tables in zammad with a lot of condition features. I saw a lot of people scripting and trying to gather information via REST for reports and exports. This might be a cool workaround to catch a lot of a data. You just need an administrator account, and then it is possible to get all database table information. Be aware that this package is pretty fresh and i…