Tableau Connector for Snapchat Ads

Build 23.0.8839


Lists all members for a specific organization.


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 INTO Members (OrganizationId, Email, DisplayName) VALUES ('ca67fb1a-2653-495d-9446-c9e8a30f6232', '', 'Member 0')


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


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


Name Type ReadOnly References Description
Id [KEY] String False

Member Id.

OrganizationId String False


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.

使用できる値は次のとおりです。INVITED, MEMBER

Email String False

Email address of the user.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839