OrderLines
Get the order lines associated with an ad account.
View-Specific Information
SELECT
The add-in uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the add-in.
| Column | Supported Operators |
| Id | = |
| AdAccountId | = |
For example:
SELECT * FROM OrderLines WHERE AdAccountId = '549768561505'
SELECT * FROM OrderLines WHERE AdAccountId = '549768561505' AND Id = '2680059247422'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Order line ID. | |
| AdAccountId | String |
AdAccounts.Id | The unique identifier of the ad account this order line belongs to. |
| Name | String | Order line name. | |
| Status | String | Order line status.
The allowed values are ACTIVE, PAUSED, DELETED. | |
| Type | String | The type of the entity. Always orderline. | |
| Budget | Long | Order line budget in micro currency. | |
| PaidBudget | Long | Order line paid budget in micro currency. | |
| PaidType | String | Order line paid type.
The allowed values are PAID, BONUS, MAKE_GOOD, TEST. | |
| PurchaseOrderId | String | Purchase order ID. | |
| StartTime | Datetime | Start time of the order line. | |
| EndTime | Datetime | End time of the order line. | |
| CampaignIds | String | Associated list of campaign IDs. |