API Data Provider - Online Help

Subscriptions

Returns a site's subscriptions.

Columns

Name Type References
Id [KEY] String
Object String
Uuid String
AccountId String
AccountBillTo String
AccountCode String
AccountCompany String
AccountEmail String
AccountFirstName String
AccountLastName String
AccountObject String
AccountParentAccountId String
PlanCode String
PlanId String
PlanName String
PlanObject String
State String
ShippingAddressAccountId String
ShippingAddressCity String
ShippingAddressCompany String
ShippingAddressCountry String
ShippingAddressCreatedAt Datetime
ShippingAddressEmail String
ShippingAddressFirstName String
ShippingAddressId String
ShippingAddressLastName String
ShippingAddressNickname String
ShippingAddressObject String
ShippingAddressPhone String
ShippingAddressPostalCode String
ShippingAddressRegion String
ShippingAddressStreet1 String
ShippingAddressStreet2 String
ShippingAddressUpdatedAt Datetime
ShippingAddressVatNumber String
ShippingAmount Double
ShippingMethodCode String
ShippingMethodId String
ShippingMethodName String
ShippingMethodObject String
ShippingObject String
CouponRedemptions String
ActivatedAt Datetime
AddOns String
AddOnsTotal Double
AutoRenew Boolean
BankAccountAuthorizedAt Datetime
BillingInfoId String
CreatedAt Datetime
CanceledAt Datetime
ExpiresAt Datetime
UpdatedAt Datetime
CollectionMethod String
PoNumber String
Quantity Integer
RemainingBillingCycles Integer
RemainingPauseCycles Integer
RenewalBillingCycles Integer
RevenueScheduleType String
Subtotal Double
TermsAndConditions String
TotalBillingCycles Integer
TrialEndsAt Datetime
TrialStartedAt Datetime
UnitAmount Double
Currency String
CurrentPeriodEndsAt Datetime
CurrentPeriodStartedAt Datetime
CurrentTermEndsAt Datetime
CurrentTermStartedAt Datetime
CustomFields String
CustomerNotes String
ExpirationReason String
NetTerms Integer
PausedAt Datetime
PendingChangeActivateAt Datetime
PendingChangeActivated Boolean
PendingChangeAddOns String
PendingChangeCreatedAt Datetime
PendingChangeCustomFields String
PendingChangeDeletedAt Datetime
PendingChangeId String
PendingChangeInvoiceCollectionChargeInvoiceAccountBillTo String
PendingChangeInvoiceCollectionChargeInvoiceAccountCode String
PendingChangeInvoiceCollectionChargeInvoiceAccountCompany String
PendingChangeInvoiceCollectionChargeInvoiceAccountEmail String
PendingChangeInvoiceCollectionChargeInvoiceAccountFirstName String
PendingChangeInvoiceCollectionChargeInvoiceAccountId String
PendingChangeInvoiceCollectionChargeInvoiceAccountLastName String
PendingChangeInvoiceCollectionChargeInvoiceAccountObject String
PendingChangeInvoiceCollectionChargeInvoiceAccountParentAccountId String
PendingChangeInvoiceCollectionChargeInvoiceAddressCity String
PendingChangeInvoiceCollectionChargeInvoiceAddressCompany String
PendingChangeInvoiceCollectionChargeInvoiceAddressCountry String
PendingChangeInvoiceCollectionChargeInvoiceAddressFirstName String
PendingChangeInvoiceCollectionChargeInvoiceAddressLastName String
PendingChangeInvoiceCollectionChargeInvoiceAddressNameOnAccount String
PendingChangeInvoiceCollectionChargeInvoiceAddressPhone String
PendingChangeInvoiceCollectionChargeInvoiceAddressPostalCode String
PendingChangeInvoiceCollectionChargeInvoiceAddressRegion String
PendingChangeInvoiceCollectionChargeInvoiceAddressStreet1 String
PendingChangeInvoiceCollectionChargeInvoiceAddressStreet2 String
PendingChangeInvoiceCollectionChargeInvoiceBalance Double
PendingChangeInvoiceCollectionChargeInvoiceBillingInfoId String
PendingChangeInvoiceCollectionChargeInvoiceClosedAt Datetime
PendingChangeInvoiceCollectionChargeInvoiceCollectionMethod String
PendingChangeInvoiceCollectionChargeInvoiceCreatedAt Datetime
PendingChangeInvoiceCollectionChargeInvoiceCreditPayments String
PendingChangeInvoiceCollectionChargeInvoiceCurrency String
PendingChangeInvoiceCollectionChargeInvoiceCustomerNotes String
PendingChangeInvoiceCollectionChargeInvoiceDiscount Double
PendingChangeInvoiceCollectionChargeInvoiceDueAt Datetime
PendingChangeInvoiceCollectionChargeInvoiceHasMoreLineItems Boolean
PendingChangeInvoiceCollectionChargeInvoiceId String
PendingChangeInvoiceCollectionChargeInvoiceLineItems String
PendingChangeInvoiceCollectionChargeInvoiceNetTerms Integer
PendingChangeInvoiceCollectionChargeInvoiceNumber String
PendingChangeInvoiceCollectionChargeInvoiceObject String
PendingChangeInvoiceCollectionChargeInvoiceOrigin String
PendingChangeInvoiceCollectionChargeInvoicePaid Integer
PendingChangeInvoiceCollectionChargeInvoicePoNumber String
PendingChangeInvoiceCollectionChargeInvoicePreviousInvoiceId String
PendingChangeInvoiceCollectionChargeInvoiceRefundableAmount Double
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressAccountId String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressCity String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressCompany String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressCountry String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressCreatedAt Datetime
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressEmail String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressFirstName String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressId String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressLastName String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressNickname String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressObject String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressPhone String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressPostalCode String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressRegion String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressStreet1 String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressStreet2 String
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressUpdatedAt Datetime
PendingChangeInvoiceCollectionChargeInvoiceShippingAddressVatNumber String
PendingChangeInvoiceCollectionChargeInvoiceState String
PendingChangeInvoiceCollectionChargeInvoiceSubscriptionIds String
PendingChangeInvoiceCollectionChargeInvoiceSubtotal Double
PendingChangeInvoiceCollectionChargeInvoiceTax Double
PendingChangeInvoiceCollectionChargeInvoiceTaxInfoRate Double
PendingChangeInvoiceCollectionChargeInvoiceTaxInfoRegion String
PendingChangeInvoiceCollectionChargeInvoiceTaxInfoType String
PendingChangeInvoiceCollectionChargeInvoiceTermsAndConditions String
PendingChangeInvoiceCollectionChargeInvoiceTotal Double
PendingChangeInvoiceCollectionChargeInvoiceTransactions String
PendingChangeInvoiceCollectionChargeInvoiceType String
PendingChangeInvoiceCollectionChargeInvoiceUpdatedAt Datetime
PendingChangeInvoiceCollectionChargeInvoiceVatNumber String
PendingChangeInvoiceCollectionChargeInvoiceVatReverseChargeNotes String
PendingChangeInvoiceCollectionCreditInvoices String
PendingChangeInvoiceCollectionObject String
PendingChangeObject String
PendingChangePlanCode String
PendingChangePlanId String
PendingChangePlanName String
PendingChangePlanObject String
PendingChangeQuantity Integer
PendingChangeRevenueScheduleType String
PendingChangeShippingAddressAccountId String
PendingChangeShippingAddressCity String
PendingChangeShippingAddressCompany String
PendingChangeShippingAddressCountry String
PendingChangeShippingAddressCreatedAt Datetime
PendingChangeShippingAddressEmail String
PendingChangeShippingAddressFirstName String
PendingChangeShippingAddressId String
PendingChangeShippingAddressLastName String
PendingChangeShippingAddressNickname String
PendingChangeShippingAddressObject String
PendingChangeShippingAddressPhone String
PendingChangeShippingAddressPostalCode String
PendingChangeShippingAddressRegion String
PendingChangeShippingAddressStreet1 String
PendingChangeShippingAddressStreet2 String
PendingChangeShippingAddressUpdatedAt Datetime
PendingChangeShippingAddressVatNumber String
PendingChangeShippingAmount Double
PendingChangeShippingMethodCode String
PendingChangeShippingMethodId String
PendingChangeShippingMethodName String
PendingChangeShippingMethodObject String
PendingChangeShippingObject String
PendingChangeSubscriptionId String
PendingChangeUnitAmount Double
PendingChangeUpdatedAt Datetime

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