Organizations

Lists all the organizations where the authenticated user has access.

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: =,IN

The following queries are processed server side:

    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.

Excel Add-In for Snapchat Ads

Organizations

Select

Columns