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.

The following queries are processed server side:

    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	Organizations.Id	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.
Email	String		Email associated with Paypal.

JDBC Driver for Snapchat Ads

FundingSources

Select

Columns