Cmdlets for Snapchat Ads

Build 24.0.8963

FundingSources

Lists all funding sources for the specified Organization.

Select

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

  • Id supports the following operator: =,IN
  • OrganizationId supports the following operators: =,IN; If no value is specified, the cmdlet 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963