Skip to main content
This guide walks you through creating a working integration that extracts user data from a public API and delivers it to a webhook endpoint. By the end, you’ll understand the core workflow: create Connections, build an Integration, and run it.

What you’ll build

You’ll create an integration that:
  1. Extracts user records from JSONPlaceholder (a free test API)
  2. Transforms the data to a simpler format
  3. Loads the results to webhook.site where you can inspect them
Time required: approximately 5 minutes.

Prerequisites

  • Access to an RWS Integration Workspace
  • A web browser

Step 1: Set up your destination

Before building the integration, create a destination endpoint where you can verify the results.
  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 this URL — you’ll need it when creating your destination Connection
  4. Keep this tab open to monitor incoming requests
webhook.site is a free service that captures and displays HTTP requests. It’s useful for testing integrations before connecting to real destination systems.

Step 2: Create the source Connection

Connections define how RWS Integration communicates with external systems. You’ll create one for the source API.
  1. In the sidebar, click Connections
  2. Click New Connection
  3. Configure the connection:
FieldValue
NameJSONPlaceholder API
TypeAPI
URLhttps://jsonplaceholder.typicode.com
Base Path/
AuthenticationSimple
  1. Leave Header Parameters and Query Parameters empty
  2. Click Save
The JSONPlaceholder API doesn’t require authentication, so the Simple authentication type with no additional parameters works.

Step 3: Create the destination Connection

Now create a Connection for your webhook.site destination.
  1. Click New Connection
  2. Configure the connection:
FieldValue
NameWebhook Destination
TypeAPI
URLhttps://webhook.site
Base Path/
AuthenticationSimple
  1. Click Save

Step 4: Create the Integration

With both Connections ready, create the Integration that moves data between them.
  1. In the sidebar, click Integrations
  2. Click New Integration

General settings

Configure the basic integration properties:
FieldValue
NameUser Sync Quickstart
Version1.0.0
TypeFull
EnvironmentStaging
Schedulerate(1 day)

Extract phase

The Extract phase retrieves data from your source system.
  1. Expand the Extract section
  2. Configure these fields:
FieldValue
ConnectionJSONPlaceholder API
MethodGET
Path/users
  1. Set the Datapoint Path in Response to root
  2. Set the Pagination:
FieldValue
Pagination TypeSimple
Page size parameter_limit
Page size value10
Initial page parameter_page
Initial page value1
Pagination end typeObject
  1. Check the Extract Preview panel on the right side — it should show:
    • Status: 200 OK
    • A single user record (the Datapoint) like this:
{
  "id": 1,
  "name": "Leanne Graham",
  "username": "Bret",
  "email": "Sincere@april.biz",
}

Transform phase

The Transform phase maps source fields to your destination format. For this quickstart, create a simple mapping with three fields.
  1. Expand the Transform section
  2. Click Add Transformation and configure:
TypeFromTo
SimpleiduserId
SimplenamefullName
SimpleemailemailAddress
  1. Check the Transform Preview panel — it should display:
{
  "userId": 1,
  "fullName": "Leanne Graham",
  "emailAddress": "Sincere@april.biz"
}
This confirms your mappings are working correctly with real data from the Extract phase.

Load phase

The Load phase sends transformed data to your destination.
  1. Expand the Load section
  2. Configure these fields:
FieldValue
ConnectionWebhook Destination
MethodPOST
PathYour webhook.site unique path (e.g., /abc123-def456-...)
Load TypeSimple
Copy only the path portion from your webhook.site URL. If your full URL is https://webhook.site/abc-123, enter /abc-123 as the Path.
  1. Check the Load Preview panel — it shows the complete request that will be sent:
{
  "userId": 1,
  "fullName": "Leanne Graham",
  "emailAddress": "Sincere@april.biz"
}

Step 5: Create the Integration

  1. Toggle Deployment to enabled
  2. Click Create Integration
Since we configured rate(1 day) as the schedule, the integration will execute immediately upon creation. After that, it will run automatically every 24 hours.

Step 6: Verify the results

Switch to your webhook.site browser tab. You should see 10 incoming POST requests (one for each user from JSONPlaceholder), each containing your transformed data structure:
{
  "userId": 1,
  "fullName": "Leanne Graham",
  "emailAddress": "Sincere@april.biz"
}
Congratulations — you’ve built and run your first integration!

What you learned

  • Connections store configuration for external systems and can be reused across multiple Integrations
  • Integrations follow the Extract → Transform → Load pattern (with optional Enrichment)
  • The Datapoint Path tells RWS Integration where to find records in API responses
  • 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
  • Environments (Staging/Production) let you safely test before deploying to production

Next steps

Connections

Learn about different authentication methods

Pagination

Handle pagination and complex API responses

Business Rules

Master field transformations with JavaScript

Scheduling

Schedule your integrations to run automatically