QuotiDatabases icon

QuotiDatabases

Allows CRUD operations at Quoti tables

Actions5

Overview

The QuotiDatabases node enables you to perform CRUD (Create, Read, Update, Delete) operations on tables within the Quoti platform. Specifically, for the Default resource and the Create operation, this node allows you to add new records to a specified database table in Quoti.

Common scenarios:

  • Automating the creation of new entries in a Quoti database from other n8n workflows.
  • Integrating form submissions or external data sources directly into Quoti tables.
  • Streamlining onboarding or registration processes by programmatically adding user data.

Practical example:
You could use this node to automatically create a new student record in your Quoti database whenever a new signup is received via a web form.

Properties

Name Type Meaning
Database Name or ID options The target database/table in Quoti where the new record will be created. You can select from a list or specify an ID/URL using an expression.
Properties fixedCollection Key-value pairs representing the fields and their values to set in the new record. Each property includes:
- Name or ID: The field name or ID in the database.
- Value: The value to assign to that field.
Options collection Additional configuration options:
• User Token: Override the default token for authentication.
• Organization Slug: Override the organization slug.
• Organization API Key: Override the API key.
• Body: Provide a raw JSON body to override the above properties.

Output

  • On success, the output will be:

    {
  "sucess": true
}
    • This indicates that the record was successfully created in the specified Quoti table.

  • On error, the output will include an error object with details, such as:

    {
  "error": {
    "message": "The user could not be retrieved. There is a problem with the user's token or the api key.",
    "type": "unauthenticated"
  }
}

    or

    {
  "error": {
    "message": "Unknown error: <error message>",
    "type": "unknown",
    "errorData": { ... }
  }
}

  • No binary data is produced by this operation.

Dependencies

  • External Service: Requires access to the Quoti API (https://api.minhafaculdade.app/api/v1/).
  • API Credentials: Needs valid Quoti API credentials (API Key and Organization Slug), typically provided via n8n credentials named quotiApi.
  • Optional Authentication Overrides: You may provide a User Token, Organization Slug, or API Key directly in the node's options to override the defaults.

Troubleshooting

Common issues:

  • Authentication errors:
    • Error message: "The user could not be retrieved. There is a problem with the user's token or the api key."
      • Resolution: Check that your API Key and User Token are correct and have not expired. Ensure the token starts with Bearer or BearerStatic as required.
  • Invalid input data:
    • If the Properties or Body fields contain invalid JSON or do not match the expected schema, the API may reject the request.
  • Missing required fields:
    • Ensure all required fields (such as Database Name or ID and at least one property) are provided.

Links and References

Discussion