Opencell icon

Opencell

Consume Opencell API

Overview

The Order: Update Order User Account operation in the Opencell n8n node allows you to update the user account associated with a specific commercial order in the Opencell system. This is useful for scenarios where you need to change or correct the user account linked to an existing order, such as when a customer changes their account details or if there was an error during the initial order creation.

Practical examples:

  • Updating the user account on an order after a customer merges accounts.
  • Correcting a misassigned user account on a commercial order.
  • Automating user account updates in bulk for orders via workflow triggers.

Properties

Name Type Meaning
Authentication options Selects the authentication method for connecting to Opencell (Basic Authentication or OAuth2).
Commercial Order ID number The unique identifier of the commercial order to be updated.
User Account Code string The code of the user account that should be set/updated for the specified order.
Body Content Type hidden Internal property; always set to "multipart-form-data". Not user-configurable.

Output

  • The output will be a JSON object containing the response from the Opencell API after updating the user account for the specified commercial order.
  • The structure of the json field depends on the Opencell API's response for this endpoint, but typically includes status information and possibly the updated order details.

Example output:

{
  "json": {
    // ...fields returned by Opencell API, e.g.,
    "status": "SUCCESS",
    "message": "User account updated successfully",
    "orderId": 12345,
    "userAccountCode": "UA001"
  }
}

Dependencies

  • External Service: Requires access to an Opencell instance with the REST API enabled.
  • Authentication: You must configure either Basic Authentication or OAuth2 credentials in n8n for Opencell.
  • n8n Configuration: Credentials must be set up in the n8n credential store under the names opencellApi (for Basic Auth) or opencellOAuth2Api (for OAuth2).

Troubleshooting

Common issues:

  • Invalid Credentials: If authentication fails, ensure your credentials are correct and have sufficient permissions.
  • Order/User Account Not Found: If the provided Commercial Order ID or User Account Code does not exist, the API will likely return an error.
  • API Connectivity Issues: Network problems or incorrect Opencell API URLs can cause connection errors.

Error messages and resolutions:

  • "Username/password error. Error code : XXX": Check your username and password in the n8n credentials.
  • "Host error. Error code : XXX": Verify the Opencell API URL and network connectivity.
  • "Invalid credentials (unknown error)": Double-check all credential fields and try re-authenticating.
  • "Resource not found" or similar: Ensure the Commercial Order ID and User Account Code are valid and exist in Opencell.

Links and References

Discussion