HAP icon

HAP

Interact with HAP (Hyper Application Platform) API

Actions31

Record → Batch Update

AI-generated

Overview

The "Batch Update" operation for the "Record" resource in this node allows users to update multiple records at once within a specified worksheet. This is useful when you need to modify several rows of data simultaneously, such as updating statuses, correcting values, or applying bulk changes without having to update each record individually.

Practical examples include:

  • Updating the status field of multiple customer orders to "shipped".
  • Changing the priority level of several tasks in a project management sheet.
  • Correcting or standardizing data entries across multiple rows in a spreadsheet-like application.

This batch update improves efficiency by reducing the number of API calls and automating repetitive update tasks.

Properties

Name Meaning
Worksheet ID The unique identifier of the worksheet containing the records to update.
Row IDs An array of row IDs specifying which records should be updated in the batch operation.
Fields An array of objects representing the fields to update for each record, with field IDs and new values.
Trigger Workflow Boolean flag indicating whether to trigger any associated workflow after the batch update operation completes.

Output

The output JSON contains the results of the batch update operation. Typically, it will include confirmation of the updated records, possibly with their updated field values or status indicators confirming success.

If the node supports binary data output (not explicitly shown here), it would represent any file or media content returned from the API, but for this operation, the focus is on JSON data reflecting the update results.

Dependencies

  • Requires an API key credential for authenticating with the Hyper Application Platform (HAP) API.
  • The node depends on the HAP API being accessible and properly configured.
  • No additional environment variables are explicitly required beyond the API authentication setup.

Troubleshooting

  • Common Issues:

    • Invalid or missing Worksheet ID or Row IDs can cause the operation to fail.
    • Incorrectly formatted Fields array may lead to errors or partial updates.
    • Network or authentication issues with the HAP API can prevent successful execution.

  • Error Messages:

    • Errors related to authorization typically indicate problems with the provided API key credential; verify that the credential is valid and has necessary permissions.
    • Validation errors about missing or malformed input properties suggest checking the format and presence of Worksheet ID, Row IDs, and Fields.
    • If the "Trigger Workflow" option causes unexpected behavior, try toggling it off to isolate workflow-related issues.

Links and References

Discussion