Skip to main content

How to Write External Data to a Worksheet via Webhook


Webhooks allow HAP to receive data pushed from external systems and write it to worksheets automatically.

Example Use Case​

Suppose you have an order management system. Whenever a new order is created in that system, you want to automatically create a corresponding order record in a HAP worksheet.

How It Works​

  1. A new order is submitted in the external order system, which pushes the order data to HAP.
  2. HAP receives the data and triggers a workflow.
  3. The workflow processes the received data and creates a new order record in the Orders worksheet.

Configure the Workflow​

  1. Create a Webhook-triggered workflow

    In the app containing the Orders worksheet, create a workflow triggered by a Webhook. This workflow will receive and process data pushed from the external system.

  2. Configure the Webhook

    We generate a Webhook URL to receive incoming requests. Copy the URL and configure it in your external system so that it can send data to HAP.

  3. Configure the request parameters

    Select Generate from Sample Request. Within 3 minutes, send a sample request to the Webhook URL from the external system.

    Once HAP receives the request, it automatically generates the corresponding parameters. Review the parameters, confirm them, and save the configuration.

  4. Add the data to the worksheet using an Add Record node

    Add an Add Record node to the workflow and configure it to write the received data to the Orders worksheet.

  5. Publish the workflow.

    Click Publish in the upper-right corner to activate the workflow. You can then start sending data to HAP from the external system.

  6. Test the workflow.

    Create a new order in your external system. After approximately 10 seconds, refresh the Orders worksheet. The new record should appear, with Workflow displayed as its creator.

Was this document helpful?