Skip to main content

​
Intro

The JSON Webhook Advanced Connector enables you to connect your real-time data to Domo. Webhooks shows your real-time data from hundreds of devices, which lets you set alerts when time sensitive metrics change. Visualize your data in real-time dashboards with Domo, and combine your JSON data with other data sources for a comprehensive view. This connector enables you to parse the selected data in the Parsing section. You can set up your JSON Webhook Advanced connection by configuring options in the Data Center as well as in the third-party application, as described below.

​
Configure a JSON Webhook Advanced Connection

This section explains how to set up a JSON Webhook Advanced connection in Domo and in the third-party application. After you have set up a successful connection, you can use the same account any time you go to create a new JSON Webhook Advanced DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors. Follow these steps to configure a JSON Webhook Advanced connection:
  1. In the navigation header, select Appstore to open the Appstore.
  2. Search for and select the JSON Webhook Advanced Connector to display its details page.
  3. Select Get the Data.
  4. Select Copy Link.
  5. Paste the link you just copied into the appropriate location in your third-party application. This location will usually be a field with a name like “Payload URL,” like in the above screenshot. However, there are exceptions. Refer the third-party application’s documentation if you are not sure. Ensure to follow the third-party application’s requirements for pasting the URL. In some applications, the token (the piece after the last backslash) must be pasted in a different line.
  6. In the third-party application, ensure to set the content type to application/json.
  7. Configure other settings in the third-party application as necessary, and then save the webhook.
  8. Return to the JSON Webhook Advanced Connector interface in Domo.
  9. (Optional) Enter a Webhook Secret if desired. If a Webhook Secret is specified, Domo will expect a X-Hub-Signature header with every post. The value of the X-Hub-Signature is the HMAC (hash-based message authentication code) of the request body using the Webhook Secret and either SHA1, SHA256 or SHA512 hash algorithms.
  10. (Optional) If you want to include metadata in the DataSet, such as IP and timestamp, select Yes in the last menu in the Details view; or set to No.
  11. (Optional) If you want to use “Replace” instead of “Append” when the DataSet is updated, click Change update settings, select Replace in the menu, and then click Save.
  12. Select Next.
  13. Enter a DataSet name and description (optional) in the correct fields.
  14. Select Save.
You should now have a functional connector that collects data continuously from the third-party application and updates to Domo every 15 minutes.

​
Connecting to Your JSON Webhook Advanced Connector

The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

​
Details Pane

Menu

Description

Webhook URL

Copy the Webhook URL created from the above steps.

Webhook Secret

If your data provider supports secrets in the X-Hub signature, use sha1=(sha1 hashed payload, using secret as key). Create your own secret and enter in this field.

Webhook Signature Header

Enter your webhook secret header. By default, “X-Hub-Signature” is used. You can enter your own webhook secret header here.

Include Metadata about the Request, including the IP and Timestamp

Select the appropriate option to include or exclude Metadata about the Request including the IP and Timestamp.

Update Method

When Domo retrieves your data from the source, you can determine how that new data is imported into the current DataSet. For this connector we offer Append and Replace.

  • Append - This method fetches your new data and adds it to your current DataSet. Using this may create duplicate data entries.
  • Replace - This method will take your current DataSet and replace it with new data. Using this may result in some data loss.

    Learn more about update methods .

Reset Schema

Select this checkbox to reset the schema according to the current data.

​
Data Selection

In this section, you need to upload a JSON file, so that you can parse the data of your choice in the parsing section. You need a sample JSON file that the third party would send to Domo over the webhook. The sample JSON file must have the same structure as that of the third party that will be sent over the webhook.

​
Parsing

Using the data preview, you can click a column to format the data for parsing. Depending on the column data type, different parsing actions are available. If you mouse over an action, the dataset updates to reflect how the changes that will be applied. You can go back to an earlier action by clicking that action in the History pane on the right. Available actions include the following:
  • Expand Array as Rows: Expand contents of one columns in to their own rows.
  • Expand Array as Columns: Expand contents of one columns in to multiple columns.
  • Drop: Removes the column from the dataset.
  • Duplicate: Creates a copy of the column.
  • Rename column: Changes the name of the column in the dataset.