Lists all the billing centers for the specified 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 BillingCenters WHERE OrganizationId = '2e874d37-a1d5-4579-9f7c-331deb8082b8'
    SELECT * FROM BillingCenters WHERE OrganizationId IN ('2e874d37-a1d5-4579-9f7c-331deb8082b8', '331deb8082b8-a1d5-4579-9f7c-2e874d37')
    SELECT * FROM BillingCenters WHERE Id = '2e874d37-a1d5-4579-9f7c-331deb8082b8'
    SELECT * FROM BillingCenters WHERE Id IN ('2e874d37-a1d5-4579-9f7c-331deb8082b8', '9f7c-a1d5-4579-9f7c-331deb8082b8')

Insert

INSERT INTO BillingCenters (OrganizationId, Name, EmailAddress, AddressLine1, Locality, AdministrativeDistrictLevel1, Country, PostalCode, AlternativeEmailAddresses) VALUES ('ca67fb1a-2653-495d-9446-c9e8a30f6232', 'Kianjous Billing Center', '[email protected]', '10 Honey Bear Road', 'London', 'GB-LND', 'GB', 'NW1 4RY', '["[email protected]"]')

Update

UPDATE BillingCenters SET Name = 'Updated Billing Center Name' WHERE Id = '19247038-c858-4802-b786-40c162228e18'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		ID of the billing center.
OrganizationId	String	False	Organizations.Id	The ID of the organization.
Name	String	False		Name of the Billing Center.
CreatedAt	Datetime	False		The creation date of the entity.
UpdatedAt	Datetime	False		The date when the entity was last updated.
EmailAddress	String	False		Email address.
AddressLine1	String	False		Address line 1.
Locality	String	False		Locality.
AdministrativeDistrictLevel1	String	False		District.
Country	String	False		Country.
PostalCode	String	False		Post code.
AlternativeEmailAddresses	String	False		Array of email addresses.