FundingSources
Lists all funding sources for the specified Organization.
Select
The driver will use the Snapchat Ads API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- Id supports the following operator: =,IN
- OrganizationId supports the following operators: =,IN; If no value is specified, the driver will try to get the first organization from the list returned by the Organizations view.
SELECT * FROM FundingSources WHERE OrganizationId = '2e874d37-a1d5-4579-9f7c-331deb8082b8'
SELECT * FROM FundingSources WHERE OrganizationId IN ('2e874d37-a1d5-4579-9f7c-331deb8082b8', '331deb8082b8-a1d5-4579-9f7c-2e874d37')
SELECT * FROM FundingSources WHERE Id = '69b96ded-4871-4750-83ba-8f19507f6bdd'
SELECT * FROM FundingSources WHERE Id IN ('69b96ded-4871-4750-83ba-8f19507f6bdd', '83ba-69b96ded-4871-4750-8f19507f6bdd')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | ID of the funding source. | |
| OrganizationId | String | The id of the organization. | |
| CreatedAt | Datetime | Date of creation. | |
| UpdatedAt | Datetime | Date of last update. | |
| Type | String | Funding Source type.
The allowed values are LINE_OF_CREDIT, CREDIT_CARD, COUPON, PAYPAL. | |
| Status | String | Status of the funding source.
The allowed values are ACTIVE, REDEEMED, SPENT, EXPIRED, DELETED. | |
| BudgetSpent | Decimal | Budget Spent. | |
| Currency | String | Account currency.
The allowed values are USD, CAD, GBP, AUD, EUR. | |
| TotalBudget | Decimal | Total Budget. | |
| AvailableCredit | Decimal | Total available credit. | |
| CardType | String | Credit Card Type.
The allowed values are AMEX, DINERS_CLUB, DISCOVER, JCB, MAESTRO, MASTERCARD, VISA, UNKNOWN. | |
| Name | String | Name of the Credit Card. | |
| Last4 | Int | Last 4 digits of the Credit Card. | |
| ExpirationYear | Int | Expiration year of the Credit Card. | |
| ExpirationMonth | Int | Expiration month of the Credit Card. | |
| DailySpendLimit | Decimal | Daily spend limit for Credit Card. | |
| DailySpendLimitCurrency | String | Currency for the DailySpendLimit.
The allowed values are USD, CAD, GBP, AUD, EUR. | |
| Value | Decimal | Value of the COUPON. | |
| StartDate | Datetime | Start date of the COUPON. | |
| EndDate | Datetime | End date of the COUPON. | |
| String | Email associated with Paypal. |