SSIS Components for Snapchat Ads

Build 24.0.9062

Invoices

Lists all invoices for a given Ad Account.

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: =
  • 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'

Columns

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

Accounts.Id

Ad Account ID.
OrganizationId String

Organizations.Id

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.

使用できる値は次のとおりです。COLLECTED, SENT_FOR_COLLECTION

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

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