When to use
- The source system only offers SOAP web services (common in HR, payroll and fiscal ERPs)
- Getting one complete record requires calling several SOAP operations and combining the results
- The service returns deeply nested XML that would be painful to consume directly
- You need both a scheduled feed of changes and a backfill of historical data
How it works
- RWS Connect calls the SOAP operations for you, with authentication, pagination and retries included
- The pipeline combines and flattens the results: data from multiple operations is joined into complete records, and nested XML becomes flat columns
- Your integration extracts the table through the RWS Connect API, like any other REST source
What you provide
Requesting the connector
Email connect@rwsintegration.com with the items above to open a ticket.Your table is ready within two business days (SLA) after access and the information above are provided. If access requires a VPN, VPN setup takes an additional two business days before the pipeline is built.
How your data appears
- One table per dataset, named as agreed in the ticket
- Nested XML structures flattened into
snake_casecolumns - Each column is prefixed with the operation or endpoint it came from (for example
employees_nameandcontracts_start_date), and every record is delivered as a single flat JSON object (see Column prefixes) - Every run adds a snapshot stamped with the extraction date, so history is preserved. A one-time backfill can load past periods
- Standard columns on every table:
extracted_at,extraction_date,extract_start_date_parameter,extract_end_date_parameter
Next steps
RWS Connect
Understand how RWS Connect works
Querying the RWS Connect API
Filters, aggregations, pagination and more