mittwald icon

mittwald

Interact with mittwald mStudio API

Actions409

Overview

This node operation allows you to create a new MySQL database within a specified project using the Mittwald mStudio API. It is useful for automating database provisioning tasks, especially when managing multiple projects or environments programmatically. For example, you can use this node to quickly set up a new MySQL database with custom character settings and user configurations as part of your deployment workflow.

Properties

Name Meaning
Project Id The unique identifier of the project where the MySQL database will be created.
Database JSON object defining the database configuration, including character settings and options.
User JSON object specifying the user details associated with the new database.

Output

The node outputs JSON data representing the response from the API after attempting to create the MySQL database. This typically includes details about the newly created database such as its ID, status, and configuration. There is no indication that binary data is output by this node.

Dependencies

  • Requires an API key credential for authenticating with the Mittwald mStudio API.
  • The node uses the base URL https://api.mittwald.de to send requests.
  • The node depends on the @devlikeapro/n8n-openapi-node package for building properties and handling OpenAPI integration.

Troubleshooting

  • Common issues:
    • Invalid or missing Project Id may cause the API to reject the request.
    • Malformed JSON in the Database or User fields can lead to parsing errors.
    • Insufficient permissions or invalid API credentials will result in authentication failures.
  • Error messages:
    • Authentication errors usually indicate problems with the provided API key; verify and update credentials.
    • Validation errors from the API often point to incorrect or incomplete database/user configuration JSON; ensure all required fields are correctly formatted.
    • Network or connectivity errors suggest checking internet access or API endpoint availability.

Links and References

Discussion