FundingSources

Lists all funding sources for the specified Organization.

Select

The component 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 component.

Id supports the following operator: =,IN
OrganizationId supports the following operators: =,IN; If no value is specified, the component 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. 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.
Email	String		Email associated with Paypal.

SSIS Components for Snapchat Ads

FundingSources

Select

Columns