BusinessAssets
Get all the assets the requesting business has access to, including assets the business owns and assets accessed through partnerships.
View-Specific Information
SELECT
The connector 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 connector.
BusinessId is a required column to query this view.
| Column | Supported Operators |
| BusinessId | = |
| AssetType | = |
| Permissions | = |
| ChildAssetId | = |
| AssetGroupId | = |
For example:
SELECT * FROM BusinessAssets WHERE BusinessId = '549768561505'
SELECT * FROM BusinessAssets WHERE BusinessId = '549768561505' AND AssetType = 'CATALOG'
Columns
| Name | Type | References | Description |
| BusinessId | String | The unique identifier of the requesting business. | |
| AssetId [KEY] | String | Unique identifier of a business asset. | |
| AssetType | String | Type of the asset. Filtering defaults to AD_ACCOUNT server-side when omitted.
The allowed values are AD_ACCOUNT, MERCHANT, PROFILE, ASSET_GROUP, PINNER_LIST, CONVERSION_TAG, CATALOG, CONVERSION_SEGMENT. | |
| Permissions | String | Permission levels the requesting business has on the asset.
The allowed values are ADMIN, ANALYST, FINANCE_MANAGER, FINANCE_EDIT, FINANCE_VIEW, AUDIENCE_MANAGER, CAMPAIGN_MANAGER, CATALOGS_MANAGER, CATALOGS_VIEWER, PROFILE_PUBLISHER, OWNER. | |
| CatalogType | String | The catalog type. Populated only when AssetType is CATALOG. | |
| CatalogId | String | The catalog ID. Populated only when AssetType is CATALOG. | |
| CatalogName | String | The catalog name. Populated only when AssetType is CATALOG. | |
| AdAccountInfoTargetingRmnBusinessId | String | RMN business ID for the ad account. Populated only when AssetType is AD_ACCOUNT. | |
| AssetGroupInfoId | String | The asset group ID. Populated only when AssetType is ASSET_GROUP. | |
| AssetGroupName | String | The name of the asset group. | |
| AssetGroupDescription | String | The description of the asset group. | |
| AssetGroupTypes | String | A list of asset group types. | |
| AssetGroupInfoAdAccountsIds | String | A list of ad account IDs under the asset group. | |
| AssetGroupCatalogsIds | String | A list of catalog IDs under the asset group. | |
| AssetGroupProfilesIds | String | A list of profile IDs under the asset group. | |
| AssetGroupCreatedTime | Datetime | The time the asset group was created. | |
| AssetGroupUpdatedTime | Datetime | The time the asset group was last updated. | |
| AssetGroupCreatedByEmail | String | The email of the user who created the asset group. | |
| AssetGroupCreatedById | String | The ID of the user who created the asset group. | |
| AssetGroupCreatedByUsername | String | The username of the user who created the asset group. | |
| AssetGroupOwnerEmail | String | The email of the asset group owner. | |
| AssetGroupOwnerId | String | The ID of the asset group owner. | |
| AssetGroupOwnerUsername | String | The username of the asset group owner. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| ChildAssetId | String | A child asset unique identifier. Used to fetch asset groups that contain the asset id as a child. | |
| AssetGroupId | String | An asset group unique identifier. Used to fetch assets contained within the specified asset group. |