The FTWilliam.com integration sends clean census data straight from Stax.ai CX to FTWilliam.com for compliance and testing. Census data comes into CX through payroll connections or uploaded reports, gets scrubbed and reviewed, and then transmits to FTWilliam.com — either automatically as a project task or manually from the Participants page.
Prerequisites
Admin access in CX (team integrations are admin-only).
An FTWilliam.com account with your ftwLink API Path and Key ID. Log in to FTWilliam.com to find these, or contact FTWilliam.com support.
A custom census grid set up in FTWilliam.com that matches the file format CX sends. See Configuring an FTWilliam.com Census Grid.
Connect the integration
Click your profile icon in the bottom-left corner and select Settings.
Click the Integrations tab.
Under Add Integration, click the FTWilliam.com tile. The Connect FTWilliam.com window opens.
Paste your ftwLink API Path into the API Path field.
Paste your Key ID into the Key ID field.
Click Save. FTWilliam.com now appears under Live Integrations.
Required fields explained
API Path — the ftwLink API address from your FTWilliam.com account. It tells CX where to send your data.
Key ID — the API key that proves the request comes from your firm.
Configure Custom Census Import Grid (optional) — maps FTW grid headings to CX census fields if your grid uses custom columns.
Transmit census data automatically
Open a census review project that is linked to a plan.
Create a task for the transmission step.
Click Attach Automation.
Search for and select Transmit census data to FTWilliam.com.
Set the plan year, or link it to the project's plan year field.
Save the automation. When the task runs, the census data transmits to FTWilliam.com.
Transmit census data manually
Navigate to the Participants page and select the client.
Click More in the top-right corner.
Select Transmit census to FTW. The data transmits to FTWilliam.com right away.
You're all set! Your census data now flows from CX to FTWilliam.com.
Tips
Tip: Use the Annual Census Data Review for FTW project template. It places the transmission task at the right point in the workflow — usually right after the manual census review.
Note: Need extra fields on your census file? Contact your Client Success Specialist. They can prepare a custom grid and configure your account to use it.
Related articles
Integrations Overview
Datair Integration
