Integration with multiple extractions

​

What you’ll build

1. Extracts post records from JSONPlaceholder (a free test API)
2. Enriches each post by fetching its comments using a secondary API request
3. Transforms the data by combining fields from both the extract and enrichment responses
4. Loads the enriched results to webhook.site where you can inspect them

​

Prerequisites

• Access to an RWS Integration Workspace
• A web browser

​

Step 1: Set up your destination

1. Open webhook.site in a new browser tab
2. The site automatically generates a unique URL (e.g., https://webhook.site/abc123-def456-...)
3. Copy the unique path portion (e.g., /abc123-def456-...) — you’ll need it when configuring the Load phase
4. Keep this tab open to monitor incoming requests

​

Step 2: Create the source Connection

1. In the sidebar, click Connections
2. Click New Connection
3. Configure the connection:

4. Leave Header Parameters and Query Parameters empty
5. Click Save

​

Step 3: Create the destination Connection

1. Click New Connection
2. Configure the connection:

3. Click Save

​

Step 4: Create the Integration

1. In the sidebar, click Integrations
2. Click New Integration

​

General settings

​

Extract phase

1. Expand the Extract section
2. Configure these fields:

3. Set the Datapoint Path in Response to root
4. Set the Pagination:

5. Check the Extract Preview panel on the right side — it should show:
   • Status: 200 OK
   • A single post record (the Datapoint) like this:
   {
        "userId": 1,
        "id": 1,
        "title": "sunt aut facere repellat provident occaecati excepturi optio reprehenderit",
        "body": "quia et suscipit\nsuscipit recusandae consequuntur expedita et cum\nreprehenderit molestiae ut ut quas totam\nnostrum rerum est autem sunt rem eveniet architecto"
    }
   

​

Enrichment phase

1. Expand the Enrichment section
2. Click Add Enrichment
3. Configure the enrichment:

4. The enrichment will automatically use the id value extracted from the post to make a request to /posts/{id}/comments.
5. Check the Extract Preview panel on the right side — it should show:
   • Status: 200 OK
   • An array of comment records like this:
   [
    {
        "postId": 1,
        "id": 1,
        "name": "id labore ex et quam laborum",
        "email": "Eliseo@gardner.biz",
        "body": "laudantium enim quasi est quidem magnam voluptate ipsam eos\ntempora quo necessitatibus\ndolor quam autem quasi\nreiciendis et nam sapiente accusantium"
    },
    {
        "postId": 1,
        "id": 2,
        "name": "quo vero reiciendis velit similique earum",
        "email": "Jayne_Kuhic@sydney.com",
        "body": "est natus enim nihil est dolore omnis voluptatem numquam\net omnis occaecati quod ullam at\nvoluptatem error expedita pariatur\nnihil sint nostrum voluptatem reiciendis et"
    },
   ]
   

​

Transform phase

1. Expand the Transform section
2. Click Add Transformation and configure fields from the main Extract:

3. Click Add Transformation again and configure fields from the Enrichment:

4. Check the Transform Preview panel — it should display:

{
  "postId": 1,
  "postTitle": "sunt aut facere repellat provident occaecati excepturi optio reprehenderit",
  "postBody": "quia et suscipit...",
  "firstCommentEmail": "Eliseo@gardner.biz",
  "firstCommentText": "laudantium enim quasi est quidem magnam voluptate..."
}

​

Load phase

1. Expand the Load section
2. Configure these fields:

3. Check the Load Preview panel — it shows the complete request that will be sent:
   • Path: https://webhook.site/{{your-unique-path}}
   • Method: POST
   • Request Body:

{
  "postId": 1,
  "postTitle": "sunt aut facere repellat provident occaecati excepturi optio reprehenderit",
  "postBody": "quia et suscipit...",
  "firstCommentEmail": "Eliseo@gardner.biz",
  "firstCommentText": "laudantium enim quasi est quidem magnam voluptate..."
}

​

Step 5: Deploy the Integration

1. Toggle Deployment to enabled
2. Click Create Integration

​

Step 6: Verify the results

{
  "postId": 1,
  "postTitle": "sunt aut facere repellat provident occaecati excepturi optio reprehenderit",
  "postBody": "quia et suscipit...",
  "firstCommentEmail": "Eliseo@gardner.biz",
  "firstCommentText": "laudantium enim quasi est quidem magnam voluptate..."
}

​

What you learned

• Connections store configuration for external systems and can be reused across multiple Integrations
• Integrations follow the Extract → Enrichment → Transform → Load pattern
• Preview panels automatically update as you configure each phase, letting you validate before running
• Simple transformations map fields from source to destination using JSONPath notation
• Enrichment allows you to fetch additional data for each datapoint extracted in the main Extract phase
• Dynamic parameters (like {{id}}) in enrichment paths are interpolated from extracted datapoints
• Enrichment data is accessed in Transform using resources.{{enrichmentName}}.{{fieldPath}}

​

Next steps