Webhooks in Jitterbit App Builder

Overview

App Builder supports the ability to invoke an event in response to an email, text message, or an API call to an App Builder endpoint using Webhooks. Webhooks are user-defined HTTP callbacks, and are typically triggered by an event. When the specified event occurs, the source site makes an HTTP request to the URL configured for the Webhook.

An example of a Webhook in App Builder is if an App Builder application sends an email to a user asking her to approve or reject a transfer. The user would reply to the email, typing either "approve" or "disapprove" in the message body. If the user replies with "approve" App Builder invokes one event; "disapprove", another event is invoked. This feature allows the user to respond to the email or text message without leaving the application.

How to configure a webhook

In this example we have an App Builder application that is used for order management. The user wants to be able to create a new order via an API call and receive the order number in the API response. The purpose for the Webhook will be to generate a new Order record, calculate the order number, and return that order number in the response.

Our Order table has an OrderID (PK), Company name, Product name, and OrderNumber:

Step 1: Add webhook in data servers

1. Create Server:

   • Navigate to IDE, Data Servers and click on +Server
   • Assign a Server Name. For example: OrderWebhook
   • Select Type as Webhook API under web services
   • Choose appropriate Request/Response Content Type Content, in our example they are both JSON

   • Click Save and close the popup:

     

2. Create Endpoint:

   • Click the Data Server Details button
   • Click the Endpoints button
   • Click +Endpoint in the Endpoints panel

   • Name your endpoint. For example: PostOrder

     Note

     This Name will not appear in the Webhook URL.

   • Select the HTTP Method that your Webhook uses. Typically this will be a POST to update information in a table.

   • Click the checkmark icon to save

3. Create Endpoint Parameters:

   • Click on Discover from the Endpoints panel

   • If the Webhook accepts a body (e.g., a POST using JSON or XML Request content type), provide a sample Request Body. For our example, our JSON is:

     {
         "Company": "Jitterbit",
         "Product": "App Builder"
     }
     

     (We will generate the OrderID and OrderNumber as part of the events triggered by the Webhook)

     

   • Click Save

   • Click on Discover. This will automatically add the input Endpoint Parameters.

4. If desired, add the Response endpoint parameter. In our example, it would be type String, Length -1 characters, with no test value, no type selected for Cookie/Header/Query, and Direction is Output.

Step 2: Add webhook to your application

1. Navigate to App Workbench > Data Sources
2. Click + Source
3. Select Link to existing source
4. Click Next
5. Select the REST Webhook API configured in Step 1
6. Click the Link button
7. Review the summary of what App Builder will perform and click Done

Step 3: Create a webhook business rule

1. Navigate to App Workbench > Rules.
2. Confirm the selected App Data Source is your newly created Webhook data source and not your application data source

3. Click + Rule

   

4. Assign a Name. For example: Order (Webhook)

5. Select Webhook as Purpose
6. Select the Webhook Data Source as Source Data Source
7. Set Target to the Webhook endpoint
8. Click Save
9. Add your Endpoint table and select all columns. In our example this is the PostOrder table.

Step 4: Create XP CRUD business rules

Create an XP CRUD Business Rule that Inserts the value received from the Webhook into a table in your Application's Data Source.Create an XP CRUD Business Rule that Inserts the value received from the Webhook into a table in your Application's Data Source. This should be registered to the Webhook data source like the Webhook object we just created. A few notes:

• Order table must allow public Read/Write which is configurable under the Order table's Edge Case settings in the table design
• Target layer must be set to Logic Layer

We will add a column to generate a PK using the newuuid() function and add the Company and Product columns from our webhook object with appropriate targets:

Step 5: Create an XP CRUD business rule

Create an XP CRUD Business Rule that Updates and writes a response with the new Order's OrderNumber.

1. Create a new XP CRUD rule registered to the Webhook data source. For example, PostOrder (Update Response)
2. Set action to Update
3. Source Data Source to your application's Data Source
4. Target Data Source to your Webhook's Data Source
5. Set the Target Layer to Logic Layer
6. Set the Target to your Webhook Object. For example, Order Webhook
7. Add Order table from application Data Source
8. Add OrderNumber Column targeting the Response column

9. Add Where clause that filters based on the newly generated order (we utilize the generated function to retrieve the OrderID generated in this event)

   

Step 6: Add the CRUD business rules as actions

Add the two CRUD Business Rules created to the Logic Layer Insert Event of the Webhook Business Rule.

Step 7: Expose webhook to the world

Create an Endpoint for your Application. This may already have been done for your application.

1. Navigate to the App Builder IDE > REST APIs (Under Connect) > Webhooks
2. Click the Manage Endpoints button
3. Select the application you want to enter the endpoint value for. For example: WebhookDocumentation.
4. Click the pencil edit icon for the application you are configuring
5. Enter the Endpoint value into the Endpoint field. For example WebhookDoc
6. Click proceed to save
7. To configure the Webhook Object, from the Webhooks Panel click on +Webhook
8. Select your Webhook Object. It will automatically select an Endpoint Name. This will become the webhook portion of the Webhook URL.

9. Click Save

   

Step 8: Create an API key for a user to access this webhook

We will create a basic API key and assign it to a user to access this Webhook. This can be done once for a Service User, or multiple times for individual users.

1. Navigate to the IDE, Security Providers
2. Under User Authentication create a record of type HTTP Basic Authentication if one does not exist. If one does, you can skip this step
3. Navigate to IDE, User Management
4. Select the User that needs a Key
5. Under Authentication click Keys
6. Click Create
7. For Provider select the security provider of type HTTP Basic Authentication from steps 1 & 2
8. Click Save
9. Write down the generated Identifier and Key as this information will not be available again

Step 9: Test

You can test this Webhook using Postman or Insomnia. Send a POST API call with the Body similar to the Body Sample used to create the parameters in Step 1. You will use basic authentication with the identifier as the Username and Key as the password from the previous step.

For testing, use the link: https://<url>/webhook/v1/<application-endpoint>/<endpoint>

In the scenario where no authentication is required, in lieu of configuring an x-api-key in the header you can potentially adjust the url to one of these options:

1. https://{{user's identifier from Step 8.9}}:{{user's key from Step 8.9}}@{{url from step9}} (to be used if the provider is http basic auth with no parameters)

   Caution

   The HTTP basic method described above requires the Authorization header to be included in the received payload. To bypass this, use the API Key method instead.

2. https://{{url from step9}}?apiKey={{user's key from Step 8.9}} (to be used if the provider is API Key and the Properties include HttpHeaderName 'X-API-Key')