Cloudera Docs

Creating Webhook tables

You can configure the webhook table to perform an HTTP action per message (default) or to create code that controls the frequency (for instance, every N messages).

When developing webhook tables, it is useful to use hookbin to develop, and check your webhook before pointing at your true destination.

  1. Navigate to the Streaming SQL Console.
    1. Go to your cluster in Cloudera Manager.
    2. Select SQL Stream Builder from the list of services.
    3. Click SQLStreamBuilder Console.
    The Streaming SQL Console opens in a new window.
  2. Click Create Job or select a previous job on the Getting Started page.
    You are redirected to the Console page.
  3. Select Add table > Webhook.
    The Webhook Table window appears.
  4. Provide a name to the Table.
  5. Enter an HTTP endpoint. The endpoint must start with http:// or https://.
  6. Add a Description about the webhook sink.
  7. Select POST or PUT in the HTTP Method select box.
  8. Choose to Disable SSL Validation, if needed.
  9. Enable Request Template, if needed.
    1. If you selected Yes, then the template defined in the Request Template tab is used for output.
      This is useful if the service you are posting requires a particular data output format. The data format must be a valid JSON format, and use "${columnname}" to represent fields. For example, a template for use with Pagerduty looks like this:
      {
   "incident":{
      "type":"incident",
      "title":"${icao} is too high!",
        "body":{
   "type":"incident_body",
         "details":"Airplane with id ${icao} has reached an altitude of ${altitude} meters."
 }
    }
}
  10. In the Code editor, you can specify a code block that controls how the webhook displays the data.
    For a webhook that is called for each message the following code is used:
    // Boolean function that takes entire row from query as Json Object
function onCondition(rowAsJson)
{return true;   // return false here for no-op, or plug in custom
        logic}
onCondition($p0)
  11. Add HTTP headers using the HTTP Headers tab, if needed.
    Headers are name:value header elements. For instance, Content-Type:application/json, etc.
  12. Click Create.
The Webhook table is ready to be used after the INSERT INTO statement in your SQL query.