Subscription

Subscription: Search

Returns a collection of Subscription response objects.

You can search for subscriptions using a variety of criteria. For operators available on search fields, see the search fields page.

Ruby

collection = gateway.subscription.search do |search|
  search.plan_id.is "the_plan_id"
end

collection.each do |subscription|
  puts subscription.billing_day_of_month
end

If you want to look up a single subscription using its ID, use Subscription: Find instead.

Parameters

:billing_cycles_remainingrange

The number of billing cycles remaining in the subscription.

:created_atrange

The date/time the subscription was created.

:days_past_duerange

The number of days past due the subscription is.

:idtext

The ID of the subscription.

:idsmultiple

A list of subscription IDs to search for.

:in_trial_periodmultiple

Whether the subscription is in a trial period. Can be true or false. This parameter must be used in conjunction with status.

:merchant_account_idmultiple

A list of merchant account IDs to search for.

:merchant_account_id_fragment

A fragment of the merchant account ID to search for.

:containstext

A part of the merchant account ID to search for.

:ends_withtext

A postfix for the merchant account ID to search for.

:istext

An exact merchant account ID to search for.

:is_nottext

A merchant account ID to be excluded from the search.

:starts_withtext

A prefix for the merchant account ID to search for.

:next_billing_daterange

The date the subscription will next be billed.

:plan_idmultiple

A list of plan IDs to search for.

:pricerange

The price of the subscription.

:statusmultiple

The status of the subscription. Possible values:

Active
Canceled
PastDue
Pending
Expired

:transaction_idtext

The transaction ID associated with the subscription.

Examples

Searching by price

Searching on price uses a range field.

Ruby

search_results = gateway.subscription.search do |search|
  search.price <= 5
end

search_results = gateway.subscription.search do |search|
  search.price.between 3, 10
end

Searching by plan ID

Searching on plan ID uses a multiple value field.

Ruby

search_results = gateway.subscription.search do |search|
  search.plan_id.is "gold_plan"
end

search_results = gateway.subscription.search do |search|
  search.plan_id.in "silver_plan", "gold_plan"
end

Searching by status

Searching on status uses a multiple value field.

Ruby

search_results = gateway.subscription.search do |search|
  search.status.is Braintree::Subscription::Status::Active
end

search_results = gateway.subscription.search do |search|
  search.status.in( Braintree::Subscription::Status::Active,
                    Braintree::Subscription::Status::Canceled,
                    Braintree::Subscription::Status::Expired,
                    Braintree::Subscription::Status::PastDue,
                    Braintree::Subscription::Status::Pending )
end

When searching for subscriptions that are active, you have the ability to search for all active subscriptions (with or without a trial period), subscriptions with a trial period, or subscriptions without a trial period.

Ruby

search_results = gateway.subscription.search do |search|
  search.status.is Braintree::Subscription::Status::Active
end

search_results = gateway.subscription.search do |search|
  search.status.is Braintree::Subscription::Status::Active
  search.in_trial_period.is true
end

search_results = gateway.subscription.search do |search|
  search.status.is Braintree::Subscription::Status::Active
  search.in_trial_period.is false
end

Searching by days past due

Searching on days past due uses a range field.

Ruby

search_results = gateway.subscription.search do |search|
  search.days_past_due <= 5
end

search_results = gateway.subscription.search do |search|
  search.days_past_due.between 1, 5
end

Searching by merchant account ID

Searching on merchant account ID acts like a multiple value field.

Ruby

search_results = gateway.subscription.search do |search|
  search.merchant_account_id.in "usd_merchant_account", "another"
end

Searching by billing cycles remaining

Searching on billing cycles remaining will find subscriptions which have a set limit to the number of times they will recur. It uses a range field.

Ruby

search_results = gateway.subscription.search do |search|
  search.billing_cycles_remaining <= 5
end

Searching by next billing date

Searching on next billing date will return subscriptions that will bill again during the date range you have given it. The example below will return any subscriptions that will be billed in the next five days.

Ruby

five_days_from_now = Time.now + (5 * 24 * 60 * 60)

search_results = gateway.subscription.search do |search|
  search.next_billing_date <= five_days_from_now
end

Searching by created-at date/time

Searching on created-at date/time will return subscriptions that were created during the range you have given.

Ruby

search_results = gateway.subscription.search do |search|
  search.created_at.between( Time.now - 60*60*24, Time.now )
end

Searching a combination

You can combine any of the search fields into a single search.

Ruby

search_results = gateway.subscription.search do |search|
  search.plan_id.is "gold_plan"
  search.status.is "Active"
end

Subscription

Subscription: Search

Parameters

Examples

Searching by price

Searching by plan ID

Searching by status

Searching by days past due

Searching by merchant account ID

Searching by billing cycles remaining

Searching by next billing date

Searching by created-at date/time

Searching a combination

See Also