Lists all members for a specific organization.

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
• OrganizationId supports the following operators: =,IN; If no value is specified, the connector will try to get the first organization from the list returned by the Organizations view.

The following queries are processed server side:

    SELECT * FROM Members WHERE OrganizationId = '2e874d37-a1d5-4579-9f7c-331deb8082b8'
    SELECT * FROM Members WHERE OrganizationId IN ('2e874d37-a1d5-4579-9f7c-331deb8082b8', '331deb8082b8-a1d5-4579-9f7c-2e874d37')
    SELECT * FROM Members WHERE Id = '69b96ded-4871-4750-83ba-8f19507f6bdd'
    SELECT * FROM Members WHERE Id IN ('69b96ded-4871-4750-83ba-8f19507f6bdd', '8f19507f6bdd-69b96ded-4871-4750-83ba')

Insert

INSERT INTO Members (OrganizationId, Email, DisplayName) VALUES ('ca67fb1a-2653-495d-9446-c9e8a30f6232', '[email protected]', 'Member 0')

Update

UPDATE Members SET DisplayName = 'Member 0 (Updated Name)' WHERE Id = '6a0f3939-cd2b-4e35-b539-a9a68ce579e7'

Delete

DELETE Members WHERE Id = '6a0f3939-cd2b-4e35-b539-a9a68ce579e7'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		Member Id.
OrganizationId	String	False	Organizations.Id	The ID of the organization.
DisplayName	String	False		Name of the user.
CreatedAt	Datetime	False		The creation date of the entity.
UpdatedAt	Datetime	False		The date when the entity was last updated.
MemberStatus	String	False		Name of the Advertiser. The allowed values are INVITED, MEMBER.
Email	String	False		Email address of the user.