SSIS Components for Claude Compliance

Build 26.0.9770

OrgSsoToggled

Returns only org_sso_toggled activities.

View-Specific Information

Select

This view always requests the org_sso_toggled activity type. Type is fixed and cannot be changed in the query.

The actor union is flattened into ActorType and nullable Actor* detail columns. Fields that do not apply to the row's actor variant are null.

The component uses the Claude Compliance API to process WHERE clause conditions built with the following columns and operators server-side. The rest of the filter is processed client-side within the component.

The API processes supported ordering server-side. Unsupported ordering, grouping, and offsets are processed client-side within the component. Without an ORDER BY clause, the API returns results newest-first.

ColumnSupported Operators
ActorId, ActorUserId=, IN
OrganizationId, OrganizationUuid=, IN
CreatedAt>, >=, <, <=

  • ORDER BY CreatedAt ASC or DESC
  • LIMIT

	SELECT Id, CreatedAt, ActorType, ActorUserId FROM OrgSsoToggled WHERE CreatedAt >= '2026-01-01T00:00:00Z' LIMIT 100;
	SELECT * FROM OrgSsoToggled WHERE OrganizationUuid = 'abcdef01-2345-6789-abcd-ef0123456789' AND ActorId = 'user_123' LIMIT 100;

Columns

Name Type Description
Id [KEY] String The activity Id.
CreatedAt Datetime Activity time. Filterable with created_at ranges.
OrganizationId String Organization Id filterable via organization_ids.
OrganizationUuid String Organization UUID filterable via organization_ids.
ActorType String The actor union discriminator.
ActorEmailAddress String The email address for user_actor or anthropic_actor.
ActorUserId String The user Id for user_actor. Filterable through user_ids.
ActorIpAddress String The source IP address for the actor variant.
ActorUserAgent String The source user agent for the actor variant.
Type String Always org_sso_toggled.
Enabled Boolean Whether SSO was enabled.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
ActorId String Filters with actor_ids.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770