write_users
Create or update user accounts in CData Sync with configurable roles, passwords, and access settings. Manage single users or bulk operations for authentication and permissions.
Instructions
Create or update CData Sync users.
PASSWORD REQUIREMENTS: Must contain uppercase, lowercase, numbers, AND special characters.
RETURNS:
create: New user details with confirmation
update: Updated user information
COMMON ERRORS:
"Invalid password" - Must meet complexity requirements
"User already exists" - Use unique usernames
"Invalid role" - Use exact role values (cdata_admin, etc.)
"Bulk creation failed" - Check individual user errors
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | Create new users or update existing. No delete available. | |
| user | No | Username for single operations. Must be unique. Case-sensitive. | |
| password | No | Password must be 8+ characters with uppercase, lowercase, numbers, AND special characters (!@#$%^&*). Example: 'MyPass123@'. Required for create. Store securely. | |
| roles | No | User role (use exact values): cdata_admin, cdata_standard, cdata_job_creator, or cdata_support | |
| active | No | Enable/disable user access. Inactive users cannot log in. | |
| federationId | No | SSO federation ID. Enables single sign-on authentication. | |
| expiredIn | No | Days until auth token expires (update only). Useful for API access tokens. | |
| users | No | Array of users for bulk creation. Efficient for adding multiple users at once. | |
| workspaceId | No | Workspace ID to use for this operation. Overrides the default workspace. Use 'default' for the default workspace or a UUID for specific workspaces. |