JDBC Driver for Pipedrive

Build 22.0.8462

Subscriptions

Returns details of an installment or a recurring Subscription

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

ID of the Subscription.

AddTime Datetime True

AddTime.

CadenceType String False

Interval between payments.

The allowed values are weekly, monthly, quarterly, yearly.

Currency String False

The currency of the Installment Subscription. Accepts a 3-character currency code.

CycleAmount Double False

Amount of each payment.

CyclesCount Integer False

Shows how many payments the Subscription has.

DealId Integer False

ID of the Deal this Installment Subscription is associated with.

Description String False

Description of the Recurring Subscription.

EndDate Date False

EndDate.

FinalStatus String True

FinalStatus.

Infinite Boolean False

This indicates that the Recurring Subscription will last until it's manually canceled or deleted.

IsActive Boolean True

IsActive.

LifetimeValue Double True

LifetimeValue.

StartDate Date False

Start date of the Recurring Subscription. Format: YYYY-MM-DD

UpdateTime Datetime False

UpdateTime.

UserId Integer True

UserId.

SubscriptionType String True

SubscriptionType.

The allowed values are recurring, installment.

The default value is recurring.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Payments String

Array of payments.

EffectiveDate Date

Array of payments.

UpdateDealValue Boolean

Indicates that the Deal value must be set to Recurring Subscription's MRR value.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462