Skip to main content

billing_plans

Creates, updates, deletes, gets or lists a billing_plans resource.

Overview

Namebilling_plans
TypeResource
Idvercel.integrations.billing_plans

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring
namestring
coststring
descriptionstring
detailsarray
disabledboolean (false, true)
effective_datestring (wire: effectiveDate)
highlighted_detailsarray (wire: highlightedDetails)
initial_chargestring (wire: initialCharge)
maximum_amountstring (wire: maximumAmount)
maximum_amount_auto_purchase_per_periodstring (wire: maximumAmountAutoPurchasePerPeriod)
minimum_amountstring (wire: minimumAmount)
payment_method_requiredboolean (false, true) (wire: paymentMethodRequired)
preauthorization_amountnumber (wire: preauthorizationAmount)
quotearray
scopestring (installation, resource)
typestring (prepayment, subscription)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectintegration_id_or_slug, product_id_or_slugintegration_configuration_id, metadata, source, team_id, slugGet a list of billing plans for an integration and product.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
integration_id_or_slugstring
product_id_or_slugstring
integration_configuration_idstring (wire: integrationConfigurationId)
metadatastring
slugstringThe Team slug to perform the request on behalf of.
sourcestring
team_idstringThe Team identifier to perform the request on behalf of. (wire: teamId)

SELECT examples

Get a list of billing plans for an integration and product.

SELECT
id,
name,
cost,
description,
details,
disabled,
effective_date,
highlighted_details,
initial_charge,
maximum_amount,
maximum_amount_auto_purchase_per_period,
minimum_amount,
payment_method_required,
preauthorization_amount,
quote,
scope,
type
FROM vercel.integrations.billing_plans
WHERE integration_id_or_slug = '{{ integration_id_or_slug }}' -- required
AND product_id_or_slug = '{{ product_id_or_slug }}' -- required
AND integration_configuration_id = '{{ integration_configuration_id }}'
AND metadata = '{{ metadata }}'
AND source = '{{ source }}'
AND team_id = '{{ team_id }}'
AND slug = '{{ slug }}'
;