FundingSources
Lists all funding sources for the specified Organization.
Select
The 本製品 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 本製品.
- Id supports the following operator: =,IN
- OrganizationId supports the following operators: =,IN; If no value is specified, the 本製品 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.
使用できる値は次のとおりです。LINE_OF_CREDIT, CREDIT_CARD, COUPON, PAYPAL | |
Status | String | Status of the funding source.
使用できる値は次のとおりです。ACTIVE, REDEEMED, SPENT, EXPIRED, DELETED | |
BudgetSpent | Decimal | Budget Spent. | |
Currency | String | Account currency.
使用できる値は次のとおりです。USD, CAD, GBP, AUD, EUR | |
TotalBudget | Decimal | Total Budget. | |
AvailableCredit | Decimal | Total available credit. | |
CardType | String | Credit Card Type.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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. |