SSIS Components for Square

Build 24.0.9060

SubscriptionEvents

Lists all events for a specific subscription.

Table Specific Information

Select

The component will execute all filters to this view client-side, in memory.

Retrieve the list of all subscription events for a subscription id. The Subscription Id is required to access the view.

SELECT * from SubscriptionEvents where Id = 'fd9d6200-bb12-43c5-9973-070bfc6f5e05'

Columns

Name Type Description
Id [KEY] String The ID of the subscription event.
SubscriptionEventType String Type of the subscription event.
PlanVariationId String The ID of the subscription plan variation associated with the subscription.
EffectiveDate Datetime The YYYY-MM-DD-formatted date when the subscription event occurred.
InfoDetail String A human-readable explanation for the subscription event.
InfoCode String An info code indicating the subscription event that occurred.
PhasesUID String The id of subscription phase.
PhasesOrdinal Int64 The index of phase in total subscription plan.
PhasesOrderTemplateId String The id of order to be used in billing.
PhasesPlanPhaseUID String The uid from the plan's phase in catalog.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060