QuotiDatabases icon

QuotiDatabases

Allows CRUD operations at Quoti tables

Actions5

Overview

The QuotiDatabases node allows you to perform CRUD (Create, Read, Update, Delete) operations on tables within the Quoti platform. The List operation for the Default resource retrieves rows from a specified database table. This is useful for automating data extraction, reporting, or integrating Quoti data with other systems.

Common scenarios:

  • Fetching all records from a specific Quoti database table for further processing.
  • Integrating Quoti data into workflows for analytics, notifications, or synchronization with other platforms.

Example use cases:

  • Retrieve student records from a "Students" table and send personalized emails.
  • Export all entries from a "Leads" table to a Google Sheet.

Properties

Name Type Meaning
Database Name or ID options The identifier or name of the Quoti database table to query. You can select from a list or provide an ID/URL directly.
Raw Data boolean If set to true, the output will be a single item containing all results in an array. If false, each result will be output as a separate item.
Options collection Additional optional settings:
- User Token: Override the default token for authentication.
- Organization Slug: Override the organization slug from credentials.
- Organization API Key: Override the API key from credentials.
- Body: Provide a custom JSON body to override properties (not typically used for List).

Output

  • If Raw Data is true:

    {
  "rows": [ /* array of row objects returned by the API */ ]
}

  • If Raw Data is false:
    Each output item contains one row object from the table.

  • Error Handling:
    If an error occurs (e.g., authentication failure), the output will include an error field:

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

Dependencies

  • External Service: Requires access to the Quoti API (https://api.minhafaculdade.app/api/v1/).
  • API Credentials: Needs a valid Quoti API Key and Organization Slug, provided via n8n credentials (quotiApi).
  • Optional: User Token can be supplied to override default authentication.

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, Organization Slug, and (if used) User Token are correct and have not expired.
  • Invalid Table Name/ID:
    • If the specified table does not exist, the node may return an empty result or an error from the API.
  • Token Format:
    • The User Token must start with Bearer or BearerStatic . Otherwise, an error will be thrown.

Links and References

Discussion