BillingProfiles
Get billing profiles in the advertiser account.
View-Specific Information
SELECT
The connector uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the connector.
IsActive is a required column to query this view.
| Column | Supported Operators |
| AdAccountId | = |
| IsActive | = |
For example:
SELECT * FROM BillingProfiles WHERE AdAccountId = '549768561505' AND IsActive = false
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Billing ID. | |
| AdAccountId | String |
AdAccounts.Id | The unique identifier of the ad account associated with these billing profiles. |
| AdvertiserId | String | Advertiser ID of the billing. | |
| BillingType | String | Billing type of the advertiser.
The allowed values are CREDIT_CARD, INVOICE, INTERNAL, RECURRING, PREPAID. | |
| CardType | String | Type of the credit card.
The allowed values are UNKNOWN, VISA, MASTERCARD, AMERICAN_EXPRESS, DISCOVER, ELO. | |
| PaymentMethodBrand | String | Brand of the payment method.
The allowed values are UNKNOWN, VISA, MASTERCARD, AMERICAN_EXPRESS, DISCOVER, SOFORT, DINERS_CLUB, ELO, CARTE_BANCAIRE. | |
| Status | String | Status of the billing.
The allowed values are UNSPECIFIED, VALID, INVALID, PENDING, DELETED, SECONDARY, PENDING_SECONDARY. | |
| IsActive | Boolean | Return active billing profiles when true; return all billing profiles when false. |