Need system API key and webhook to manage all workspaces for self hosted systems

[codearranger]

Scope & Context

When running a self-hosted twenty installation, and a user signs up we would like to trigger a script that would use the API to deploy our custom objects into the new workspace. For this we would need a system wide API key and a system wide webhook that would fire an event that a new workspace has been created, and then use the system wide API key to add the custom objects and configuration into the new workspace.

Current behavior

Currently you can only create an API key or webhook for a single user in an existing workspace.

Expected behavior

When a new workspace is created the webhook fires and our custom script would use the system API key to make changes to the newly created workspace.

Technical inputs

A system API key could be created with a yarn command or set from an environment variable
A webhook URL could be configured with a yarn command or set from an environment variable

[FelixMalfait]

For the API key, it should be possible to forge an access token for a given workspace with your APP_SECRET (set in .env).

From the codebase:

The value of type here should be ACCESS.
So if your secret is SECRET then you could create the token for workspace id xxx by computing

createHash('sha256')
      .update(`SECRETxxxACCESS`)
      .digest('hex');

For webhooks, maybe there's something to hack with Postgres Triggers on a self-hosted instance to register a webhook automatically when a table called webhooks is created. It's not pretty but the hack could work. I don't have a better idea for now, I'll keep this open an see if something comes up