QuotiDatabases icon

QuotiDatabases

Allows CRUD operations at Quoti tables
Join our community

Actions5

Overview

The node enables CRUD (Create, Read, Update, Delete) operations on Quoti tables (databases). It allows users to interact programmatically with Quoti database resources by specifying the target database and operation type. This is useful for automating workflows that involve managing data entries in Quoti tables, such as adding new records, updating existing ones, retrieving specific rows, listing multiple rows, or deleting entries.

Practical examples include:

  • Automatically creating new database entries from form submissions.
  • Updating records based on external triggers or data changes.
  • Fetching and processing data rows for reporting or integration with other systems.
  • Deleting obsolete or unwanted records programmatically.

Properties

Name Meaning
Database Name or ID The identifier or name of the Quoti database (table) to operate on. Can be selected from a list loaded dynamically or specified via an expression.
Operation The action to perform on the selected database. Options: create, delete, get, list, update.
ID Unique identifier of the resource (row) to operate on. Required for get, update, and delete operations.
Properties A collection of key-value pairs representing the properties to set on a record when creating or updating. Each property has a name (selected from available database properties) and a string value to assign.
Filter Used only for the list operation to filter results by a specific property and value.
Aggregate Rows In One Item For the list operation, determines whether all rows are aggregated into a single output item (true) or each row is output as a separate item (false).
Limit Maximum number of results to return for the list operation.
Options Additional optional parameters including:
- User Token: Overrides the default token used for authentication.
- Organization Slug: Overrides the default organization identifier.
- Organization API Key: Overrides the default API key.
- Body: JSON object to override the properties defined.
- Filter: JSON object to override filters defined.

Output

The node outputs items with a json field containing the response data from the Quoti API:

  • For get: Outputs the retrieved row data as JSON.
  • For list: Outputs either a single item with all rows aggregated under a results array or multiple items each representing one row, depending on the aggregation setting.
  • For create: Outputs a JSON object indicating success and the ID of the newly created record.
  • For update: Outputs a JSON object indicating success.
  • For delete: Outputs a JSON object indicating success.

No binary data output is produced by this node.

Dependencies

  • Requires an API key credential and organization slug for authenticating requests to the Quoti API.
  • Uses Axios for HTTP requests.
  • Requires n8n credentials configured with appropriate API access.
  • The node expects tokens to start with Bearer (for user tokens) or BearerStatic (for service account tokens).

Troubleshooting

  • Authentication Errors (401 Unauthorized):
    If the node returns an error indicating failure to authenticate, verify that the provided token or API key is correct and has sufficient permissions. Ensure the token starts with the required prefix (Bearer or BearerStatic).

  • Missing Credentials:
    The node throws an error if no credentials are found. Make sure the API credentials are properly configured in n8n.

  • Invalid Property Names or IDs:
    When specifying properties for create or update operations, ensure the property names match those available in the selected database. Use the dynamic options loading feature to select valid properties.

  • Malformed JSON in Options:
    If using the JSON body or filter override fields, ensure the JSON syntax is correct to avoid parsing errors.

  • API Rate Limits or Network Issues:
    Network failures or rate limiting by the Quoti API may cause request failures. Check network connectivity and API usage limits.

Links and References

Discussion