Organizations
Lists all the organizations where the authenticated user has access.
Select
The connector 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 connector.
- Id supports the following operator: =,IN
SELECT * FROM Organizations WHERE Id = '69b96ded-4871-4750-83ba-8f19507f6bdd'
SELECT * FROM Organizations WHERE Id IN ('69b96ded-4871-4750-83ba-8f19507f6bdd', '83ba-69b96ded-4871-4750-8f19507f6b')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier of the organization. | |
| Name | String | The organization name. | |
| CreatedAt | Datetime | Identifies the date and time when the organization was created. | |
| UpdatedAt | Datetime | Identifies the date and time when the organization was updated. | |
| AddressLine1 | String | Address line 1. | |
| Locality | String | Locality. | |
| AdministrativeDistrictLevel1 | String | AdministrativeDistrictLevel. | |
| Country | String | Country. | |
| PostalCode | String | Zip/Postal Code. | |
| ContactEmail | String | Contact email. | |
| ContactName | String | Contact name. | |
| ContactPhone | String | Contact phone. | |
| Type | String | The organization type. | |
| State | String | The organization state. | |
| Roles | String | Roles. | |
| ConfigurationSettings | String | Configuration settings. |