Power BI Connector for Snapchat Ads

Build 23.0.8839


Lists all invoices for a given Ad Account.


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: =
  • AccountId supports the following operators: =,IN; If specified, it will override the value of the AccountId connection property. Otherwise, if no value is specified, the 本製品 will try to get the first account from the list returned by the Accounts view.
The following queries are processed server side:
    SELECT * FROM Invoices WHERE AccountId = '4b591696-3017-4852-85d2-dc7d50157153'
    SELECT * FROM Invoices WHERE AccountId = '4b591696-3017-4852-85d2-dc7d50157153' AND Id = '861b7c55-7e35-4348-918f-3758db350b80'


Name Type References Description
Id [KEY] String Invoice ID.
AccountId [KEY] String


Ad Account ID.
OrganizationId String


The ID of the organization.
NetsuiteFileId String Snap Internal ID.
CustomerName String Customer name.
CustomerNetsuiteId String Snap Internal ID.
DocumentNumber Int Document number.
LineLastModified Datetime The date when the line was last updated.
LastModified Datetime The date when the invoice was last updated.
Amount Decimal Invoice amount.
Currency String Currency of the invoice.

使用できる値は次のとおりです。AUD, CAD, EUR, GBP, USD, SEK, DKK, NOK

BillingPeriod String Specifies the billing period.
DueDate Datetime Due date of the invoice.
CreatedAt Datetime The creation date of the invoice.
InvoiceStatus String Indicates whether the invoice has been collected.


InvoiceContent String Bytestream (Base64), this Bytestream can turned into a PDF.

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