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

Development
1

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 in early development, so expect some bugs. Feel free to support.

2

Hi @silvermind, @FreeMinded,

I saw your notes on Time Accounting Types · Issue #4533 · zammad/zammad · GitHub.

You might be interested to try out my new hobby project. E.g. for your use case:

$ curl -s -u"admin@example.com:test" "http://ubuntu-rs:3000/api/v1/tables/ticket_time_accountings?created_at_ge=2023-09-08&created_at_le=2024-01-01" | jq .
[
  {
    "id": 1,
    "ticket_id": 1,
    "ticket_article_id": 11,
    "time_unit": "55.0",
    "type_id": null,
    "created_by_id": 3,
    "created_at": "2023-09-08T09:35:39.923Z",
    "updated_at": "2023-09-08T09:35:39.923Z"
  }
]