Invoices
Lists all invoices for a given Ad Account.
Select
The add-in 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 add-in.
- 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 add-in will try to get the first account from the list returned by the Accounts view.
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 | 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.
The allowed values are 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.
The allowed values are COLLECTED, SENT_FOR_COLLECTION. | |
| InvoiceContent | String | Bytestream (Base64), this Bytestream can turned into a PDF. |