HIGH story-member-system-integration-global-admin-002 5 pts
5
Story Points
High
Priority
Member System Integration
Feature

User Story

As a administrator
I want to configure the API credentials, sync schedule, and delta sync webhook settings for the Cornerstone member management system integration
So that So that the app can automatically pull membership status, role changes, and affiliation updates from Cornerstone and keep member records current without manual intervention

Acceptance Criteria

  • Given I have valid Cornerstone API credentials, when I enter them and click 'Test Connection', then the system returns a success response within 10 seconds
  • Given the test connection passes, when I save the configuration, then the Cornerstone sync service activates and the first full sync is scheduled
  • Given I configure a webhook URL for delta sync, when Cornerstone fires a membership change event, then the sync service processes the event and updates the member record within 5 minutes
  • Given invalid credentials are entered, when I click 'Test Connection', then I see a descriptive error message indicating whether the API key, base URL, or network is at fault
  • Given an Organization Administrator, when they access integration config, then they can only configure settings for their own organization and not view other organizations' credentials

Business Value

Cornerstone is the authoritative membership registry for several member organizations. Without a configured integration, membership lapses and role changes in Cornerstone are not reflected in the app, causing unauthorized access to persist and active members to be incorrectly blocked. Automated synchronization eliminates the manual reconciliation work that currently consumes significant administrative time and introduces a lag of days between source system changes and app state.