What you’ll build
You’ll create an integration that:- Extracts user records from JSONPlaceholder (a free test API)
- Transforms the data to a simpler format
- Loads the 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
Before building the integration, create a destination endpoint where you can verify the results.- Open webhook.site in a new browser tab
- The site automatically generates a unique URL (e.g.,
https://webhook.site/abc123-def456-...) - Copy this URL; you’ll need it when creating your destination Connection
- 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.- In the sidebar, click Connections
- Click New Connection
- Configure the connection:
- Click Save
Step 3: Create the destination Connection
Now create a Connection for your webhook.site destination.- Click New Connection
- Configure the connection:
- Click Save
Step 4: Create the Integration
With both Connections ready, create the Integration that moves data between them.- In the sidebar, click Integrations
- Click New Integration
General settings
Configure the basic integration properties:The schedule is set with a frequency picker: choose how often the integration runs and fill in the details, like the time of day. See Scheduling for all the options.
Extract phase
The Extract phase retrieves data from your source system.- Expand the Extract section
- Configure these fields:
-
Set the Datapoint Path in Response to
root - Set the Pagination:
- Check the Extract Preview panel on the right side. It should show:
- Status:
200 OK - A single user record (the Datapoint) like this:
- Status:
Transform phase
The Transform phase maps source fields to your destination format. For this quickstart, create a simple mapping with three fields.- Expand the Transform section
- Click Add Transformation and configure:
- Check the Transform Preview panel. It should display:
Load phase
The Load phase sends transformed data to your destination.- Expand the Load section
- Configure these fields:
- 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:
Step 5: Deploy the Integration
- Toggle Deployment to enabled
- Click Create Integration
Step 6: Run it now
You don’t need to wait for the schedule. Trigger the first run manually:- Open your integration from the Integrations list
- Click Run now, next to the Save button
- Confirm in the dialog, and a Run started message appears
Step 7: 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: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
- Run now triggers a run on demand, without waiting for the schedule
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