HAP icon

HAP

Interact with HAP (Hyper Application Platform) API

Actions31

Overview

This node interacts with the HAP (Hyper Application Platform) API to update a specific record in a worksheet. It allows users to modify one or more fields of an existing record by specifying the worksheet and record identifiers along with the new field values. This operation is useful for automating updates to data entries within HAP worksheets, such as correcting information, adding new details, or triggering workflows based on updated data.

Practical examples:

  • Automatically updating customer contact details when new information is received.
  • Changing the status of a task record after completion.
  • Modifying inventory quantities in response to sales or restocking events.

Properties

Name Meaning
Worksheet ID The unique identifier of the worksheet containing the record to update.
Record ID The unique row ID of the record that needs to be updated.
Fields An array of objects specifying which fields to update and their new values. Each object must have an ID (field identifier or alias) and a value (new value for the field). Example: [{"ID": "field1", "value": "newValue"}].
Trigger Workflow Boolean flag indicating whether to trigger any associated workflow after the update operation. Defaults to true.

Output

The node outputs JSON data representing the updated record as returned by the HAP API. This typically includes the record's identifiers and the current state of its fields after the update. If the node supports binary data output, it would represent related file attachments or media linked to the record, but this operation primarily deals with JSON data.

Dependencies

  • Requires an API key credential for authenticating with the HAP API.
  • The node expects network access to the HAP service endpoint.
  • Proper configuration of the API authentication credentials in n8n is necessary.

Troubleshooting

  • Common issues:

    • Invalid or missing Worksheet ID or Record ID will cause the update to fail.
    • Incorrectly formatted Fields JSON array may result in errors or no changes applied.
    • Insufficient permissions or invalid API credentials can lead to authorization errors.
    • Setting Trigger Workflow to false might prevent downstream automation from running, which could be unexpected.

  • Error messages and resolutions:

    • "Record not found" — Verify that the provided Worksheet ID and Record ID are correct and exist.
    • "Invalid fields format" — Ensure the Fields property is a valid JSON array with objects containing both ID and value.
    • "Unauthorized" or "Authentication failed" — Check that the API key credential is correctly configured and has sufficient permissions.
    • "Workflow trigger failed" — If workflows do not run after update, confirm that the Trigger Workflow option is enabled and that workflows are properly set up in HAP.

Links and References

Discussion